SQL Power Query Table Output

(0) Share

Report

Posted on by Anonymous5

107

Hello,

I have been working with the SQL Server connector to manipulate some table data using the Transform Data Using Power Query action. I have merged and filtered 4 tables to achieve the final single table output I need.

From here I would like to output the completed final table to an excel worksheet and email on a weekly basis. When I select the "create Excel worksheet" connector, I'm a little lost as to how to find the entire table output to insert as an email attachment. I am shown the out put of each column from my new table but the entire finished table.

Any help would be greatly appreciated.

Rgds,

Rob

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Re: SQL Power Query Table Output

Hi @Anonymous5 ,

Could you share the current Flow configuration?

It seems that the Create worksheet action does not meet your needs here. Please see the Online doc below for more details on the Excel connector:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/

In addition, the appropriate method here is that you first get the data in the SQL table and then insert it into the Excel table.

Then send the Excel file containing the Excel table as an attachment. You may need to use the Get file content using path action.

Best Regards,

Was this reply helpful? Yes No
Verified answer

Anonymous5 107 on at

Like (0)

Report

Re: SQL Power Query Table Output

Thanks Barry,

Sorry for the delayed response. I’ve continued to play around with this and have concluded that the “Create HTML Table” will best suit my needs. I can then insert it into the body of an email and send.

Was this reply helpful? Yes No