Unanswered

Multi Select Choice Field not showing in dynamic content in Flow

Like (0) Share

Report

Posted on 9 Dec 2022 19:40:54 by adove

I have created a 'Test List' in SharePoint and have created a Flow to trigger when an item is created or modified. My goal is to capture the values of the multi-select choice field, but the dynamic content never shows the checkbox field 'Fruit'.

In my sample list called 'Test List' I am trying to grab the values of the column 'Fruit' and put them into an array that I can use to iterate through using an 'Apply to Each' action, but the problem I am finding is that inside Flow it never lists my column 'Fruit' so that I can use it. Not sure if I've done something wrong or that I just need to expose the data using expressions or something.

Thanks in advance for any help.

ADove

I have the same question (0)

All responses (11)

Answers (0)

grantjenkins 11,059 Moderator on 01 Feb 2023 at 05:55:16

Like (1)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

@Sharinah1 I'd suggest posting a new question including what you're trying to do (the more info you can provide, the better we can help). I'd also suggest including the link to the tutorial in your post.

Was this reply helpful? Yes No
Sharinah1 101 on 01 Feb 2023 at 05:35:15

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

Hello @abm thanks for the tutorial. I tried it but i'm stuck with this. It's different from how it looks in the tutorial. By the way after this step I have > List rows present in a table in Excel. My issue is I was able to do it for other column values except for one column with multi choice.

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on 15 Dec 2022 at 00:30:46

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

@adove I'm not sure it's just related to SharePoint 2013. We've also seen this in our SharePoint Online tenant and currently working with Microsoft on the issue. Will let you know how we go.

Just a quick question - in your Get item action have you set Limit Columns by View?

Was this reply helpful? Yes No
adove 96 on 14 Dec 2022 at 19:22:02

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

This seems to be a limitation of SharePoint 2013. I created a new test list on SharePoint 2019 and it works just fine.

Was this reply helpful? Yes No
adove 96 on 13 Dec 2022 at 14:33:53

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

@grantjenkins, that is a great suggestion.
I did just what you asked. I ran a test and the 'Fruit' column does NOT come back at all.
It is not like it comes back 'empty' with no values...it is NOT returned at all.

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on 13 Dec 2022 at 00:38:16

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

Can you add the body from your trigger into a Compose then run the flow and look at the output from the Compose to see if it includes your fruit column (might have a different name you weren't expecting).

Was this reply helpful? Yes No
adove 96 on 12 Dec 2022 at 15:19:01

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

The result I am getting in strange. I expect to see the multi-value field or at least the "value" of that field. I am not getting the field at all.

I have refreshed the flow. I have logged out of the flow and came back in to ensure that I am seeing the freshest content. The internal name of the column is indeed "fruit". I have created new choice fields that have single-values and the flow recognized them. I then created a different choice field with multi-values and the flow does NOT recognize it. I feel that there is a simple answer, but I am overlooking something...I can see from the examples from "Amit_Sharma" and "abm" that they are successful. I am obviously missing something. Ugh.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on 12 Dec 2022 at 05:08:52

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

Hi @adove,
Please confirm the dynamic value that you selected should be fruit value or not.
I have created sample for you.
Output:
List:
Please share the flow screenshot and clarify more on requirement If I misunderstood the requirement.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
abm abm 32,570 Most Valuable Professional on 11 Dec 2022 at 20:37:28

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

Hi @adove

I have a video tutorial based on this.

https://www.youtube.com/watch?v=7ayWDpMhNg0

Please have a look and comment.

Thanks

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on 10 Dec 2022 at 08:32:05

Like (0)

Report

Re: Multi Select Choice Field not showing in dynamic content in Flow

Did you create the Fruit column after you created the flow? If so, you might just need to save the flow, close it, and reopen it to get the new list schema that would include the Fruit column.

Or it might already be in the schema, but you missed it due to the internal name of the Fruit column not being what you expect. Can you check in SharePoint what the internal name of your Fruit column is? List Settings > click on the Fruit Column - should see the internal name within the URL.

Was this reply helpful? Yes No