Search into Entity

[ivpd]

Hi to All.!!

I have one entity called Approval where I have some request and each request can have one or more profiles selected. 

On the other hand i have Monitoring Entity which have a lot of request with one particular profile.

I have created an gallery when i am listing all records in Approval Entity and i created one column called " Total req". This colum will show the sum of all records on Monitoring entity that contains the same request.

I dont know how to do that.

I tried to use this : Filter(Monitorings,ThisItem.Profiles in Profile )

but its not working.!!

Approval Entity		Monitoring Entity
Request	Profiles		req	profile
req-1	Buyer, Approver		req-200	Basic
req-2	Basic		req-201	Admin
req-3	Admin		req-202	Approver
req-4	Approver, Basic, Admin		req-203	buyer

[v-siky-msft · Accepted solution]

Hi @ivpd ,

I think you can filter the Monitorings entity by the req field based on the Request field value in Approval Gallery. Please try this:

CountRows(Filter(Monitorings, req=ThisItem.Request))

Hope this helps.

Sik