Unanswered

Extract value from string from Choice field

(1) Share

Report

Posted on by MomirG

Hi everyone, I have a problem. When Flow is triggered it sends data to e-mail, but with all data from 'employee' and 'mistake' column of Microsoft List table. I need only "value" part of data to be displayed in outlook e-mail. I use :

1.Initialise variable(String)

2.Set variable(employee and mistake value)

3. Add variables to "Name des Sachbearbeiters" and "Beschreibung" fields

As you can see, "Zusätzliche Information " field was displayed normally(it's text based column), other 2 that I need are Choice based columns.

So, how can I extract this "Value"? Thank you!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MomirG ,

To use choice values, you need to use parse json action to get access to the values as dynamic content. Here's an example of parse json.

Essentially you will take the output from the choice column output in get items (use the json output) and then click on use sample payload to generate schema link. Paste in your json and create your schema. Then, downstream, you can use the values you want.

Was this reply helpful? Yes No
MomirG 33 on at

Like (0)

Report

Unfortunately the problem is not solved. It still sends all the data:

also I have noticed that JSON is somehow diferrent than usual (output from "When item has been created" in Sharepoint):
I need extract this:

and when I want to add dynmaic property, I don't see the "value" from "Fehler Beschreibung":
It could be because it's an array for multiple choice column-> I don#t know how to extract all the values ..

Was this reply helpful? Yes No
MomirG 33 on at

Like (1)

Report

I have managed to extracted "Value", but I still can't display all of the values.. I can select only the last one, how can I select all of them and collect data in one variable

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MomirG ,

I will have to circle back and look for a multiple-choice question sample. Tom

Was this reply helpful? Yes No