Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / Scheduled flow to Impo...
Power Automate - Using Flows
Unanswered

Scheduled flow to Import Excel Items to SP list

(0) ShareShare
ReportReport
Posted on by sherif77

Hello,


I have scheduled a Flow that runs every hour to Import Excel Items to SP list The Importation goes smoothly without any problems however once the Flow Import the 5K Rows in my Excel Files it re-import all the List again and again,

 

I set the flow once any item imported the Status for such item changes its Transfer Status to Transferred.


I'm not sure what makes such infinite loop even I’m Setting a condition if Transfer Status = "Pending" flow should copy the line. & another condition if Transfer Status not equal Transferred. even removed the Second condition and the results as is.

 

appreciating your detailed explanation by putting any expressions clear in your reply as I'm a bit new to the flow process. Thank you In advance.

sherif77_1-1616913670125.pngsherif77_2-1616913713010.png

sherif77_3-1616913746423.png

 

  • DamoBird365 Profile Picture
    DamoBird365 8,942 Microsoft Employee on at
    Re: Scheduled flow to Import Excel Items to SP list

    Hi @sherif77 

     

    How are you getting on?

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien

    P.S. take a look at my new blog here

  • DamoBird365 Profile Picture
    DamoBird365 8,942 Microsoft Employee on at
    Re: Scheduled flow to Import Excel Items to SP list

    Hi @sherif77 

     

    Presumably your condition is always evaluating to true?

     

    2 things to consider

    1. insert 2 compose actions (for debug) prior to the condition using the dynamic content you have supplied in the condition action.  You can then run your flow and check the history to see what data is being returned by the dynamic values.  Does it match you condition?  Should it be evaluating true or there something wrong?

    2. try a filter from the list rows action. If you haven't done this, you are returning all rows each time and will eventually have problems with limits and efficiency.  Try and filter based on your column:

    TransferStatus eq 'Pending'

     

    Make sure you get the column name correctly from the body of a run history and also ensure pending is in the correct case.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien

    P.S. take a look at my new blog here

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans