Power BI integrated with Power App - Lookup function error when creating a form in Power App

[Mark-JZ-Yeap]

I am integrating Power BI with Power App.

I have a source excel table with 2 columns: ClientID and Department.

I am connecting data with excel (online) for both of them.

When I tried to use the lookup function under "Item" property when creating a new form in Power App, there was an error.

Lookup(Table1, ClientID=First(PowerBIIntegration.Data).ClientID)

Please advice how to solve this problem.

[Anonymous · Accepted solution]

Hi @Mark-JZ-Yeap ,

Here I create a sample, I interate Power BI with Power App and then connect to an excel in sharepoint.

This code works on my side. My result is as below.

Please check whether you have added Field in your Gallery or Form.

If this reply still couldn't help you solve your issue please share your error with us.

This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

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