cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vaishalivyas1
Level: Powered On

Filter Data based on selected value in Option set

Hi,

 

I have option set field on one screen based on the value selected in option set I want to filter data in gallery in other screen.

 

Screenshot of Logic:

Screenshot_13.png

Screenshot of Error:

Screenshot_1.png 

 

Thanks in Advance

3 REPLIES 3
Community Support Team
Community Support Team

Re: Filter Data based on selected value in Option set

Hi @vaishalivyas1,

 

Could you please share more details about which control you are working with?

I suspect here you are working with the Gallery2 control, if this is the case, then the formula should be changed in the following way:

if(DataCardValue5.Selected.OptionValue = 100000000, 
   SortByColumn(filter('Project Task Billing Codes', 
statecode=0 && _cf_projecttaskid_value= Gallery2_1.Selected.cf_projecttaskid),
"cf_name"), SortByColumns(Filter('Project Task Billing Codes',
_cf_projecttaskid_value= Gallery2_1.Selected.cf_projecttaskid),
"cf_name") )

The Error should be caused by refering the own value of the gallery control, and this is not supported.

A control can't have its own items property refering to its own property value.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
vaishalivyas1
Level: Powered On

Re: Filter Data based on selected value in Option set

Hi @v-micsh-msft

 

In Gallery2 I have Project Task and in Gallery2_1 I have Project case. based on value selected in option set on EditScreen1 I want filtered results on Gallery 3. 

 

driverdo19
Level: Powered On

Re: Filter Data based on selected value in Option set

I have had similar problems when passing a variable from screen 1 to screen 3 (by using a intermediate screen 2).

I learned to never selfassign any variables: for example don't use -> varExtern : varExtern

 

Try to use it as follows:

Screen1 : Navigate(Screen2;Fade;{varExtern : 'my assigned variable'})

Screen2 : Navigate(Screen3;Fade;{varExternal : varExtern})

Screen3 : here you can use varExternal

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 407 members 5,388 guests
Please welcome our newest community members: