Unanswered

Create two tables in two Excel sheets

(0) Share

Report

Posted on by Mariel_MD

Greetings P. Automate Community,

I want to know if there is a possibility to create two tables in two excel sheets(two tabs). I have created before a flow where I connect to SQL server, gets a template file from my SharePoint folder ,then creates a table in excel, and finally send the excel table to people's email(see example below). This flow works perfectly. However, I'm not sure if you can create a flow the same type where I can create two tables in two sheets pulling data from SQL server like I have in this example below. Any help is appreciated! Thank you

Categories:

Building flows

Screenshot tables...

Screenshot 2023-0...

I have the same question (0)

All responses (2)

Answers (0)

v-bofeng-msft on at

Like (0)

Report

Hi @Mariel_MD ,

Please try:

Best Regards,

Bof

Was this reply helpful? Yes No
Mariel_MD 2 on at

Like (0)

Report

It makes sense to do it that way. But, how should I connect each table from the result of the query? I have to create two execute SQL v2, so it can connect to each table in excel?

The second step of my flow, it connects to SQL server, then I create the tables. Would you please elaborate this part?

Was this reply helpful? Yes No