Power Platform Community Forum Thread Details

Split Field on Sharepoint

Hi,

I have an App on Powerapps where i have 3 task

Task 1

Task 2 that depends of Task 1

Task 3 that depends of Task 1 and Task 2

So, I have a Predecessor_Task Field on Sharepoint where i save the ID of each Task.

When i finished Task 1 i call an Flow where i search about what tasks depends of This task and send Email notifications to star these Tasks.

So. i create a conditions

If Predecessor_Task is equal to ID ->Send Email

I have the flow created until here.

The problem is the next, i have some records where i have 2 or mas task separated with comma, for example Task 3. She depends of Task1 and Task2 to start and send notifications and into Predecessor_Task i saved (1, 2)

So, continuos with the last "IF" ... en case FALSE i need to create another conditions and ask :

If Predecessor_Task contains ID :

In case False: do nothing
In case TRUE: i need to split the Predecessor_Task Field and search for each ID to know if all task are completed or not (Task_Status field)... In case true... Send Email.

How can i do this? I need the step by step please

Quick Links

Leaderboard