Lookup not working when trying to connect to Power BI Integration

(0) Share

Report

Posted on by RV-29011841-0

Hi,

Very, very new at all this. Any assistance would be greatly appreciated!

I have a SharePoint list that I'm trying to connect to with Power Apps. Here's my list. I currently have only 2 records in it.

The Title column is the Order Line Number shown on the app below. I want the first Order Line Number to show when the app is opened. I followed a video showing how to do this, but I cannot get it to work. Do I have the Lookup() syntax wrong? I've tried everything. I cannot get it to pull up my SharePoint list fields.

Here's my Power App:

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @RV-29011841-0

Looking at the documentation Power Apps visual for Power BI.

You code should look like, please adjust where needed:

LookUp( 'NIC Customer Booking Notes', Title=First(PowerBIIntegration.Data).'Order Line Number' )

Hope this helps.

Was this reply helpful? Yes No
RV-29011841-0 12 on at

Like (0)

Report
Copy link

Link copied!

SpongeYe,

I fixed the formula, and that got rid of the error message, but now it's telling me that I'm not connected to any data. I have the PowerBIIntegration connector added, but it's still not working:

Here's is how I currently have everything set up in Power BI. I'm trying to create an app that will allow users to add notes to a SharePoint list that is joined with my Bookings table. I want the notes to be shown in the table in Power BI. Please review and let me know if I have this set up correctly:

I want all of the order numbers to be shown in the Power App so users can choose from any order, add a note for that order and have it show up in Power BI after refresh. I would expect a new record to be created in the SharePoint list showing the Order, Customer Name, Booking Note, and date added. I know the data connection between Power BI and SharePoint works because I can see the 2 notes in Power BI that I manually added in the SharePoint list:

Why is this so hard?

I've watched countless videos on different ways to do this and nothing I have ever tried worked.

Thank you.

Rose

Was this reply helpful? Yes No