cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Scheduling a flow to run when field is added in SharePoint List

Hi, 

 

Would anyone happen to have any advice on how I could schedule a flow to run based on whether a column is populate in a SharePoint list? Or an alternative suggestion?

 

Currently I have 3 flows which essentially run off one another. 

 

The first flow is essentially a list of tasks in an excel table containing dates, description of tasks to be completed, people to action the tasks etc. which are uploaded to a SharePoint list each minute.

 

The second flow creates a planner task and calendar invitation for when a new list item is created in SharePoint based on the dates/people provided in the excel table.

 

The third flow adds a time stamp to a column in the excel sheet when the planner task is marked as complete so that other members of the business are aware that the task has been completed.

 

However, the issue I'm having is that because we're using excel online and the recurrence is set to 1 minute, if the user hasn't finished adding the key info (such as date/people assigned to the task) by the time the next occurrence happens, the sharepoint list item will be created without the key info, and then fail for the next flow because it hasn't got all of its required fields.

 

I was wondering if it was possible to trigger the flow below only if the relevant fields were populated? E.g preparer, Task ID, Date etc.?

 

Or a suitable alternative method also appreciated. I know I could change the occurrence to say 5 or 10 minutes, however we still have the issue if the fields aren't populated at the time of the flow running.

 flow2.png

 

Any help would be hugely appreciated, the final piece of this straw.

 

Thanks, Louie

 

 

4 REPLIES 4
v-bacao-msft
Community Support
Community Support

 

Hi @Anonymous ,

 

Do you mean that you need to execute Create task action after the field value executed in the item is not empty?

 

If so, you can refer to the following methods to achieve similar requirements.

34.PNG35.PNG36.PNG

 

Best Regards,

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

Hi @v-bacao-msft - seems to be working as expected. However if there's the delay between all of the pre-requisite items not being completed when creating the list item, the flow fails after 1 hour.

 

It basically creates the items with some of the required populated fields originally. Then once I add all of the required fields in Excel it will create a new SharePoint list item with all of the populate fields.snip1.png

 

That's not a problem as the list isn't being used, but it just means that I'll end up with several failed jobs because the original sharepoint list item isn't ever going to be updated as there's a new item. The first occurrence of the job is still 'delaying' waiting for the preparer fields etc. to be populated.

 

Any ideas how I can still get the job to 'succeed'? The "true" expression result will never be met for that item.

 

Hope that makes sense, thanks for your help.

 

Louie

 

Hi @Anonymous ,

 

What I want to find out is, is the item created by Flow or manually created in the list?

 

If the latter, try setting these fields to required.

 

Best Regards,

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

Hi @v-bacao-msft, the item is created by another flow, which polls the rows in a spreadsheet table each minute.

 

 

Louie

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,525)