Filtering gallery based on another gallery raise runtime error

(0) Share

Report

Posted on by Axal

945

Hello guys,

I'm trying to filter my gallery based on another gallery selected, like this :

Filter('General journal line attachments(mserp)', 'Journal batch number' = GalleryDetail.Selected.'Journal ID' && 'Line number' = GalleryDetail.Selected.'Line Number')

Just an information, the table : General journal line attachments (mserp) is my table, which is a Virtual entity from Dynamics 365 Finance. Strange is, it is return Runtime error.

May I know what's wrong with this formula ? Isn't if there is no data, it will only display empty gallery ?

Thanks,

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Axal

We can able to filter galleries based o another gallery and your query looks good.

I'm wondering system is not allowing it since the table is a virtual table. If this is true then we may need to filter the collection instead of the Data Source.
Set Onvisible screen
Set(ColJournalLineAttachments, 'General journal line attachments(mserp)')

On the Gallery 2 use collection
Filter(ColJournalLineAttachments, 'Journal batch number' = GalleryDetail.Selected.'Journal ID' && 'Line number' = GalleryDetail.Selected.'Line Number')
Axal 945 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy ,

Thanks, I think it's works. I'm curios though, is there any reason why it is behave like that ?