Dataflows are an excellent way to get and transform data into Dataverse. I would like dataflows to get and transform data from Dataverse (and/or other sources) and export it to Excel/CSV. The resulting Excel/CSV document could then be dropped in Sharepoint, Azure Storage or sent by-email. This option could be selected at the column mapping stage, after the dataflow has been created. This can already be done using PowerAutomate in a subsequent step, but it is fair to say the process is not intuitive and relatively complex (reserved for intermediate and expert users). The ability to export data from dataflows, directly in the dataflow interface, would further democratize this awesome functionality. Most of the time, business users are more focused on getting data out of a database then getting the data into a database. For security reasons, it would be important that the ability to export data directly through dataflows be enable or disabled through the Admin portal, ideally for specific users (if not, just an on/off switch applying to the entire environment).
... View more