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

Re: Filter a view form based on variable

This works! Not immediately thought of. This is nice, cos you always have different galarys for start. Tasklist, Orderlist. Thank you!

 

lookup.JPG

Nouman
Level: Power Up

Re: Filter a view form based on variable

Hello Jeff,
I have used this methodology on multiple occasions and its seems it doesn't work in a robust way.
Assume that you set value of a global variable on an event (e.g someone clicks a gallery item).
And the global variable is used to filter out a gallery on the next screen. In many tests i did this usually works 50% of the time and other times you just see a blank gallery on the next page.
Maybe powerapps has actually already evaluated the filter expression before the global variable is set.
Are you aware how this issue could be dealt with.

Nouman
Frans_365CH
Level: Powered On

Re: Filter a view form based on variable

Hi Nouman,

 

I used this function a lot and it's still working good.

 

But i saw an artikle that using collections is beter for a global var, maybe that will help you?

 

Frans

Highlighted
Ankur
Level: Powered On

Re: Filter a view form based on variable

 


@Jeff_Thorpe wrote:

The Item property of a form is especting a record and the Filter function returns a table. The gallery Items property expects a table and that is why the formula is working there. Try using the Lookup function which returns a record not a table.


Great, worked for me the moment i replaced filter formula with lookup. You saved my big time. 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 52 members 3,890 guests
Please welcome our newest community members: