Announcements
Hi,
How can I remove the space from the extracted value of the department lookup field? I want to compare the value of the field DepartmentPosition with the value of the variable varDepartmentPosition, but I can't remove the extra space from the value of the variable (see label text at the bottom of the form). Thank you!
Hi @GabrielN ,
I have tried to re-create the issue, but in my case it's working fine:
Hi @BCBuizer,
thank you for your response. Sorry, I forgot to mention the form is generated from a SharePoint Online list. Perhaps it is the reason that my solution does not work.
Same thing:
A workaround may be to use the Replace function, but that will only work if the second character is always a space. For example:
I don't know why does not work for me. Anyway, thanks for the workaround!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 409 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 252 Most Valuable Professional
