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
Solved! Go to 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
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