Retrieve certain values from a Choice type column of a Sharepoint list in a variable

(0) Share

Report

Posted on by Hii_iii

691

Hello,
I have a Sharepoint list that looks like this:

And, in a WorkFlow, I would like to create a variable that retrieves only the "Télétravail" values from the "Lundi" column.

But I don't know at all how to get these values in my variable of my WorkFlow..

Can you help me please ? 😞
Thank you in advance !

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Hii_iii 691 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much !

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,417 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @s44,

Normally you could use a Select action to pick the specific columns you want to use. The output of that Select can be turned into an html table.

Just to double check. Do you have a reason why you are storing the filtered items in a separate variable? If so, can you share the rest of your flow setup?

Below is an example of that select, create html table, send e-mail approach:

However, if for some reason it is still required to use the Array variable you could use the following steps.

In the gif below you can see I am retrieving the title & lundi value. Both field mappings use the item()['ColumnName'] syntax for the value.

So, when you change the From to our Array variable afterwards it is still valid. Bit of workaround, but it should work 😁

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus
Thanks for your help !

Was this reply helpful? Yes No
Expiscornovus 33,417 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @s44,

You could use a Get Items and use the Filter query field to specifically filter on a Lundi value. I would also change the variable type from Object to Array btw.

Below is an example:

Lundi eq 'Télétravail'

Was this reply helpful? Yes No