compare choice data using switch or if statement

(0) Share

Report

Posted on by HaningYa

Is there any way to compare the choice type of dataverse?

for example

If(temptable.employeeType=employeeType.Company, Navigate(HomeScreen_Field);

Switch(temptable.email,
employeeType.Company, Navigate(HomeScreen_Field),
employeeType.Field, Navigate(HomeScreen_Desk),
Notify("default")
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @HaningYa :

I suggest that you can first use the Text function to convert the value of the Choice field to a text type and then compare. I've made a test for your reference:

1\My data source

2\The formula

If(Text(First(BOFChoices).TheChoiceColumn)="Choice2",Navigate(Screen2))

Best Regards,

Bof

Was this reply helpful? Yes No
HaningYa 5 on at

Like (0)

Report
Copy link

Link copied!

thank you very much!
I don't exactly know about First function in powerapps but problem solved.

Was this reply helpful? Yes No
Schwartz_Cory 184 on at

Like (0)

Report
Copy link

Link copied!
For those that are working in SharePoint Lists:
Example: I am trying to filter visibility of column2,3,4 based on the selection of column1.
In column1, don't need to do anything. just know the options are col2,col3,col4.
In column2 in the visible field, you can use this formula:

!IsBlank(Filter(column1.SelectedItems, Value = "col2"))

What this code is doing is:
(Filter(column1.SelectedItems, Value = "col2) = create a table where the selected items are col2
!IsBlank = is that table NOT blank (does the table have anything in it?) If so, then show col2. Else hide col2.

You would need to do this for the col3 and col4 as well.
You can also do this in the Required field of the datacard, like i did as well.

Like if this helped you, and have a great day!

Was this reply helpful? Yes No
Schwartz_Cory 184 on at

Like (0)

Report
Copy link

Link copied!
I just noticed an issue with this code. When I load the app, the column1.selecteditems shows that there is data in there, even though it is empty. To fix this, change the code for the column2 visible to the following
CountRows(Filter(col1.SelectedItems, Value = "col2"))>0
Just another way to check for an empty table. 🙃

Was this reply helpful? Yes No