web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Create a View to show ...

Power Apps

Unanswered

Create a View to show related inventory items

(0) Share

Report

Report

Posted on by AsheshR

92

Hello,

How to create a filter for a view to show inventory items pertaining to only a specific event?

There is table: Event and there is table: Event items.

i want a subgrid in Event form to show Event items only for that event.

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AsheshR ,

You can use nested gallery to complete this.

The parent gallery connects to Event table and nested gallery connects to Event items table.

Assuming that there is a column named EventID in Event table and EventID2 in Event items table, you can use below formula to show inventory items pertaining to only a specific event.😀

Items of nested gallery.

Filter(EventItemsListName,EventID2=ThisItem.EventID)

Best regards,

Rimmon
AsheshR 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, its a model driven app.

i don't think there is gallery in it? kindly please correct if i am mistaken. thanks

Join the conversation