How to write data to Dataverse table via Power Apps Flow?

(1) Share

Report

Posted on by Udo_S

Hello everyone,

I'm a bit of a newbie when it comes to Power Apps Flows and I'm currently struggling with a (hopefully) simple task.

I have a Dataflow in Power Apps with a simple table with a few thousend rows and only three columns: Contract ID, Date, Amount. "Amount" represents the revenue generated by the contract on the date. In Dataverse (source is Dynamics 365 Sales) there is a similar table, also the same three columns, whereas Contract-ID and Date are pre-filled and Amount is empty.

This is what I want to achieve:
"Amount" from the Dataflow table should be written to the corresponding field in the Dataverse table. "Corresponding field" means that the Contract ID and Date in a row in the Dataflow table match the Contract ID and Date in a row in the Dataverse table.

I hope someone can help.

Thanks!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MichaelFP 1,943 Moderator on at

Like (1)

Report
Copy link

Link copied!

This is only unique record using the two fields Contract id and Date? if it is, you can use on the Dataverse table the key feature. You can include theses two fields as key and use during the mapping to validate and update the correct data.

Field mapping considerations for standard dataflows - Power Query | Microsoft Learn

Was this reply helpful? Yes No
ankit_singhal 618 Moderator on at

Like (1)

Report
Copy link

Link copied!

You can use power automate. You can create parameters in power automate and get value from your data table and create record in dataverse.

Was this reply helpful? Yes No
Udo_S 10 on at

Like (1)

Report
Copy link

Link copied!

Hello again,

As it turns out, the real challenge is getting a connection from Power Automate to a Dataflow. As of now there is only one Dataflow connector in Power Automate which checks, if a Dataflow has been updated. Unfortunately this is totally useless for my usecase.

Does anyone have an idea for getting data from Fabric (either via Dataflow or via table from a Lakehouse) to use it in an Power Automate flow?

Anything to help is appreciated?

Was this reply helpful? Yes No