cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daviid
Frequent Visitor

Can`t use SQL Get Rows V2

Hey!
I'm having problems with SQL Get Row's V2.
When I set it up, everything works as it should. It finds the server, database and the table but no matter what filter query I set I get the same error. Even without any querys. (See pictures)

 

GetRowsv2.jpg

 

Then I get following error:

GetRowsv22.jpg

 

It works perfect with Get Rows V1 in old configs!

I realy need to get this to work... Does anyone have any ideas ?!?

Thank you
//David

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @Daviid,

 

Do you still have the same problem?

I'm afraid it was an accidental mistake, which has now been corrected.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-litu-msft
Community Support
Community Support

Hi @Daviid,

 

Do you still have the same problem?

I'm afraid it was an accidental mistake, which has now been corrected.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Now it works perfect!!
Thank you so much! 

//David

Hi agian @v-litu-msft 

I got the same problem again when put a new Get Row V2!

InvalidTemplate.Unable to process template language expressions in action 'dbo.Blikk' inputs at line '1' and column '2655': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sql_1']['connectionId']' cannot be evaluated because property 'shared_sql_1' doesn't exist, available properties are 'shared_sql'. Please see https://aka.ms/logicexpressions for usage details.'.

 

Is it the same problem?!

 

//David

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,822)