Hi @qunq
I think this error occured due to iteration update which is looping in collection (i would say collections update).
Also your design seems to have some logical issues i think so
Try this flow design
I have used below excel templates
Sharepoint List
Now use this flow design
1. Use list rows in table to list all rows under the table
2. Use apply to each loop to loop through all values under the excel table
2.1 Use get items to get the items having memo column equals currently iterating row Memo column value.
(Represented in above screenshot)
2.2 Use condition to check whether the output of get items contains any values or not, if it contain value, it means currently item is existsing and flow need to update it. Else if no values are present, then flow need to create it. See below
Expression used : length(outputs('Get_items')?['body/value'])
If condition is True:
Create Item
If condition is False:
Update existsing Item
Expression:
first(outputs('Get_items')?['body/value'])?['ID']
this expression helps to compute the ID of first item from the array 🙂
Hope it helps !
