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?
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?
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 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?
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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!