Add filter on a canvas app

(0) Share

Report

Posted on by LauM

Hi,

I want to do something pretty basic, but I am really new in canvas app.

I have tables in CDS, I did a model driven app that works fine but I want now to build a canvas app.

I have two tables:

Bet
Games

A bet can contain many games, and there is relationship between them.

I generated a canvas app.

On the browse screen, I can click on a Bet. Then, it opens the details screen where it shows the Bet Id, and I add a gallery at the bottom where I want to display all the games related to this Bet id.

I tried so many filters, but none of them worked. So I guess I always use a bad syntax...

Can you tell me what is the good syntax for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Sami_S on at

Like (0)

Report
Copy link

Link copied!

Try this:

Filter(Games, Bet = 'YourBetGallery'.Selected.BetID)

Works with me, but I used SharePoint -list instead.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @LauM ,
I guess what you need is:
Filter(Games,Bet=ThisItem.BetID)

Hope it helps !

Was this reply helpful? Yes No
LauM 61 on at

Like (0)

Report
Copy link

Link copied!

@Samih , It doesn't work. Here is the message:

Was this reply helpful? Yes No
LauM 61 on at

Like (0)

Report
Copy link

Link copied!

Hi @gabibalaban ,

this solution doesn't work either, see the message:

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like (0)

Report
Copy link

Link copied!

Auch sorry ... where were my thoughts ? Please go to Item property of the form and use it inside formula:
Filter( Games, Bet = myItemProperty.BetID )

Was this reply helpful? Yes No
LauM 61 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban ,
I did this (see my printscreeen), but I am not sure I understood well what you told me about the Item property of the details form... Did I do the right thing?
Now, I see all games, not only games related to this bet.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like (0)

Report
Copy link

Link copied!

@LauM
What I meant to say is to copy the text from item property (as it was) and adapt my formula with the text you found there by replacing myItemProperty from my formula with that text.
The Item property of a form represent the current record from datasource to whom the form is "connected".

Was this reply helpful? Yes No
LauM 61 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban
I hope I understood well...
Here what I did, and it still doesn't work.. I should see two records for this bet
Item property of the formadd this text in the suggested formula

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, you understood correctly, it seems that I have some problems to undestand your background list.
I guess that the correct formula is:
Filter( Games, Bet = BrowseGallery1.Selected.Bet)
or
Filter( Games, Bet = BrowseGallery1.Selected.'Bet (crceb_bet)' )
after you type the point please check the autofill.

Was this reply helpful? Yes No
LauM 61 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban ,

after the point the autofill proposes Bet (crceb_bet), but it doesn't work 😞

Was this reply helpful? Yes No