cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GabrielN
Helper II
Helper II

Remove a space from variable value which is created from lookup field value

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!

 

GabrielN_2-1662721471164.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Super User
Super User

Hi @GabrielN ,

 

Same thing:

 

BCBuizer_0-1662733482296.png

 

A workaround may be to use the Replace function, but that will only work if the second character is always a space. For example:

 

BCBuizer_1-1662733661682.png

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

4 REPLIES 4
BCBuizer
Super User
Super User

Hi @GabrielN ,

 

I have tried to re-create the issue, but in my case it's working fine:

BCBuizer_0-1662730488029.png

 

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

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.

BCBuizer
Super User
Super User

Hi @GabrielN ,

 

Same thing:

 

BCBuizer_0-1662733482296.png

 

A workaround may be to use the Replace function, but that will only work if the second character is always a space. For example:

 

BCBuizer_1-1662733661682.png

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Hi @BCBuizer,

I don't know why does not work for me. Anyway, thanks for the workaround!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,048)