Building a flow to store data in dataverse

[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

[Expiscornovus]

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-dyna...

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.