Formula to display the First record from data source

(1) Share

Report

Posted on by KONeill102399

Let me start with I am new to power apps. I watched a video on how to integrate power apps within a power bi report so that users can write back to the data set. I have a Power BI report, "Convert Asset to NFCU" that users can select a row in the report then update a power app form that writes to a Sharepoint list. I am trying to follow along with the video but the formula to pull in the first record in my power bi data set is a string not a number. I am not sure how to adjust the formula so it will return the first record in my power bi data source.

My Power BI report is called, "NFCU Converted Assets".

The field I am trying to pull back is the "Name" or "Asset Number" ( I just relabeled it in the power bi report)

In the Power App form I entered the formula below but I am getting an error.

LookUp('NFCU Converted Assets',Title=First(Text(PowerBIIntegration.Data).AssetNumber)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

level36 77 on at

Like (1)

Report

Hi,

Your on the right track, try this

Title = Text(First(PowerBIIntegration.Data).AssetNumber)

Please reply if this does not work or you have any other questions!

Was this reply helpful? Yes No
KONeill102399 68 on at

Like (0)

Report

I tried that but it did not work. I guess I am not understanding the formula. Should the "Title" bet the column name from my SharePoint List? At the end, "AssetNumber". Should that be the field name from by Power BI data source? It is actually named, "Name" not "Asset Number". That is just a lable.

Was this reply helpful? Yes No
Suggested answer

venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (0)

Report

@KONeill102399 The Title is the name of the column in your datasource. Could you share your data schema so we can troubleshoot the issue?

Otherwise, I suspect the correct parameter is Text(First(PowerBIIntegration.Data).'Asset Number'). This should be exactly as it is coming from PowerBI

Was this reply helpful? Yes No
KONeill102399 68 on at

Like (0)

Report

The name of the column from the Power BI report is "Name". I just relabeled it to be "Asset Number".

I did update the formula, but I am getting a new error message.

Was this reply helpful? Yes No