Unanswered

Filter function

(0) Share

Report

Posted on by bolandre92

Hi,

I am struggling with a Filter function. I have a Gallery (Gallery4) which stores rows from a table called ARTICULO_OC. I also have a form (ENCABEZADO_1) which stores rows from a table called OC. There is a common column between both tables and I want my gallery to show the items associated to the row selected in the Form. I have placed the function in the gallery but it ends up with the red underlying and without success.

Filter(ARTICULO_OC, SCID = ENCABEZADO_1.Selected.ID)

Thank you

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

On the Gallery put the table
ARTICULO_OC

Then on the items of the form,
Filte(OC, SCID = Galler4.Selected.SCID)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
bolandre92 73 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24 , thank you very much for your help.

Could you please take a look at your assessment, I think that what i am doing is the other way around. I want to show items in the Gallery according to the single row showed in the form. I compare your function with mine, considering the opposite and I do not see any error. Could you please advise.

Thank you.
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If the ID field is on the form being display then ENCABEZADO_1.Selected.ID should be replaced with the name of the control that value is being displayed in. For example if the ID value is in the DataCardValue1 control on the form then it would look like this: Filter(ARTICULO_OC, SCID =DataCardValue1.Text )
bolandre92 73 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jeff_Thorpe, Thank you for your help.

I have updated the function according to your instructions. This is how it looks like:

Filter(ARTICULO_OC, SCID = ID_Datacard1.Text)

The good news are the I have reduced the errors, however, two errors remain:
1. Name is not valid, this identifier is not recognized.
2. Invalid argument type.

If this helps, the highlighted sections of the function are the sign = and the word Text.

Thank you.
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is it possible that ID_Datacard1 is the name of the data card and not the name of the control inside the data card that has the field value? For example most system generated forms usually have the values in a control named DatacardValue##