Hello,
I am trying to setup an automation to sync an excel sheet in SharePoint to my SharePoint list.
I am using the “Update List Item in Microsoft SharePoint” action. I am trying to dynamically select all Item IDs, so that all rows and columns of my sheet get updated in the list, even as rows are added.
Is this possible?
+6Hi
Welcome to the Community.
Zapier doesn't support dynamically selecting all Item IDs in a SharePoint list, as actions are performed on individual items. To connect data, create a Zap triggered by the "New Row" event in Excel Online (Business) for SharePoint. Use the "Find List Item" action in Microsoft SharePoint to locate items using a unique identifier from the Excel row, then apply the "Update List Item" action to update fields. Set up a separate Zap with the "Updated Row" trigger for updates to existing Excel rows.
I hope this helps. Let me know if you have any other questions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
