When I use "eq" in the Filter Query, it returns one line like it should:
Number eq '29080'
But I'm having trouble figuring out what the respective syntax would be with contains or startsWith (either will do). I've tried this and it fails:
Number startswith '29080'
And if I try this it returns nothing:
startsWith(Number, '29080')
Anyone know what my syntax should be?
Solved! Go to Solution.
Hi there. So, your syntax on the last one is correct, here is a handy reference:
Every Power Automate (MS Flow) Filter Query You Ever Wanted To Know As A Functional Consultant
I'm wondering if it's returning nothing with that one because of a type conversion or something. Try making the number less specific: startsWith(Number, '2')
And if that still returns nothing, try it without the single quotes. Those usually indicate a string, so if the field is numeric, it may not recognize that.
Keep us posted.
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Hi there. So, your syntax on the last one is correct, here is a handy reference:
Every Power Automate (MS Flow) Filter Query You Ever Wanted To Know As A Functional Consultant
I'm wondering if it's returning nothing with that one because of a type conversion or something. Try making the number less specific: startsWith(Number, '2')
And if that still returns nothing, try it without the single quotes. Those usually indicate a string, so if the field is numeric, it may not recognize that.
Keep us posted.
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
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 |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
137 | |
44 | |
32 | |
32 | |
29 |