Filter gallery from choices in sharepoint list

[tupues]

Hi all,

I have a sharepoint list which has values in a column defined by choices (dropdown). I am now in the process of creating an app with a gallery. The key is that the gallery should only show certain items based on the choice made in the sharepoint list.

I tried the following filter where "flt_EATfeedback_questions" is the list and Stage is the column in question with "Session" being the items to be shown in the gallery

Filter(flt_EATfeedback_questions, Stage.Value="Session")

Sadly the gallery is not returning any results with this - and I am a bit at a loss why...

Many thanks for any help,

Regards,

Tom

[mdevaney]

@tupues 

Your FILTER statement has the proper structure so there's no problem there.

1.  Are you getting any errors in App Checker?

2.  Can you post a screenshot of the data so I can confirm you are setting the filter properly?

3.  Try to refresh the datasource.  On the left menu, click on three three dots beside your SharePoint list datasource, then choose refresh.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[tupues]

Thanks for your reply.

1. the only error I am getting is the delegation warning. This shouldn't cause an issue as the list is only very small (about 10 items)

2.

3. Tried, didn't do anything. This is how it looks (ignore the red X's they are from one of the other tabs which is not linked to the list properly yet):

My best guess is that it gathering the data from a list of choices messes it up.

Thanks very much for your help and let me know if you need any other information!

[mdevaney]

@tupues 

What is your delegation limit set to right now in Advanced Settings?  Could it be that you set this to 1 row for testing purposes and did not change it back?

[tupues]

No, its at its default value i.e. 500...

[mdevaney · Accepted solution]

@tupues 

Another thing I see is: you are using checkboxes in your SharePoint settings which allows for multiple selections?

Did you mean to do this?  If yes, you should write your FILTER statement like this.

Filter(flt_EATfeedback_questions, "Session" in Stage.Value)

If no, change Display Choices using: Drop-Down menu.  Then your original code should work OK.

Filter(flt_EATfeedback_questions, Stage.Value = "Session")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[tupues]

Brilliant! That did it - thanks so much! 🙂