web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to capture two col...

Power Apps

Answered

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

Report

Posted on by Basajasa

1

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation