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

[Anonymous]

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.

 

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

Thanks, Louie

[v-bacao-msft]

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.

Best Regards,

[Anonymous]

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.

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

[v-bacao-msft]

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,

[Anonymous]

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

Louie