Email format multiple for a multiple-choice field

(1) Share

Report

Posted on by esjimenezp

485

Hi Community,

How can I format the column "Growth Method" and "Ranch Name" to a more readable way?

The column Growth Method is a multiple choice

I already get the value, and also, I have a variable to handle the array but the format is still not legible for the users

Thanks for all of the support 👋

Kind regards.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@esjimenezp

The Growth method seems to be a lookup field.

Try using this expression

item()['GrowthMethod/Value'] or

item()['GrowthMethod']['Value']

Was this reply helpful? Yes No
esjimenezp 485 on at

Like
a
(1)

Report
Copy link

Link copied!
Thank you @SudeepGhatakNZ

I'm using a compose with the next expression to join the values e.g. "Soil, Substrate"

join(items('Apply_to_each')?['MetodoCrecimiento'], ',')

it's possible to achieve with your previous code?
This is the flow looks like
Kind regards 👋

Was this reply helpful? Yes No
esjimenezp 485 on at

Like
a
(1)

Report
Copy link

Link copied!

@SudeepGhatakNZ I'm using both expressions that you previously share me but not works 😢
Kind regards 👋

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Are you able to share a screenshot of your list

And the desired email format

Was this reply helpful? Yes No
esjimenezp 485 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @SudeepGhatakNZ
Sure, this is the current SPO list
the column called MetodoCrecimiento is a multiple-choice, and the format of the email I would like is the next one
I already create the steps in Power Automate but my thing is how to handle the multiple-choice column.
Into the Power Automate the flow looks like these:
I'm using the Filter Array to filtered specific items
Then, I use the Parse JSON to collect the schema
The compose I'm using is for taking the multiple-choice column and join the values like "Soil, Substrate"
Kind regards 👋

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

@esjimenezp

Please find a sample attached.

Dealingwithmultic...

Was this reply helpful? Yes No
esjimenezp 485 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @SudeepGhatakNZ
This flow it helped me to understand how to configure my workflow, I really appreciate your help on this, it works perfectly.

Kind regards 👋

Was this reply helpful? Yes No