Answered

add item in a dropdown

(0) Share

Report

Posted on by vincenzos1984_1

117

hi to all i have a dropdown that is popolated by a choise in a sharpoint. The list called peopleGender and the column gender

Choices('peopleGender '.gender).Value give in the output the two choised of sharepoint "male", female"

i put in dropdow item Choices('peopleGender '.gender).Value and it show me the two value, i want add another field until "male", female" in dropdown. it's possible?

thanks in advance

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

You can replace that with:
["Male","Female","Other","Another"]
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
vincenzos1984_1 117 on at

Like
a
(0)

Report
Copy link

Link copied!

i need take choise dinamycally.. if someone add another choise on sharpoint your solution work whitout new Choises
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Your own solution is already dynamic
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
vincenzos1984_1 117 on at

Like
a
(0)

Report
Copy link

Link copied!

when i put this?
["Male","Female","Other","Another"] ? if i put directly in item is static solution

i need take choises from sharepoint and add only a static value
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vincenzos1984_1 :
Do you wish to add other options to the drop-down control?
My method is to achieve dynamic results through function composition.
I suggest you try this code:

Distinct( /*Remove duplicates to prevent duplicate options from being duplicated with the original options*/ Split( /*Change the new string back to the table*/ Concatenate( /*Add new options (also separated by ";") */ Concat( /*Adjust the original table options to ";" separated string*/ Choices(peopleGender.gender), Value, ";" ), ";", "Other", ";", "AnOther" ), ";" ), Result )

Best Regards,
Bof
vincenzos1984_1 117 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks a lot im going to test this it's what i want :), it's possible to add first the static value ["Other","Another"] and after concatenate the choises?

thanks in advance
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @vincenzos1984_1 :
Do you want to bring "Other" and "AnOther" to the front?
Please try this code:

Distinct(/*Remove duplicates to prevent duplicate options from being duplicated with the original options*/ Split(/*Change the new string back to the table*/ Concatenate(/*Add new options (also separated by ";") */ "Other", ";", "AnOther", ";", Concat(/*Adjust the original table options to ";" separated string*/ Choices(peopleGender.gender), Value, ";" ) ), ";" ), Result )

Best Regards,
Bof