u/edchanted

(Apologies if this is a duplicate, but I could not find my original post. Admin, delete if needed.)

Hi, I have a PowerApp form. I inserted a Drop-down control to the form. I connected the drop-down to my SharePoint List, called "Job Profile Matrix". The column I want in the drop-down to pull values from is called "Job_Families_and_Groups_on_Job_Profile." I want to get the drop-down options to be in alphabetical order for a better user experience. CoPilot hasn't been very useful as it has me using either SortByColumns or Sort, and mixing when "Result" is in quotes or not. Below is my current formula, thats not working. I don't get any errors, but when the user looks at the Drop-Down values in the published version, the values are not in alphabetical order. How do I fix this?

Sort (

Distinct(

'Job Profile Matrix',

'Job_Families_and_Groups_on_Job_Profile'

),

"Result",

SortOrder.Ascending

)

Hi, I'm putting together an Alteryx workflow. Using a corporate database, I have a field called "Previous_Companies" which is a concatenation of all the previous Business Units an associate has worked in while employed at Company A. Business Unit names are separated by a "|" within the "Previous_Companies" field, so it's a long string field. When I export this field to Excel, I want the individual Business Unit Names to be on separate lines within the same cell.

Currently have: Business_Unit_A | Business_Unit_B | Business_Unit_C

Within the same Excel Cell, I want the export to show:

Business_Unit_A

Business_Unit_B

Business_Unit_C

How do I set this up in Alteryx? I attempted to ask CoPilot, but the offered solutions don't work with the new line character (\n). The exported data just adds "\n" between the Business Unit names.

Thanks for any advanced help!