Filter Query adds space sometimes

[m0stcurious]

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!

[abm]

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

[m0stcurious]

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

[abm]

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