HI!
i know that based on the documentation How to work with the data. it clearly states that for the Manager Name if the source is a SharePoint List it will only show the ID and not the name. is there any way to change this? or with JavaScript bring the name of the manager?
Also is there anyway to avoid exporting the PochLevelNumber and PochSubordinatesCount in the Export to csv?
Hello @Jeniffer_Rivera,
You can select the fields you want to export by adding the following line of code to the configuration wizard:
api.config.csvExportFields = ["ID", "Title", "Office", "JobTitle"];
I will check with the developers if it is possible to export manager title instead of ID and get back to you shortly.
Hello @Jeniffer_Rivera,
Unfortunately there is no way to export manager title instead of ID, but you can add a simple Excel formula to look manager up in the output CSV.
Add an additional column, for example ManagerTitle, add the following formula there, then copy or drag it down:
=IF(IFERROR(VLOOKUP($B2,$A$1:$C$20,3,FALSE),"")=0,"",IFERROR(VLOOKUP($B2,$A$1:$C$20,3,FALSE),""))
