
Announcements
Hello, I'm trying to find a solution to update the single value that is changed on an excel sheet online also on sharepoint. I can do this by deleting and reloading the entire excel sheet by using flows, but I cannot update the single sharepoint value if the single cell in excel is changed.
Is there also the possibility of doing the opposite? If I change a value on sharepoint it also changes on excel? Alternatively, is there any workaround or solution to which I can connect an excel online file and create a "view" page like this?
Regards
Hi!
" Is there also the possibility of doing the opposite? If I change a value on sharepoint it also changes on excel?"
Yes!
You can have a trigger called 'When an item is created or modified', you search for its mirror row on your excel table, if a match is found you update it, if not you add a new row
The strategy is explained here, implemented by means of 'Filter array' and 'Condition'. Please note you have to handle a Unique ID column on your Excel table to correlate with every mirror element in SP list.
https://powerusers.microsoft.com/t5/Building-Flows/Flow-is-creating-duplicate-entries/td-p/466266
Hope this helps