cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Search into Entity

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 
     
RequestProfiles reqprofile
req-1Buyer, Approver req-200Basic
req-2Basic req-201Admin
req-3Admin req-202Approver
req-4Approver, Basic, Admin req-203buyer
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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 

View solution in original post

1 REPLY 1
Community Support
Community Support

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 

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (19,214)