web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Split Field on Sharepoint
Power Automate
Unanswered

Split Field on Sharepoint

(0) ShareShare
ReportReport
Posted on by

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 :

  1. In case False: do nothing
  2. 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

 

 

 

Categories:
I have the same question (0)
  • v-bacao-msft Profile Picture
    on at

    Hi @Anonymous ,

     

    Could you please share the Flow you have created about task 1?

    About the column of or_task you mentioned, can you share an example? What data type of column is stored in SharePoint list? From your description, it may be text type, I am not sure.

    If you want to split strings, you can use split() function: functions-reference#split

    E.g. split (' or_task ', ', ')

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard