Forum Discussion
Powershell for reading data from excel survey
Hello Community, I need help for a powershell script to read data of excel survey form, I am planning some automation and I love to see if its possible connect to a sharepoint excel survevy form and...
Hi Juan,
The Excel Survey data is going to an excel file at either onedrive or sharepoint not the only thing remain is to have a powershell script running on sharepoint module to get the data out of that excel file.
The Excel Survey data is going to an excel file at either onedrive or sharepoint not the only thing remain is to have a powershell script running on sharepoint module to get the data out of that excel file.
Check if Graph's Drive API workbook endpoint can be of use.
https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0
https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0