cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Durrans
Frequent Visitor

Flow won't complete once started, just runs endlessly

I have what should be a rather straightforward flow that auto-runs every day at the same time, gets certain types of document from a SharePoint library, checks the expiry date against today's date and updates another column to say 'EXPIRED' if today's date is greater than the expiry date.

When I run the flow, it runs fine and updates the columns for the relevant files. However it never stops! I did one test yesterday and it was running for 16 hours straight and it didn't even finish. There are over 1000 files in the library, 683 of which, according to the flow run, match the filter query I have set in the Get files (properties only) step. I don't know if it should be taking this long.

My flow steps are as below:

SP Expired 1.PNG

In the Today's date compose step I have formatDateTime(utcNow(),'yyyyMMdd')

In the Get files (properties only) step I have set Limit Columns by View to a view without folders to see if it would speed the retrieval of files up but it makes no difference either way.

SP Expired 2.PNG

In the Expiry date compose step I have

formatDateTime(items('Apply_to_each_record_returned_in_Contractor_Information_Point')['Date_x0020_of_x0020_Review'],'yyyyMMdd'). I needed to compose this instead of taking it straight from the SharePoint column so the formats would match.
SP Expired 3.PNG
It's the Apply to each record returned in Contractor Information Point step that never completes in the flow run. I assume there must be something wrong with the Get files (properties only) step but any help would be gladly appreciated! 

 

3 REPLIES 3
Community Support
Community Support

Re: Flow won't complete once started, just runs endlessly

Hi @Durrans,

 

Could you also share a screenshot of your flow run details?

I have made a flow to test this issue according to your description, it just run successfully within a short time.

1.PNG

I don’t have more than 1000 files to test this issue, not sure if it is caused by the number of files.

Please cancel the current flow run then resubmit it to see if it will work.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Durrans
Frequent Visitor

Re: Flow won't complete once started, just runs endlessly

Hi @v-yamao-msft,

 

Not sure what I did to make it work but I got this working a few days ago, thank-you for your reply though!

Community Support
Community Support

Re: Flow won't complete once started, just runs endlessly

Hi @Durrans,

 

Thanks for updating. I am glad to hear that it is working for you now.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (8,496)