This question came from one of you, and thank you for asking. Such a great idea! In this video we use a multi-select choice field in SharePoint and covert it into multiple checkboxes in Power Apps.
As you select a checkbox and submit the form the data is saved as a multi-select choice field.
0:00 Introduction
1:20 Creating a Multi-Choice Field in SharePoint
2:00 Refreshing the Datasource
3:00 Replace combobox with check boxes
4:15 Collect OnCheck Property
5:04 RemoveIf OnUnCheck Property
6:20 View Collection in a Listbox
6:45 Update Property of Combobox Card
8:28 Concat Selection for Default Property
9:45 If Find() IsBlank()
11:14 OnVisible Property of New Form ClearCollect
13:50 Conclusion
Concat ThisItem Formula:
Concat(ThisItem.LifeCycle,Value,",")
Default of Checkbox Formula:
If(IsBlank(Find(Checkbox1.Text,Label15.Text)),false,true)
Update Card Formula:
colLifeCycle
OnVisible of Screen Formula:
ClearCollect(colLifeCycle,galProjects.Selected.LifeCycle);
21 июл 2024