cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vidanaw
Helper IV
Helper IV

Check box selections patch to SharePoint choice filed

Hi All,

 

I want to build a Power App with multiple checkboxes for multiple selections and Patch to SharePoint online Choice filed.

eg- Power app screen is as follows 

choice.png

So if user select as above I want to patch Sharepoint choice type filed as " Car, Bus". If the user selects all three I want to patch as "Car, Van, Bus".

Can someone please tell me how to do this?

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Vidanaw 

 

For that you can update the patch expression as:
 
Patch(DataSourceName,Defaults(DataSourceName),{Title:"MultiCheck",choiceColumn:[If(Checkbox1.Value = true,"Car"),If(Checkbox2.Value = true,"Bus"),If(Checkbox3.Value = true,"Van")]})
 
The highlighted part is for the value of choice column.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

1 REPLY 1

Hi @Vidanaw 

 

For that you can update the patch expression as:
 
Patch(DataSourceName,Defaults(DataSourceName),{Title:"MultiCheck",choiceColumn:[If(Checkbox1.Value = true,"Car"),If(Checkbox2.Value = true,"Bus"),If(Checkbox3.Value = true,"Van")]})
 
The highlighted part is for the value of choice column.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,681)