Hi, I am getting the delegation waring for the below formula :
LookUp('[dbo].[Person]', email1=User().Email || email2=User().Email || email3=User().Email,PersonID)
I am using SQL server On-premise, This "person" table contains more than 2000 records.
Whereas the below formula is working perfectly fine:
LookUp('[dbo].[Person]',email1=ThisItem.UserName || email2=ThisItem.UserName || email3=ThisItem.UserName,PersonID)
Please suggest how to avoid it
Thanks in advance!
Go to Solution.
Thank you, it worked 🙂
View solution in original post
You can overcome this problem by storing the user email address in a variable in the OnStart property of your app, or OnVisible property of your screen.
You can then modify your LookUp function so that it refers to the variable instead.
LookUp('[dbo].[Person]', email1=UserEmail || email2=UserEmail || email3=UserEmail, PersonID)
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand