Flow not updating item in sharepoint

[vsingh03]

Hi!

I have created a scheduled flow called active status. It will update the list item in sharepoint depending upon the dates. so, if the project is ongoing (start date is less than or equal to current date and end date is greater than or equal to current date) then the status of project will be active.

However, the flow is running in power automate, but it is not updating sharepoint item. I would like to know if the logic for flow is correct for the ongoing projects. what else could be the problem?

[RobElliott]

@vsingh03 a screenshot of your flow would help us to understand why this might be happening.

[vsingh03]

[vsingh03]

The flow status in power automate shows succeeded, it is up running however, changes are not updated in SharePoint list. I have made sure that site address and list name are correct and same in flows as well.

[RobElliott]

@vsingh03 I can't immediately see anything wrong with your flow so built a flow to check and it worked as expected and updated the list. The only differences with your flow is that the get items action has a filter query to only bring back items where the StartDate is less than or equal to the current date & time - it's more efficient than bringing back everything in the list - and then putting in a condition that checks whether the EndDate is greater than or equal to the current date & time. So it correctly brought back 4 items from the list and updated 3 to be Active. 

Try it with the way I've done it and see if it works.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[vsingh03]

Hi Rob, 

I have tried doing that however, it is still not working. I have attached the screenshot of error. it took 2 hours to test run the flow and at the end it failed. 

[vsingh03]

Hi Rob, 

I have tried doing that however, it is still not working. I have attached the screenshot of error. it took 2 hours to test run the flow and at the end it failed. 

[RobElliott]

I can see that your get items is only bringing back the default maximum of 100 items. You need to go to the settings for the get items action, switch on the pagination toggle and set the threshold to more than the number of items in your list. Once you've done that try it again.

[vsingh03]

do you have any idea why this flow is taking too long to test run, earlier it only took 700-800 ms to execute

[vsingh03]

Hi Rob,

My flow is running more than 2 hrs now, it is very unusual, is it because of any issue?