Formula with delegation warning doesn't work with only 100 records

[ThomasVDS]

Hi,

I am building a powerapp using Azure SQL as data source.

Idea is to use the same app for desktop and mobile device. Therefor I am using the formula below because some screens are shared but the original gallery is different (different screens).

The item from my gallery is as follows (I do get a delegation warning).  

If(Mobile="Yes",LookUp('[dbo].[Escenters]',Email=galEscenters_Mobile_ActiveDir.Selected.Mail,LookUp('[dbo].[Escenters]',Email=galEscenters_ActiveDir.Selected.Mail))

Unfortunately, the item is not displayed, while I have less than 100 records.

When I only use the lookup part, it works fine.

Can anyone help me? I could create a new screen, so I have a seperate one for desktop and mobile, but this was not my intention.

Thanks!

Kr

[RezaDorrani · Accepted solution]

Hi @ThomasVDS 

Somehting seems off with your query 

try 

If(Mobile="Yes",LookUp('[dbo].[Escenters]',Email=galEscenters_Mobile_ActiveDir.Selected.Mail),LookUp('[dbo].[Escenters]',Email=galEscenters_ActiveDir.Selected.Mail))

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ThomasVDS]

Thank you very much! 🙂

I didn't see it and unfortunately Powerapps error handling is not always so helpful in my opinion

Kr