We are trying to update data to PowerBI, the requirement is the user needs to update their comment in User comment column. Using excel file as a source, when trying to update data into an existing Excel which is placed in the teams channel.
We followed the video below
https://www.youtube.com/watch?v=uPHwjPRnRwE
On executing the below query to connect Excel and powerapp:
LookUp(ABCD,'Number' = First(PowerBIIntegration.Data).'Number')
ABCD is the name of the table in Excel, Number is the column.
ABCD has 2 columns Number and User Comments
We are getting an Error: when trying to retrieve data from the Network :Expression: "Number eq null not supported "
Please suggest how to handle this null?

Report
All responses (
Answers (