Gilbert Quevauvilliers finds a way:
I recently had a requirement from a customer where they wanted a list of all Customers and the Primary Contact to be emailed to them every day.
The reason for this to be emailed daily is to ensure that when calling the customer, they know whom to speak to.
This got me thinking and I could use Power Automate to achieve this task which I detail in this blog post below.
I appreciate the ingenuity involved in getting this to work, though this also presents a good case for having this data in a warehouse, where data export to CSV would be easier.