web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery from Sh...

Power Apps

Unanswered

Filter Gallery from Sharepoint List with Column name as Label.Text

(0) Share

Report

Report

Posted on by NeonThunder

76

I have a list with Columns Mon, Tues etc as a Yes/no Column.

The gallery is nested inside one with Mon, Tues, Wed, Thurs, Fri. I want to display a checkbox next to those days that return true.

When I enter Mon in manually it will display. However, I want to filter using the label 'LabelWeekdayCheck.Text'. How do I do this?

Filter('Check List', LabelWeekdayCheck.Text = true)

I have tried

Filter('Check List', text(LabelWeekdayCheck.Text) = true)

But as its text it fails. is there any function for making it see as a column name?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

NeonThunder 76 on at

Like (0)

Report

Seems like its not possible to have dynamic column names in Power apps?

Solved: Re: Power Apps nested Gallery, Issue selecting dat... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @NeonThunder ,

Do you want to dynamically reference the column name in Power Apps? I am afraid that there is no directly way to achieve this in Power Apps currently.
There is a post in the ideas forum about this that you can vote on.
Patch - Referance a column name via a variable - Power Platform Community (microsoft.com)

Based on your scenario, here is an alternative for your reference:
1. Here is my SharePoint list.
2. Select the Gallery and apply the following formula on its items property as:
Switch(Lower(LabelWeekdayCheck.Text), Lower("Mon"),Filter(WeekTest,Mon = true), Lower("Tues"),Filter(WeekTest,Tues = true), Lower("Wed"),Filter(WeekTest,Wed = true), Lower("Thurs"),Filter(WeekTest,Thurs = true), Lower("Fri"),Filter(WeekTest,Fri = true), WeekTest )
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation