You’re offline. This is a read only version of the page.
517
Hi,
Is there a way to get the data from excel and update the item in SharePoint List?
Say, i have the same columns name both in Excel and SharePoint.
Sample:
Now, initial status for SharePoint List 'Status' is Approved. I want to update the Status in SP List when Excel 'Status' column change to 'Completed'.
Key column is the ID number.
How do I do that? Please help.
Hi @jaina
Thank you for posting.
According to your description, you would like to update item when stauts changed to ‘Completed’ in excel. If any misunderstanding, please kindly let me know.
As we known, there is no trigger for excel. Thus we can only use scheduled flow to track excel file changes maybe every minute.
My excel(ID equals to title in list):
My list (Title here equals to ID in excel):
Here is the flow for your reference:
Flow in detail:
length(outputs('Get_items')?['body/value'])
In yes branch(It means list already contains record with that ID/Title):
In no branch(It means there is on ID matches with ID from excel, so we need to create it based on excel row):
Once tested, I’m able to get rows update once status changed to ‘completed’.
You can also take a look on below video, it explains better.
https://www.youtube.com/watch?v=eDOwoPG9ua8
Hope the content above may help you.
Best regards,
Anna
Share
Report
All responses (
Answers (
