How to capture two column value on landing screen and use it in another screen to filter what data to show user

(0) Share

Report

Posted on by Basajasa

I have a requirement where user come to landing screen and choose country and Region and then go to user screen where she/he will be able to edit, view or add items based on what she/he choose on the landing screen. Both Country and Region are SharePoint choose columns. I try to use clear collect to capture the country and region value from the landing screen and use it to filter the gallery in the user screen. It is not working for me and I am new and I will really appreciate the help.

I have a label, button and dropdown in the landing screen.

on select of the enter button I have this :

ClearCollect(colCountry,

Filter(tax,

County.Value =DDCountry,selected.Result));

ClearCollect(colRegion,

Filter(tax,

Region.Value =DDRegion.selected.Result));

Navigate(UserScreen)

Thank you

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @Basajasa ,

I did a test for you.

My sharepoint list:

Choices(LIST196.Country)

Choices(LIST196.Region)

Set(Var1,ComboBox1.Selected.Value);Set(Var2,ComboBox2.Selected.Value);Navigate(Screen2)

Filter(LIST196,Country.Value=Var1,Region.Value=Var2)

Best Regards,

Wearsky

Was this reply helpful? Yes No