Hi trying to embed an Power App into Power Bi to write data back to Sharepoint.
But in the the step where I edit the app in the web.powerapps.com solution I get a delegation warning.
Its a simple lookup against a SP list. Using the same syntax as mentioned here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual
I have added a column "Id" to the power apps visual in Power Bi.
Giving me the option to use PowerBiIntegration.Data.Id in the lookup...
LookUp(Projectlist,Projectlist.ID=First(PowerBIIntegration.Data).Id)
Worth to mention that I have entered 2000 rows as the Advanced setting option for the app.
Also a Count ID for that project list gives me 862 elements.
The delegation documentation states that SP and Lookup should work for = ?
What am I doing wrong?
Solved! Go to Solution.
Hi @Rfla,
Please take a try to switch the formula as below:
LookUp(Projectlist,ID=First(PowerBIIntegration.Data).Id)
See if this would make any difference.
Regards,
Michael
Hi @Rfla,
Please take a try to switch the formula as below:
LookUp(Projectlist,ID=First(PowerBIIntegration.Data).Id)
See if this would make any difference.
Regards,
Michael
User | Count |
---|---|
256 | |
108 | |
97 | |
51 | |
39 |