You’re offline. This is a read only version of the page.
Announcements
46
Hi guys,
Really need some help on this.
I have a request to write back to a sharepoint list from Power Bi through Power APPs form.
So far i'm stuck trying to match the data values from Power Bi to Power Apps form.
For example, when i'm clicking on the 2nd row of the dataset in Power Bi (Refer to screenshot), Power APPS is returning me the date of "4/1/2023", instead of "5/1/2023". Essentially the current result in the form should be : "Date 5/1/2023, Project : PX 123, Objective/Deliverables : Achievement of 50% by Q3, Type: Min")
Attached a screenshot of the dataset
Share
ReportLookUp('Test Heat Map Write Back New', 'Project' = First(PowerBIIntegration.Data).'Project')
BR
J
This is because your LookUp is incorrect. The function is returning the right value because ALL Projects are 'PX123', meaning the first record where Project = PX123 (which is 4/1/2023 in your shown data) is returned.
If you want the second record, you'll need to use a different field to filter on, eg ID. So something like
All responses (
Answers (
LookUp('Test Heat Map Write Back New', ID = First(PowerBIIntegration.Data).ID)
If not ID, I'm guessing that you have a Primary Key field and you can use that instead.
