Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Excel to Lists not updating

Posted on by 2
Hi,
I've built a flow to take info on an excel table and update a sharepoint list.  When I manually run the flow, it indicates it ran successfully; however, the list remains blank. The excel table is saved in the sharepoint library as well. 
  • Suggested answer
    Inogic Profile Picture
    Inogic 836 on at
    Excel to Lists not updating
    Hi,

    We checked this scenario and noticed that in the "Apply to each3" step, there seems to be an issue because you are retrieving SharePoint list items .and for "Apply to each3" step  there is no data in the retrived Sharepoint list, So according to your flow it will not execute "Apply to each3" step because no data found in the retrived sharepoint List. As a result the SharePoint list is not being updated/Created.Therefore, I suggest using the Excel table rows loop in "Apply to each3" step to Create list Item step.
     
    Hope this helps.
     
     
    Thanks!
    Inogic Professional Services: Power Platform/Dynamics 365 CRM
    An expert technical extension for your techno-functional business needs
    Drop an email at crm@inogic.com 
    Service: https://www.inogic.com/services/ 
    Tips and Tricks: https://www.inogic.com/blog/ 
  • JL-26081836-0 Profile Picture
    JL-26081836-0 2 on at
    Excel to Lists not updating
    Screenshots of the flow
  • Smehra33 Profile Picture
    Smehra33 25 on at
    Excel to Lists not updating
    Please share the flow content to better help you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard