Taking a Power Query generated data table from CDS and inserting it into a Word document.

[Anonymous]

I have previously used the Excel Power Query transformation fuction to create a required table of data. This could be easily manually copied and pasted into a Word document (headers and content, as-is). However, I would like to automate this. Within Word I have previously worked Content Control fields and populated a template successfully with manually triggered data, so I am familiar with that process. However, I have not done this for tables before.

I'm now moving my data into a CDS table, and I'm looking to replicate that Power Query to create/update the same table in CDS, with a view to using Power Automate to grab that data table and insert it as a table in the Word document template.

Assuming that I have my data available in CDS, how do I reference my transformed PQ-generated table in my Power Automate flow and insert it into a specified place in the Word document?.

Any help would be greatly appreciated!. Thanks in advance 🙂

[dax]

Hi @Anonymous , 

It seemsthat you want to use Power Automate flow to achieve this goal, right? If so, I suggest you could post this in power app or power flow forum for more professional suggestions.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Thanks for the suggestion - I have logged my issue there.... but there doesn't seem to be an appropriate home for this question over there either!.

Now I have two irons in the fire, let's see which one works. If I get a solution from the other forum, I'll post it back here under this thread.