cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
m0stcurious
New Member

Filter Query adds space sometimes

Hi,

 

I have a flow that looks up a table row based with dynamic data from an MS form.

 

Sometimes (maybe 3 / 10 runs) it will just add a space after the dynamic input? Has anyone come across this and know what's happening here?

 

EG:

Network eq 'SA WAN'

Network eq 'SA WAN '

 

Alternatively is there a way to wrap a slice or time in an IF that checks if the last character of a string is a space?

 

Thanks!

3 REPLIES 3
abm
Super User
Super User

Hi @m0stcurious 

 

Flow won't add any spaces automatically. How does the value originally gets created. That's where the issue is?

 

You can use a trim() expression to remove the spaces.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi

Thanks for the response


The query is checking the chosen response from a Drop Down in MS Forms

I've checked all of the inputs in the Drop Down menu, and they are all Plain Text, no additional Spaces.

 

<div aria-label="SA WAN" aria-selected="false" aria-posinset="10" aria-setsize="22" class="select-option-nocheck" tabindex="-1" role="option"><div class="select-option-content"><span class="text-format-content">SA WAN</span></div></div>

 

I'll look in to adding a Trim(), do you know if you can wrap in an IF?


Thank you

Hi @m0stcurious 

 

Thanks for your quick reply.

 

Check all the values you are getting from MSForms in PowerAutomate. Its definitely wrong in somewhere there is a space when you extract that data. Check the PowerAutomate steps from Forms response data. You don't need an IF condition here. Just use the trim() expression that will remove the trailing spaces automatically.

 

Thanks 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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 (2,384)