Filter a view form based on variable

(0) Share

Report

Posted on by Frans_365CH

231

from a galary you can navigate to a record in view screen using selected gallary item.

item: galary.selected

But what if you have more than one galary?

How can i use a var to filter a record in a view form?

Filter('[Access].[tbl_relaties]';tbl_relatieId=recordId)

This does not work.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Community Power Pla... on at

Like (0)

Report
Hi @Frans_365CH

It is quite hard to understand what you mean, maybe some pictures could help.

You have 1 gallery where you select it and it navigates to a new page with a new gallery which you have to filter based on the first gallery?

If yes then your code for Gallery2.Item should be something like this:

Filter( '[Access].[tbl_relaties]'; tbl_relatieId=Gallery1.Selected.recordId )

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report

I have this form with a galary:

But i have also a task list and a opportunity list, an order list. From all those list i want to navigate to one from. So i can not use the "galary selected function".

Hope this will helps?

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
Have you tried setting a global variable and then using that variable in the Item property of your view form? You would need to updated the OnSelect in the different Galleries to look something like this:

Set(gvSelectedGalleryItem, BrowseGallery1.Selected); Navigate(ViewFormScreen, ScreenTransition.None)
The "BrowseGallery1" name would be different for each gallery but would bring you to the same ViewForm and set the ITem property to the select item in the gallery.

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report

I did, but this is not working, get a message that i compare table values with record values....

Was this reply helpful? Yes No
Sienna 1,532 on at

Like (0)

Report

Try add First(...) in your item property

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report

thanks. But this does not work. Why is a var working for a gallary in a form but not a view data form?

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

What is the error message you get when you hover over the yellow error icon?

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report

The property expected a value of the type record, but these rule pruduece incompatible of type tables.

(i have to translate from dutch) but i think this is clear for you?

Was this reply helpful? Yes No
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (10)

Report

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.

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (1)

Report

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

Was this reply helpful? Yes No