cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Symira
Helper III
Helper III

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1652949420206.png

2. Here is my Flow.

vyujincuimsft_1-1652949480961.png

Result Screenshot:

vyujincuimsft_2-1652949552229.png

 

 

 

Best Regards,
Charlie Choi

View solution in original post

1 REPLY 1
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1652949420206.png

2. Here is my Flow.

vyujincuimsft_1-1652949480961.png

Result Screenshot:

vyujincuimsft_2-1652949552229.png

 

 

 

Best Regards,
Charlie Choi

Helpful resources

Announcements
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.

Users online (1,866)