cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Axal
Post Prodigy
Post Prodigy

Filtering gallery based on another gallery raise runtime error

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. 

Axal_0-1631716296550.png

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

 

Thanks,

2 REPLIES 2
StalinPonnusamy
Community Champion
Community Champion

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')

 

 

 

 

Hi @StalinPonnusamy ,

 

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,445)