Fantastic solution and great explanation! I learned soooo much from this one video. Thank you!
@M4croz
Ай бұрын
Great video!, but for some reason when im using an apply to each it doesnt loop through all my items, only 1, but i already confirmed that there are 2 items in the filter array outputs:c dont know what is happening
@MeisterCrashFM
Жыл бұрын
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)".
@acreativeopinion
Жыл бұрын
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.
@ernestoleon3995
7 ай бұрын
Reeeally helpful thanks!! What about if i want to update the existing data... I have not been able to modify to update existing data.
@acreativeopinion
5 ай бұрын
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.
@vaclavbenysek9576
4 ай бұрын
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.
Пікірлер: 11