Answered

Make a toggle in a form patch an multitselect field YES/NO

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I want to insert an toggle into a form. I want this toggle to patch an multiselect column in sharepoint list with the choiches YES/NO.

True=Yes, False=No

Is this possible?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :

Yes,the key is to modify the UpdateProperty of the data card.

Could you tell me does the "multiselect column" allow mulitple selections?

My data source: 'A'

Q1-Choice(do not allow multiple selections)

Q2-Choice(allow multiple selections)

Step1:Add a edit form

DataSource

A

Item

First(A)

Step2:Use troggle to replace the original combobox control

Step3:

Set the Q1_DataCard1's Update proeprty to:

If(Q2Toggle2.Value,Table({Value:"Yes"}),Table({Value:"No"}))

Set the Q2_DataCard1's Update proeprty to:

If(Q2Toggle2.Value,Table({Value:"Yes"}),Table({Value:"No"}))

Step4:Fix some errors caused by deleting the control according to the error message. (Because it does not affect the function realization, I did not perform this step)

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hello!

I get this error:
The value Record was expected
when i try this code on the datacard:

If(Q2Toggle2.Value,Table({Value:"Yes"}),Table({Value:"No"}))

The column in sharepoint list does not allow multiple selection. You can only choose either YES or NO from a dropdown
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous :

The field on yourside seems do not allow mulitple selections.If so,there is no need to use the Table() function.

Please try this code:

If(Q1Toggle1.Value,{Value:"Yes"},{Value:"No"})

Best Regards,

Bof