Power Platform Community Forum Thread Details

Filter(AddColumns('Approval Requests', "OwnerEmail", AsType(Owner, Usuarios).'Correo electrónico principal'), 'Approval Stage Key' = LookUp(Approvals, Status = 'Status (Approvals)'.Active,'Approval Stage Key'),OwnerEmail = Email)

I have 2 records but only the first one shows me

Categories:

Building Power Apps

Hi @octaking ,

Firstly, please make sure whether your result shoube not be only one item.

Secondly, did you have delegation warning?

If your record is too large and not use delegable data source, delegable functions, the app may not perform good.

If your record is smaller than 2000, please change this non-delegable limit to 2000.

If your record is larger than 2000, please modify your formula to only use delegable functions.

Here's a doc about delegable functions for your reference:

https://docs.microsoft.com/en-us/connectors/commondataservice/

Here's a doc about what is delegation for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Best regards,

Community site session details

filter formula returns only one record

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates