cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rahmed
New Member

How to combine SharePoint list data source to check boxes in Power Apps.

In my Power Apps form I need to show, check boxes by using one of the list as data source. I need to save the selected check boxes values into my SP list. Is this doable?

 

How to combine SharePoint list data source to check boxes in Power Apps.

 

Many thanks in advance.

3 REPLIES 3
yashag2255
Dual Super User II
Dual Super User II

Hi @Rahmed 

 

What is the type of column that you want to patch using the checkbox value?
 
Also, do you have the configuration inside the Edit Form? If so, please follow:
1) Add the field that you want to save data to in your edit form.
2) Unlock the data card properties from the right menu.
3) Remove the existing control inside the data card. If you come across errors then for the coordinate related issues, please replace the values with an absolute value.
4) Add the checkbox corresponding to each value.
5) The main property is the Update property of the datacard that can be updated to:
If(Checkbox1.Value, "Value for Checkbox1", Checkbox2.Value, "Value for Checkbox2")
 
This way you can define the values based on selected checkbox.
 
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!

Thank you for your reply.

As per your question-

1. The data source of the checkbox will be a SharePoint list. The name of the List is "Research Category" and there is one column and the type of the column is "Single Line of Text". There will be 7-10 items in the list so, on the check box it should display 7-10 items.

 

FYI: I don't want any static value in the PoweApps, Check Box items should come form a list so that its easy to update if needed.

Thanks.

 

yashag2255
Dual Super User II
Dual Super User II

Hi @Rahmed 

 

I now understand what you are trying to do. For this, you can set the configuration as follows:

1) Create a Vertical Blank gallery and set the "Wrap Count" to 2 or 3 based on your screen size.
2) Pass Research Category in the Items property of the gallery control.
3) Add checkbox inside the Gallery Item and set the "Text" property of the checkbox to ThisItem.ColumnName
4) When you want to get the list of selected items inside the gallery, you can use the expression:
If you want a list of selected items:
Filter(Gallery1.AllItems, CheckBox1.Value)
If you want a semi-colon separated string of selected Items:
Concat(Filter(Gallery1.AllItems,Checkbox1.Value),ColumnName,";")

 

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,108)