Really great explanation. I still have one tip. It is possible to use contains in the Get Item action. However the ODATA command is another "substringof('Text',FileLeafRef)".
Thanks for watching! Yes you can also use the substringof() operator. However, it doesn't seem to work with the time/date columns which is why a Filter Array action would need to be used instead.
Thanks for watching! To update existing data you need to change the operator in the Filter Array action to contains. This will filter out the items from your Excel Table that already exist in your SharePoint list.
Hi and thank you for the video, I’ve been doing it the wrong/slow way. I have the same question as Ernesto. I get either an array of existing data from excel or list. If I have it from a list I can get the id of the item to update, but I don’t know how to get the right data for that particular row from excel. If I have excel data I can use those, but I don’t know how to get the right list item ID to update. I managed to do it by looping through the excel data, getting array of list items where the unique identifier matches and then for each such found list item update all the values with excel data..not so pretty. Also, it unnecessarily updates items which are not different from the excel data.
Fantastic solution and great explanation! I learned soooo much from this one video. Thank you!
Really great explanation. I still have one tip. It is possible to use contains in the Get Item action. However the ODATA command is another "substringof('Text',FileLeafRef)".
Thanks for watching!
Yes you can also use the substringof() operator. However, it doesn't seem to work with the time/date columns which is why a Filter Array action would need to be used instead.
Thanks for the video.
THIS! Thank you!
Thank you so much for watching!
Reeeally helpful thanks!! What about if i want to update the existing data... I have not been able to modify to update existing data.
Thanks for watching!
To update existing data you need to change the operator in the Filter Array action to contains. This will filter out the items from your Excel Table that already exist in your SharePoint list.
Hi and thank you for the video, I’ve been doing it the wrong/slow way. I have the same question as Ernesto. I get either an array of existing data from excel or list. If I have it from a list I can get the id of the item to update, but I don’t know how to get the right data for that particular row from excel. If I have excel data I can use those, but I don’t know how to get the right list item ID to update.
I managed to do it by looping through the excel data, getting array of list items where the unique identifier matches and then for each such found list item update all the values with excel data..not so pretty. Also, it unnecessarily updates items which are not different from the excel data.
How can I reach you if I have questions?