Answered

Approvals Outcome returns a comma delimited string how do I convert this to an array for use in a Apply to Each card? Split() syntax problem

(0) Share

Report

Posted on by vanalljc

I'm trying to run a multi-stage approvals process in Power Automate. The first Approval involves multiple approvers and the Approval action returns a comma-delimited string in the body/Outcome. I can't pass that to a condition directly (see below)

So I'm wanting to iterate through the list and determine if there are any "reject" responses

I've been trying to convert the comma-delimited string to an array using a Split() to initiate an array variable. I can't seem to figure out the syntax.

copying the dynamic content for the body/outcome i get

@{outputs('Start_and_wait_for_an_approval_-_JHSC')?['body/outcome']}

how to I put that into the Split()?

Split(outputs('Start_and_wait_for_an_approval_-_JHSC')?['body/outcome'],", ") returns invalid syntax

Or is there a more elegant way to achieve the same result?

Thanks

I have the same question (0)

All responses (3)

Answers (1)

Grivollier 39 on at

Like (0)

Report

Re: Approvals Outcome returns a comma delimited string how do I convert this to an array for use in a Apply to Each card? Split() syntax problem

If you set the approval type to "Everyone must approve" then you don't need to go over each one of them, the Outcome parameter of it will give "Approve" if everyone appproves, you can just check that value.

Regards,

Was this reply helpful? Yes No
vanalljc 4 on at

Like (0)

Report

Re: Approvals Outcome returns a comma delimited string how do I convert this to an array for use in a Apply to Each card? Split() syntax problem

Thanks Grivollier,
I already have the approval set to "everyone must approve"
but I'm still getting a comma-delimited string as the output
The approval is in an "Apply to each" because it's the only way I've found to get the email recipients into the approval from our Approvers Matrix.

Was this reply helpful? Yes No
Verified answer

Grivollier 39 on at

Like (0)

Report

Re: Approvals Outcome returns a comma delimited string how do I convert this to an array for use in a Apply to Each card? Split() syntax problem

You could try and find the string "Reject" in that text and if it is found then it was rejected. You should be able to achieve this using the contains() fucntion. The hard way would be to parse the text and check for every item.

Was this reply helpful? Yes No