Power Platform Community Forum Thread Details

I have a SharePoint list with a Text field. I am bringing that into my Power App and would like to change the text field to five different checkboxes, representing: Mon, Tue, Wed, Thu, Fri. When a user selects the checkboxes, and saves the Form, the SharePoint list text field would display the items selected. In the example below, the SharePoint list would say: "Mon, Tue, Wed".

I want to ensure that the SharePoint list and the Form are both in sync at all times.

Is this possible to do? Is it better to change the SharePoint field type to a Choice field, and then import it that way?

Basically I am trying to do what is posted in this post, but have it actually work. I am getting a bunch of errors when following these steps Populate a Text Input Box with selected Checkbox i... And who knows, maybe there is a new way now 🙂

Categories:

Building Power Apps

@clammchops

Either way is fine, some would say use a Choice column but you can use Text as well.

To use Text field, like you have setup already, the following should work:

// Default property of each Checkbox
Self.Text in ThisItem.yourSPTextFieldName

// Inside the DataCard for the SP Text Field, add a label called txSelectedDays, then add this to it's Text property
// Note chkMon is name of my Monday checkbox and "Mon" is it's Text property, and so on
With(
 {
 wDayText: Concatenate(
 If( chkMon.Value, "Mon, "),
 If( chkTue.Value, "Tue, "),
 If( chkWed.Value, "Wed, "),
 If( chkThu.Value, "Thu, "),
 If( chkFri.Value, "Fri, ")
 )
 },
 Left( wDayText, Len(wDayText) - 2)
)

// For the Update property of the DataCard for the SP Text Field, add this
txSelectedDays.Text

Should all work, let me know if you get any errors and what they are.

PS you may need to adjust my code to suit your Checkbox/control names