Forum Discussion
Add a unique column in an Excel Online Survey
I am creating an Excel Online Survey in OneDrive for business with this https://support.office.com/es-ES/client/results?Shownav=true&lcid=3082&ns=XLWAEndUser&version=15&omkt=es-ES&ver=15&apps=WDWAENDUSER%2CXLWAENDUSER%2CPPWAENDUSER%2CONWAENDUSER procedure.
The survey works fine until a new column is added, in Excel Online's edit view, with an unique identifier for each row. At this point it seams as if the survey ceases to exist.
I want the unique identifier's column to exist in the rows without asking for it in the survey (because it generates automatically) and also continue receiving data from the survey.
Thanks!
The business case I want to solve is:
Obtain the registries form my Survey's public guests -> Get the rows form Excel Online and create a new item in a Sharepoint Online list with a Flow (Each time the OneDrive for business folder's "in which the Excel is hosted" has being modified).
The Flow app is automatically creating the unique identifier column denominated "__PowerAppsId__" in the Excel Online file.
I no longer need to solve this:
With the recent availability of Microsoft Forms Preview to my Enterprise licence I have been able to:
1) Share a survey in Forms to get users input.
2) Get the data with the Form connector in Microsoft Flow and create new items into a SharepointOnline list using its own connector.
3) Transform the data from the SharepointOnline list and display it in a PowerBI report.
It is working fine, thanks!
1 Reply
I no longer need to solve this:
With the recent availability of Microsoft Forms Preview to my Enterprise licence I have been able to:
1) Share a survey in Forms to get users input.
2) Get the data with the Form connector in Microsoft Flow and create new items into a SharepointOnline list using its own connector.
3) Transform the data from the SharepointOnline list and display it in a PowerBI report.
It is working fine, thanks!