Forum Discussion
Is there any way to get Form data to SharePoint list?
Kevin_jr export the spreadsheet behind the form and delete the rows which are already in the SharePoint list. Format it as a table and save it. Then build a new flow with a manual trigger, add the Excel Oline List rows present in a table action and point it to the saved spreadsheet and select the table. Then add a SharePoint create item action which will get wrapped in an apply to each action which is expected. The create item action will list all the columns in your list and for each column select the spreadsheet column from the dynamic content box.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Kevin_jr export the spreadsheet behind the form and delete the rows which are already in the SharePoint list. Format it as a table and save it. Then build a new flow with a manual trigger, add the Excel Oline List rows present in a table action and point it to the saved spreadsheet and select the table. Then add a SharePoint create item action which will get wrapped in an apply to each action which is expected. The create item action will list all the columns in your list and for each column select the spreadsheet column from the dynamic content box.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Thanks for you reply, Rob. List rows present in a table action works as expected. I got the responses to SP site.
