web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Can I use context vari...

Power Apps

Unanswered

Can I use context variable to set a column to display in gallery?

(0) Share

Report

Report

Posted on by GraemeNZ

235

Hi

I have a SP list with two sets of very similar data - HalalCertBody, HalalEnd, HalalStatus / KosherCertBody, KosherEnd, KosherStatus.

I have a gallery which currently displays labels for Certifying Body, End Date, Status

I have created 2 buttons: Halal and Kosher

I want to use context variables so that if the Halal button is pressed the gallery displays HalalCertBody, HalalEnd, HalalStatus, or if the Kosher button is pressed the gallery displays KosherCertBody, KosherEnd, KosherStatus.

How do I update context to the name of the column, and then how do I get the label in the gallery to display based on the context variable? This is what I've tried for the Halal button and the Certifying Body column...

Looking forward to your replies,

GraemeNZ

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,538 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @GraemeNZ ,

Try this- note I have assumed your field name here (I assume the field exists)

Filter( SPList, Switch( CertBody, "HalelCertBody", 'Certifying Body' = "HalelEnd || 'Certifying Body' = HalelStatus", "KosherCertBody", 'Certifying Body' = "KosherEnd || 'Certifying Body' = KosherStatus" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
GraemeNZ 235 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - I wasn't sure what you meant above, but thanks for providing an answer.
I decided to go for the simpler approach and I duplicated the screen. One for Halal, one for Kosher, and added a button for each to navigate to the other one. Since I duplicated the screen after it was set up, from the user perspective it just looks like the content changes (which is what I was after)

Join the conversation