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

[Symira]

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

[v-yujincui-msft · Accepted solution]

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