Building a flow to store data in dataverse

(0) Share

Report

Posted on by Syed_owais

Hi I am having a problem in building an automated flow where every day an email will be sent to the particular email with particular excel file then we have to store that file in dataverse with realted fileds in excel file can u please help me with this

All responses (1)

Answers (0)

Expiscornovus 31,732 Most Valuable Professional on at

Like (0)

Report

Re: Building a flow to store data in dataverse

Hi @Syed_owais,

It might be interesting to have a look at data flows instead:

https://docs.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

With dataflows you can create a import which can be mapped to Dataverse tables.

Via Power Automate you could potentially drop that file in a SharePoint folder and trigger a refresh of your dataflow whenever that new e-mail arrives.