Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

How to handle spaces in datasource values that are utlized in URLs?

I am building a form where the user does the following:


  1. Enter a base URL
  2. Chooses options from combo boxes and enters values in text boxes
  3. All of this gets entered into a datasource


Assemble these values into a valid URL.



Now, at the moment I have each individual field getting entered into its own column in the data source. I do not assemble the URL and enter it into its own column although I am considering this. I do not account for spaces in the field values either. For example, utm_campaign might be something like "Fall Sale Event". What gets entered into the data source is "Fall Sale Event". The problem is that is you try and assemble a URL you have spaces. What should be there in place of the spaces is %20. How would I handle these spaces? Do I enter the %20 into the data being entered into each column of the data source? Do I assemble the URL and add the %20 at that point and then write the assembled URL to the data source? Or do I assemble the URL in a gallery and deal with the spaces there? And, of course, how do I handle swapping out the spaces?


Ultimately, this would go for any encoding that needs to be done. Not just spaces.


That's what I was actually noodling on doing. Doesn't even need to be hidden necessarily. 

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (59,943)