Power Platform Community Forum Thread Details

Perhaps this is the wrong wording for this question but here is what I am trying to do.

I have a data source with multiple columns. Each column represents a parameter that will get appended to a URL that is also entered by the user into the data source.
Not all records will have a value for each parameter. Some will be blank.
The output needs to include the base URL and any parameters that exist for that record.

NOTE: I have not come to a conclusion whether or not the final URL(base URL + parameters) is assembled and then written to the data source or if these URL are assembled at the time for viewing/rendering. If I assemble and write to the data source then this question is moot.

What I need to be able to do, if I am assembling the final URL on the fly for rendering is the following:

Output the base URL
Append a '?' is a '?' does not exist in the base URL otherwise append a '&' (fairly simple using If("?" in ThisItem.'Base URL', "&","?")
Append the value of each column to the base URL if a value exists using an ampersand.
Be aware when it gets to the last column with a value and drop the ampersand.

Make sense?

Categories:

General Questions