web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate SQL Server Connector (...

Power Automate

Answered

SQL Server Connector (On-Premise) - List Rows Action - Sort by with "-" in column name

(0) Share

Report

Report

Posted on by Symira

156

Hi,

I have a flow that is supposed to list rows from an SQL Server Table (On-Premise DB connected with On-Premises Data Gateway). I would like to sort the rows using a field name that has a "-" in it. Example "AB-Number". It looks like I cannot use this fieldname to sort the rows. I tried replacing the "-" with x002d but that dosen't work either. Any idea if and how I need to use an escape character?

Thanks

-S

Categories:

Using connectors

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Symira ,

Maybe you could try the following formula:
AB_x002d_Number desc
I have made a test for your reference.
1. Here is my SQL table.
2. Here is my Flow.
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No

Join the conversation