Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Change Table1 name from action Execute a SQL query

(0) ShareShare
ReportReport
Posted on by 1,328

Hello everyone,

Does anyone know how can I change the name of Table1 that the action Execute a SQL query returns?
For example, if I have 2 select statements in the action it will return Table1 and Table2. Instead of Table1 and Table2, I would like to define the names of the tables. Like Table1 --> Clients and Table2-->Orders. 
I would like to do that because I use these name in actions below and if I add an extra select statement in the beginning of the Execute a SQL query the new select statement will be Table1, Clients will be Table2 and Orders will be Table3. The script in Execute a SQL query it is more complicated than asking for data from 3 tables.
So to sum up the question is: Does anyone know how can I change the name of Table1 that the action Execute a SQL query returns?

Thank you

  • Mike8 Profile Picture
    Mike8 1,328 on at
    Re: Change Table1 name from action Execute a SQL query

    Up to recent.
    Is there a way to set the Table1 and Table2 to other names of our choice?

    Thank you

  • Mike8 Profile Picture
    Mike8 1,328 on at
    Re: Change Table1 name from action Execute a SQL query

    Hello,

    I am referring to the query results in outputs of the Execute a SQL query action.
    Something like this:

    {
    "OutputParameters": {},
    "ResultSets": {
    "Table1": [
    {
    "Client": "Client1"
    }
    ],
    "Table2": [
    {
    "OrderNumber": "Order1"
    },
    {
    "OrderNumber": "Order2"
    }
    ]
    }
    }

    Does anyone knows how to set the names of Table1 and Table 2 to a different name?
    SQLoutputs.PNG
     
  • RookieI Profile Picture
    RookieI 160 on at
    Re: Change Table1 name from action Execute a SQL query

    Hi @Mike8 ,

     

    In theory, this is not possible because the Table name are stored in the current connection.

     

    In the process of configuration, you need to rely on these Table names to configure related actions.

     

    I think the feasible way is to change these table names directly in the Sql server, and then reconfigure the relevant actions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard