Getting a single value from a Parse Json

Like (0) Share

Report

Posted on 13 Dec 2023 16:04:46 by psil101010

Hello,

I am building a flow that takes the data from a Sharepoint List, then selects a value from that array that was created (The Sharepoint List). I then want to pass the array value into an approval step, but the issue I run into is that when I use the output from the SELECT flow as the assigned contact in the approval flow, it instantly makes it a FOR EACH. Which doesn't work since I only want a single output from the approval. My next idea was to use parse json and then compose to take the exact output I am looking for, but I can't seem to get the correct code.

Please see the below images:

I have the same question (0)

All responses (5)

Answers (1)

JonDoesFlow 1,304 on 13 Dec 2023 at 16:45:31

Like (0)

Report

Re: Getting a single value from a Parse Json

This might help you - https://www.jondoesflow.com/post/first

---------------------------------------------------------------------------

If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

Blog - JonDoesFlow
Twitter - JonDoesFlow
YouTube - JonDoesFlow

Was this reply helpful? Yes No
psil101010 11 on 13 Dec 2023 at 16:55:59

Like (0)

Report

Re: Getting a single value from a Parse Json

Hello Jon,

I have attempted this, the issue is that I am using the Select Option after the Get Items, to select a particular value first from the Get Items array. Once I have selected that, I want to be able to pass that through as the Assigned To field for the Approval step.

Was this reply helpful? Yes No
psil101010 11 on 13 Dec 2023 at 16:59:28

Like (0)

Report

Re: Getting a single value from a Parse Json

Please see the error I receive when I attempt to use the first option.

Mind you that I know that the admin email it is outputting is correct. It just isn't inputting correctly for the approval. The assigned to code I have for the input value is:
first(outputs('Select')?['body'])

This is because the code for the correct admin email Select flow is:
outputs('Select')['body']

Was this reply helpful? Yes No
Verified answer

JonDoesFlow 1,304 on 13 Dec 2023 at 17:16:14

Like (1)

Report

Re: Getting a single value from a Parse Json

Try

first(outputs('Select')?['body'])?['Administrator email']

Was this reply helpful? Yes No
psil101010 11 on 13 Dec 2023 at 20:10:59

Like (1)

Report

Re: Getting a single value from a Parse Json

This worked. Thank you very much!

Was this reply helpful? Yes No