cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Parsing strings from a single field (delimited with semi-colon, no space), and then generating a DevOps task for each

I'm really struggling with the following scenario. 

 

I have a Work Item Type called "Onboarding" and it has various fields for scope of a given new project. 

 

I have a Flow that will generate an entire E2E program with parent-child nesting, etc, by generating a task for every elective scope item selected in one of the fields of the "Onboarding" WIT. 

 

It all works brilliantly. 

 

However, i have a request to split out one of those child tickets further (create a ticket for each string selected from a field called "Target Devices.").

 

I've been trying to work through it with the following example, but despite trying to mimic it, nothing seems to work.

https://powerusers.microsoft.com/t5/Building-Flows/split-string-and-apply-for-each/td-p/40643

 

The "Apply to each" section is expecting an array of those attributes to key off of, but when i do runs, my Compose function is not generating any kind of array. Because the working portion of my workflow is large and has alot of company data, it would be unwise to try to share here. (I am a MSFT employee). 

 

Would there be someone i could reach out to directly within MSFT to work through this offline?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Fausto,

I was able to sort it out by creating a sub-flow with just the section i was failing on, and go back through the documentation. I think my syntax on split had been wrong, but somehow the flow checker wasnt flagging it as faulty. Once i resolved the lack of a comma witht the following expression, it worked: split(variables('Roles'),';')

 

Thanks for the offer though. Was a good lesson in offloading sub-sections of workflow for rapid isolation and testing. 


Greg

View solution in original post

3 REPLIES 3
Highlighted
Memorable Member
Memorable Member

Hi @gmellis1 

 

What do the strings look like in your "Target Devices" field? You don't have to post the exact strings, but just an example so we can have an idea of what you're working with.

 

Regards,

Fausto Capellan, Jr 

 

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!
Highlighted

Fausto,

I was able to sort it out by creating a sub-flow with just the section i was failing on, and go back through the documentation. I think my syntax on split had been wrong, but somehow the flow checker wasnt flagging it as faulty. Once i resolved the lack of a comma witht the following expression, it worked: split(variables('Roles'),';')

 

Thanks for the offer though. Was a good lesson in offloading sub-sections of workflow for rapid isolation and testing. 


Greg

View solution in original post

Highlighted

Hi @gmellis1 

 

I'm glad you were able to sort it out. Cheers!

Fausto Capellan, Jr
Did I answer your question? Mark my post as a solution! Did my response help? Please give it a thumbs up!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (9,942)