Formula for collection

[JuanGarcia9]

I am looking to use a button to collect data and transfer to a gallery, one of the input boxes is a drop down and I can't seem to figure out how to make the formula work, the below is the formula I have now;

ClearCollect(

    ForAll(

    contactrequest,

        {

            Account_Id: TextInput2.Text,

            Bpm_Id: TextInput3.Text,

            Responsibilty_Center: DropdownCanvas3.Selected,

            Admin: TextInput5.Text,

            Resp_Product: TextInput6.Text,

            Resp_Group: TextInput7.Text

        }

    )

I also want my drop down to determine the population of two other input boxes based on a separate list I have;

I appreciate the help in advance!

[DJ_Jamba]

I missed the screenshot of the Items screenshot. 

- Add a classic drop down inside the same card

- Configure the classic drop down the same way as the modern drop down

- Reference the classic drop down instead of the modern one
What is the result?

There's only about 5 modern controls approved for production use and the modern drop down is definitely not one of them as it's still in Preview.

[JuanGarcia9]

are you referring to the above or what is actually in the drop down?

the drop down contains numbers, no text unfortunately I can't share the specifics.

[JuanGarcia9]

the previous test runs were done with a classic drop down, still getting a blank transfer.

[DJ_Jamba]

What is blank transfer?

[JuanGarcia9]

I am using the Transfer button to pass the data to the gallery but the drop down data is not going through.

[DJ_Jamba]

The method that you're using to pass the data is via a collection and the value you want to pass is in the collection?

[JuanGarcia9]

Yes! here is the formula for the button 

Collect(

    contactrequest,

    {

        Account_Id: TextInput2.Text,

        Bpm_Id: TextInput3.Text,

        Responsibility_Center: Dropdown2.Selected.'Resp Center',

        Admin: TextInput5.Text,

        Resp_Product: TextInput6.Text,

        Resp_Group: TextInput7.Text

    }

)

[DJ_Jamba]

But you see the value you want to pass in the collection?

Responsibility_Center: "Desired Value is showing here in the collection"

[JuanGarcia9]

you are a legend! I had two collection columns under the same name I just had to switch the property of the text box to retrieve from the right collection column.

I appreciate your help!

I'm sorry if this is asking for too much but you wouldn't happen to know how to now us my drop down data to do a look up from a separate list and bring back the respected data.

I want the responsibility center to determine the product and group from a separate sharepoint list

[DJ_Jamba · Accepted solution]

Happy to help but could you create a new request with the above questions as it would help the community to find specific things if these questions and responses were isolated?