Combine Dropdown texts populated from an Excel Sheet to a string

(0) Share

Report

Posted on by Kampagnenmeiste

Hello Everybody,

I want to generate a string made out of some input texts and dropdown values populated out of an excel sheet.

Example {TextInputName} has {DropdownEyecolor} eyes and {DropdownHaircolor} hair.

The eye and hair colors are listed in an excel sheet and I see them im my dropdowns. Really great.

The string should be shown in a final text input field. If I enter dropdown.selectedtext in the textinput.default, I get the error that textinput wants a text value.

I also tried dropdown.selected.value and dropdown.selected.result and all other combinations I could find in this forum.

I also tried to have my hair and eye colors in an sharepoint list. Same result.

How can I use these variables in a default text of an input field?

Thank you for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

SpongYe 5,905 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Kampagnenmeiste

Create 2 variables:
// DropdownEyecolor.OnChange Set(varEyecolor, DropdownEyecolor.Selected.Value) // DropdownHaircolor.OnChange Set(varHaircolor, DropdownHaircolor.Selected.Value)
If your text input field is named TextInputName:
TextInputName.Text & " has " & varEyecolor & " eyes and " & varHaircolor & " hair."
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Verified answer

Kampagnenmeiste 14 on at

Like (1)

Report
Copy link

Link copied!
Hello @SpongYe , thank you for your fast response. I understood the approach, needed to change the code and found a solution.

I needed to change:
//onchange
Set(varEyecolor; Eyecolors.Selected)

In my current config the eyecolor is stored in a sharepoint list; the haircolor is stored in an excel. So the textinput looks like

TextInput1 & varEyecolor.Title & varHaircolor.Tablename
This works for me. Thank you @SpongYe for guiding me.

Was this reply helpful? Yes No