Unanswered

How can I use a Power Automate flow to start a Dataflow to import data into Dataverse?

(0) Share

Report

Posted on by h-demedici

At the moment, I receive a learning report on a weekly basis in Excel and am appending this data to a Dataverse table using Dataflows in Power Apps. I want to see if I can automate this as much as possible.

Is it possible to have a Power Automate Flow which is manually triggered, requires a file to be attached during the trigger, and the starts a Dataflow using that file, and imports to a specific table in Dataverse?

The format of the Excel stays the same, as does the Power Query steps in Dataflows. The reason I was looking to remain using a Dataflow was because there were quite a few steps involved to transform the data before it's ready to be imported. I'd also like the ability for my colleagues to be able to 'upload' the file and trigger the workflow also.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

The data flow would need to already be built to import the data into Dataverse, but there is an action that will let you refresh a Power Query Dataflow.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
h-demedici 20 on at

Like (0)

Report

Thanks @Pstork1

I have seen that before and I have used Dataflows in Power Apps/Dataverse, but I've only been able to do it by targeting an individual file. I'd like to make it more dynamic as we receive an Excel file to be uploaded to Dataverse each week.

Is it possible to do it more dynamic? Either from a Power Automate flow, or from a Dataflow?

Thanks

Was this reply helpful? Yes No