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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |