Update items in SharePoint list from Excel Online when i make changes in excel

[sasidhar_mudra]

Hi All,

&

@v-bacao-msft , @Delia_Laudoni, ,

You guys helped me with creating a flow from Excel Online to SP List. Below are the screenshots of the current flow to create new item in sharepoint list. 

I would like to know if there is a possibility updating my SP list item when i change some details in excel online in the same flow. Or do i need to create a new flow for updating the items in the same SP List.

For example, i created the SP list below. If i change manager name of Employee "abc", in excel online i want that change to be updated in SP list. Hope I did not confuse you guys.

Screenshot of list and flow

As always, thank you for your support 🙂

Regards

Sasidhar

[v-bacao-msft · Accepted solution]

Hi @sasidhar_mudra ,

From your configuration point of view, you can configure the Update item action directly in the If no branch and use the ID output from Get items to configure the ID field.

Then use the Dynamic content in the Excel table to configure other fields of the Update item action.

Hope it makes sense.

Best Regards,

[sasidhar_mudra]

@v-bacao-msft ,

Barry,

Yes, I tried after posting this. I did add the Update Item in No branch and it worked :).

However, thanks for responding.

Thanks

Sasidhar