Power Platform Community Forum Thread Details

Hey there, first time caller 👋 I'm having issues with a Combo Box.

I'm pulling in a list data from an Excel table connector: ["Name","Campaign"]. No issues there.

Searchable is set to "true".

I'm trying to allow someone to either select from the existing items in the combo box (e.g., fish-fy24) or they can enter their own option (e.g., catsanddogs). Whatever they do, I need to append some text (&utm_campaign=) and then pass the entire value to a separate field. If they haven't selected anything, or typed in anything, then there should be nothing in the separate field. For my separated field, I'm using Concatenate to pull together data from other fields (including the combo box data) and then displaying that.

I'm running into issues getting that data to pass to the field, but I'm also having issues NOT showing the appended text when nothing is typed-in/selected. Any help would be appreciated. See below (code and image):

Code:

Concatenate(
 If(WebsiteURL.Text <> "", WebsiteURL.Text), 
 If(UTMSource.Text <> "", "?utm_source="&UTMSource.Text), 
 If(UTMMedium.Text <> "", "&utm_medium="&UTMMedium.Text), 
 If (
 Or('cb-UTMCampaign'.Selected.Campaign <> "", 'cb-UTMCampaign'.SearchText <> ""),
 Coalesce("&utm_campaign=", 'cb-UTMCampaign'.Selected.Campaign, 'cb-UTMCampaign'.SearchText),
 ""
 ),
 If(UTMContent.Text <> "", "&utm_content="&UTMContent.Text), 
 If(UTMTerm.Text <> "", "&utm_term="&UTMTerm.Text)
 )

Image

Screenshot 2024-05-03 at 3.00.16 PM.png