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

Announcements

News and Announcements icon
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 Microsoft Employee

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
    Microsoft Employee 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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 481

#2
11manish Profile Picture

11manish 278

#3
David_MA Profile Picture

David_MA 276 Super User 2026 Season 1

Last 30 days Overall leaderboard