cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivpd
Level: Powered On

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 :

  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

 

 

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Split Field on Sharepoint

Hi @ivpd ,

 

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,

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.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (3,499)