Formula to display the First record from data source

Like (1) Share

Report

Posted on 30 Jul 2024 16:58:11 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:

Using Apps Using Formulas

All responses (4)

Answers (0)

KONeill102399 68 on 31 Jul 2024 at 18:03:41

Like (0)

Report

Formula to display the First record from data source

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.
Suggested answer

venturemavenwil 600 Super User 2025 Season 1 on 30 Jul 2024 at 21:06:45

Like (0)

Report

Formula to display the First record from data source

@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
KONeill102399 68 on 30 Jul 2024 at 19:57:39

Like (0)

Report

Formula to display the First record from data source

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.
Suggested answer

level36 71 on 30 Jul 2024 at 17:11:02

Like (1)

Report

Formula to display the First record from data source

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!