web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Textbox with a combina...

Power Apps

Answered

Textbox with a combination of 2 DropDown.

(0) Share

Report

Report

Posted on by RL-26071304-0

126

Hello everyone.

I have an excel spreadsheet with a table I imported to powerapps.

On powerapps, I have a TextBox where I want to show a result of a combination between 2 DropDown.

In this particular case (image attached), TARGET is influenced by DEPARTMENT and PROJECT.

Is that possible? If so, can you help do this?

Thank you.

Annotation 2022-01-11 123944.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

v-JessicaG-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RLeite ,

You could use the "Concatenate" function to combine the values of the two DropDown selections. I have test for your reference, please try the following workaround:

Expression:

Concatenate(Dropdown4.Selected.'Expiry date',Dropdown5.Selected.ItemInternalID)

Best Regards,

Jessica Gu

Was this reply helpful? Yes No
RL-26071304-0 126 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response but probably I didn't explain my problem very well.

My excel spreadsheet has 3 columns: DEPARTMENT, PROJECT and TARGET.
I would like my TARGET textbox to show a value regarding the choice of DAPARTMENT and PROJECT.

Was this reply helpful? Yes No
Verified answer

v-JessicaG-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RLeite ,

Why are you using DropDown to display the values of the DEPARTMENT and PROJECT columns?

Are you displaying DropDown and textbox in a Form? If you want TARGET column value to display "DEPARTMENT" column value and PROJECT column value in the same record, you could use the "Concatenate" function to combine the values of DEPARTMENT and PROJECT columns together.

Best Regards,

Jessica Gu

Was this reply helpful? Yes No

Join the conversation