add item in a dropdown

[vincenzos1984_1]

 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

[eka24]

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]

i need take choise dinamycally.. if someone add another choise on sharpoint your solution work whitout new Choises

[eka24]

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]

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]

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]

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

[v-bofeng-msft · Accepted solution]

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