Answered

Switch function

(0) Share

Report

Posted on by iknownothing

I'm new to the powerapp space so apologies if this is a daft question.

within my powerapp I’ve built 3 tabs where tab 1 is the default tab. Tab 1 will return everything in my data source and when tab 2 is selected by the user it filters and returns everything where the answer to the question is yes. I’m using the below function

Switch(

varTabSelected,

'Signal Prep Sheet',

Filter(

'Signal Prep Sheet',

'Is another prep shift required?'.Value = "Yes"

)

I would like to now add tab 3 where if selected it would filter my data source (signal prep sheet) and find the question (is another prep shift required). Value = ‘no fully prepped’ and return the results in my gallery.
Any help would be appreciated.

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @iknownothing

I assume 'Is another prep shift required?' is a choice column.

Set the Items property of the gallery to

Switch( varTabSelected, 1, 'Signal Prep Sheet', 2, Filter( 'Signal Prep Sheet', 'Is another prep shift required?'.Value = "Yes" ), 3, Filter( 'Signal Prep Sheet', 'Is another prep shift required?'.Value = "no fully prepped" ) )

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @iknownothing

On select of the tab button/icon Set(varTabSelected,1) for First tab and Set(varTabSelected,2) for second tab vice versa

Was this reply helpful? Yes No
iknownothing 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you I spent ages trying to get this to work

Was this reply helpful? Yes No