Saving a Combobox Multislect data into SP List

(0) Share

Report

Posted on by JoseAlves

Hello Everyone,

I am relatively new to PowerApps and would like to create a app to book company cars.

The current setup is the following.

Table 1: All the names of the workers in a column

Table 2: All the history of requests

on the powerapp I have a combobox showing all the workers names (From table 1) so you can select who is going in the car.

I would like to save the selected workers on a column in table 2. I tried using SelectedItems but it does not work.

How can i work this out?

Thank you

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JoseAlves

Suppose the name column of the Workers list and the column that stores the name in table2 are both text columns.
I made a test for your reference:

1.

2.

3.

Patch('Request History',Defaults('Request History'),{Requestor:Concat(ComboBox1.SelectedItems,Name,",")})

4.

Best Regards,

Levi
JoseAlves 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Levi,

Thank you for your quick reply.

I wanted to do it as a list with multiple choices, i think that way i could use the information in a easier way in further developments.
Is it posible?

Thank you.
José
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JoseAlves

May I ask what you mean is that the column used to store names in table two is a multi-choices column?
I modified the datasource and test according to your needs:

Patch( 'Request History', Defaults('Request History'), { requestor: ForAll( ComboBox1.SelectedItems As nameTest, {Value:nameTest.Name} ) } )

Best Regards,

Levi
JoseAlves 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Levi,

That was what i needed, to store the information in a multichoice column.

Is there a way to use a multi-choice column without creating all the options previouslly ?
For example, i want the workers to select the client or clients they are going to visit but that list can be quite long. Is there a way i can populate the options of the multichoice column based on another table with all the options?

Thank you
v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JoseAlves

Also available without prefill option.

Best Regards,

Levi