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
Solved! Go to 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
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
Thank you very much! 🙂
I didn't see it and unfortunately Powerapps error handling is not always so helpful in my opinion
Kr
User | Count |
---|---|
196 | |
124 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
163 | |
138 | |
75 | |
72 |