Answered

How do I update a Dataverse Table with a multi select combo box

(0) Share

Report

Posted on by Lukewarm

I am learning Power Apps. Many years ago I programmed in VB 6. A lot has changed since then.

I am building a expense report that requires the user to select all the individuals in the carpool. Carpool is a multi select drop down box. I know that .SelectedItems gives me a table of the carpool members the user selected. I don't know how to access the individual members of the table.

The database table that contains the carpool members has a row for each member of the carpool and the reimbursement number.

This is the code I have:

ForAll(
Carpool.SelectedItems
Patch(
Carpools,
{
'Reimb Numb':First(colStageMinReimb).ReimbNumber,
'Sem Name': This is where I need help. As the function iterates through the selected items, what parameter do I pass?
}
)

)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lukewarm ,
You can also see a related post here: Community Link

Hope this helps

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lukewarm,

Do you want to patch multi select Choice column in your Dataverse table?

If it is a normal multi-select-Choice column and you set the ComboBox with Choices() function, you could directly use the following formula:

Patch( Carpools, { 'Reimb Numb':First(colStageMinReimb).ReimbNumber, 'Sem Name': Carpool.SelectedItems } )

Or you could hard-code the selectedItems as below:

Patch( Carpools, { 'Reimb Numb':First(colStageMinReimb).ReimbNumber, 'Sem Name': Table({Value: Choice1list.A},{Value: Choice1list.B}) } )

Was this reply helpful? Yes No
Lukewarm 49 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for replying to my question. Here is an example of what I'm after. Let's say I have six people
Bob, Lynn, Joe, Barb, Jackie and Rob. They travel together on a regular basis. They are reimbursed for mileage. For each of them, I need to track the dates and locations they traveled to regardless if they submitted an expense report. If Bob, Joe and Lynn traveled together, I want the entries in the carpools table to be:

Reimb Numb Sem Name
10001 Bob
10001 Joe
10001 Lynn

If the next trip Lynn, Barb and Rob traveled together, I want the entries in the carpools table to be:

Reimb Numb Sem Name
10001 Bob
10001 Joe
10001 Lynn
10002 Lynn
10002 Barb
10002 Rob

The problem is 'Sem Name' is defined as a text field in the database. In the first solution you offered, I get an error since it is populating a value that is defined as a table into a text field.

Again, I appreciate your help.

Was this reply helpful? Yes No
Verified answer

Lukewarm 49 on at

Like
a
(0)

Report
Copy link

Link copied!

I figured it out. I needed to use the ThisRecord followed by the field name used to populate the combo box. I thank you both for replying to my question. Y'all provide a valuable service.

Was this reply helpful? Yes No