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!
