Unanswered

Patching PowerBI record to Dataverse Table using embedded Power Apps

(0) Share

Report

Posted on by kymac17

Hello!

Looking for some assistance with a use case involving an Embedded Powerapp within a PowerBI Dashboard (Dataverse backend)

Trying to have end users select a record on the table below in PowerBI, and when they click one of the buttons below it adds a row to the dataverse table.

I've been trying to use different variations of the script below but haven't made any headway. Any insight / assistance would be appreciated.

Patch(

DataverseTable,

LookUp(DataverseTable, PrimaryKeyField = Selected.PrimaryKeyField)

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

vaubeee 533 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @kymac17 ! Try this..
Patch to update a record:
Patch( DataverseTable, LookUp(DataverseTable, PrimaryKeyField = ThisItem.PrimaryKeyField), {'ParentID': TextLabel.Text} )
Make sure that TextLabel is the correct name of your text label and that TextLabel.Text returns the value you expect.
For New Records:
Patch( MyDataverseTable, Defaults(MyDataverseTable), {'ParentID': TextLabel.Text} )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

Was this reply helpful? Yes No
kymac17 2 on at

Like (0)

Report
Copy link

Link copied!

Hello @VauBee - Thank you for the reply, I found examples similar to those on the forums while doing some research. There isn't a Text Label involved in the process, as the patch is initiated by clicking on a record on the PowerBi table. If I am missing anything let me know

Was this reply helpful? Yes No
lbendlin 8,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Trying to have end users select a record on the table below in PowerBI, and when they click one of the buttons below it adds a row to the dataverse table.

The PowerApps visual in Power BI will always transfer its entire filter context. So having the end user "select" a "record" on the "table" doesn't mean much. You need to force them to pick EXACTLY one entry, and make sure your PowerApps visual has EXACTLY the same filter context as that visual they use for the modification/selection.

Was this reply helpful? Yes No