This is probably going to be an either or answer so let me describe what I am doing.
Scenario:
Dropdown1 - Holiday (Data Source: SharePoint Holiday list, Single Line of Text)
Dropdown2 - Prefix (Data Source: Filtered SharePoint Descriptors list, Single Line of Text)
Dropdown3 - Suffix (Data Source: Filtered SharePoint Descriptors list, Single Line of Text)
tiSwapwith - text
Desired Outcome: Concatenate the values of the the 4 listed fields to compose the 'Official' Holiday Name
Example:
Dropdown4 (Holiday) = Christmas
Dropdown2 (prefix) = blank
Dropdown3 (Suffix) = Holiday
tiSwapWith = Observed
Outcome: Christmas Holiday Observed
I have tried using Concat 4 different ways: (just the basics, not including any IF statements to exclude fields if they are blank at this point). **Important Note: 'Value' is not an available option.
1. Using one of the available options for the field
2. Using a different set of available options for the field
3. Trying a different set of option, but one isn't valid.
4. Trying this way
Since I wasn't able to make this work, I thought I could set the values of these fields to variables and then use the variables in the Concat function.
How can I set multiple variables with a single set command?
I start with Set(varHolidayName, Dropdown4.SelectedText..... but don't know how to finish this to add (varPrefix, Dropdown2.SelectedText) and (varSuffix, Dropdown2.SelectedText
Once I get the basics here down I will add in the IF, IsBlank() etc. to be able set correctly concat using only the fields that have values in them.
All suggestions are greatly appreciated.
