
Hi all.
I have a Power Automate process that uses an action (create or update file in SharePoint folder) as a trigger. I want the sheets of the Excel files uploaded to the folder to be sent to Dynamics 365 (preferably Customer Service Hub) and stored as new entities or added to pre-existing ones. Would a Dataverse connector be able to achieve that? In the step, I chose the connector; what option would exactly send the data to D365? Do I need an additional step as well?
Thank you.
This should really be posted in the Power Automate forum instead of the Power Apps Forum. But yes Power Automate has actions for adding new records to tables in Dataverse and actions for reading tables in Excel files. The one spot I think you may have an issue is wanting to create new entities. You can create new records in existing Tables, but not new tables. So it depends what you mean by new entities.