Answered

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

All responses (2)

Answers (1)

Verified answer

RKPA 28 on at

Like (0)

Report

Re: Upload and Update Excel to SharePoint List

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

Like (0)

Report

Re: Upload and Update Excel to SharePoint List

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