Unanswered

Upload and Update Excel to SharePoint List

(0) Share

Report

Posted on by RKPA

Hi,

I created upload and update excel flow and the flow says it is running successfully but no data is showing up in the list. As you can see in the screenshot, when I do a run history check it is not letting me select the create item. If I remove the condition, I can create items in the list but I am trying to upload and update. Sync Test 1.PNG Sync Test 2.PNG Sync Test 3.PNG Sync Test 4.PNG

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Hi!
You need to move 'create item' out of the 'Apply to each 2' then remove 'Apply to each 2'

I mean, if 'Get items' output is empty (true branch), 'Apply to each 2' iterates over... 0 elements, so action blocks inside it are never executed.

Same design error as here
https://powerusers.microsoft.com/t5/Building-Flows/Create-new-items-in-SharePoint-list-from-Excel-table-doesn-t/m-p/535175#M69319

Hope this makes sense

Was this reply helpful? Yes No
Verified answer

RKPA 28 on at

Like (0)

Report

Thanks for the information. Would I also need to remove the "apply each" on the "update item" branch or just "create item". Thanks!

Was this reply helpful? Yes No