Answered

Data Table filtering a Gallery

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have this Data Table I created to generate row numbers in a gallery. The Data Table is called DataTable1 for now. I have the following in Items:

ForAll(Sequence(CountRows(ccAuditTest)), Patch(Last(FirstN(ccAuditTest, Value)), {Row: Value}))

I need to filter this Data table to only filter using another Gallery selected ID. Filter(ccAuditTest, ID = MainGallery.Selected.ID)

How do I combine these two so I can get filter I need plus the Row count? I hope this makes sense. Thank you

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Filter(ccAuditTest, ID = MainGallery.Selected.ID)
Does this always return 1 row though? Or are there cases where it might return more than one row?
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

If you really want the count, you might be able to do this:

ForAll(Sequence(CountRows(ccAuditTestVar)), Patch(Last(FirstN(ccAuditTestVar, Value)), {Row: Value}))

And from wherever you want the Filter to be triggered:

Set(ccAuditTestVar,Filter(ccAuditTest, ID = MainGallery.Selected.ID))

I think the above Filter always returns just 1 record, so if you want, you can test with another Filter that returns more than 1 record,to see if it really works.

See if it helps @Anonymous
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@poweractivate
Thanks for responding.

On the DataTable1 - Items: Filter(ccAuditTest, ID=MainGallery.Selected.ID)

Screen OnVisible:
ForAll(Sequence(CountRows(ccAuditTest)), Patch(Last(FirstN(ccAuditTest, Value)),{RowNumber: Value}));

Now, the Row count on the DataTable1 is showing no numbers, just blank. Its filtering like it should now, but no Row number. Did I miss something?
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Try this

Screen OnVisible:
Set(ccAuditTestVar,Filter(ccAuditTest, ID=MainGallery.Selected.ID)); ForAll(Sequence(CountRows(ccAuditTestVar)), Patch(Last(FirstN(ccAuditTestVar, Value)),{RowNumber: Value}));

On the DataTable1 - Items:
ccAuditTestVar
See if it helps @Anonymous
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@poweractivate
Screen OnVisible:
Set(ccAuditTestVar,Filter(ccAuditTest, ID=MainGallery.Selected.ID)); ForAll(Sequence(CountRows(ccAuditTestVar)), Patch(Last(FirstN(ccAuditTestVar, Value)),{RowNumber: Value}));

On the DataTable1 - Items:
ccAuditTestVar

I don't have anything showing in the DataTable now. Not sure how to do this now.
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Try ClearCollect instead of Set, see if it works then.

Screen OnVisible:
ClearCollect(ccAuditTestCollection,Filter(ccAuditTest, ID=MainGallery.Selected.ID)); ForAll(Sequence(CountRows(ccAuditTestCollection)), Patch(Last(FirstN(ccAuditTestCollection, Value)),{RowNumber: Value}));

On the DataTable1 - Items:
ccAuditTestCollection

Also, if trying to see results in the editor right away, make sure Screen1 OnVisible is being fired after making changes, so if needed, make a blank screen, and toggle between the blank screen and Screen1 in the editor, to trigger OnVisible of Screen1 and the changes to take effect.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@poweractivate
I'm sorry, that didn't work. I'm not sure what to do now.
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Try like this
//OnVisible Screen1 ClearCollect(varCollection,ForAll(Sequence(CountRows(ccAuditTest)), Patch(Last(FirstN(ccAuditTest, Value)), {Row: Value}))) //I need to filter this Data table to only filter using another Gallery selected ID. //Use the below from wherever you want to have the Filtered Record with the row number Filter(varCollection, ID = MainGallery.Selected.ID)
See if it helps
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @poweractivate - Thank you!
Thank you for sticking with me. Its working now. Sorry for not letting you know earlier, had to work on other stuff.
Thank you again