web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Check box in edit screen
Power Apps
Answered

Check box in edit screen

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi 

I got a requirement add check box in edit screen,instead of default combo box.

Data source is from share point as below

 

this is sharepoint view in the form

dhananjaya_0-1621885749990.png

Share point details as below

 

dhananjaya_1-1621885852219.png

 

I removed existing combo box in the data card and try to add check box as below ( just two for testing )

 

dhananjaya_2-1621885943483.png

How can I write code in update function in data card. It gives me errors and no idea how can I integrate check box to match with it..

 

dhananjaya_3-1621886065694.png

 

Please help on this

Categories:
Building Power Apps
  • CNT Profile Picture
    CNT 10,921 Super User 2024 Season 1 on at

    @Anonymous Is the number of choices in the sitting column static or will it change over time?

  • Verified answer
    v-albai-msft Profile Picture
    v-albai-msft Microsoft Employee on at

    Hi @Anonymous ,

    I did a test on my side for you reference.

    You can see below screenshot, I have added 5 checkboxes inside Siting DataCard :

    v-albai-msft_0-1621910270188.png

     

    Here is the code in Update property of Siting DataCard:

    ForAll(
 Split(Concatenate(
 If(Checkbox1.Value, Checkbox1.Text & ",", ""),
 If(Checkbox2.Value, Checkbox2.Text & ",", ""),
 If(Checkbox3.Value, Checkbox3.Text & ",", ""),
 If(Checkbox4.Value, Checkbox4.Text & ",", ""),
 If(Checkbox5.Value, Checkbox5.Text & ",", "") 
 ),
 ","
 ),
 {Value: Result}
)

    v-albai-msft_1-1621910270195.png

     

    You can check result now, try to add a new list item through your app.

     

    Besides, based on your own requirement, maybe you need to set Defaults property of each checkbox, so that when you edit an existing record, the corresponding checkbox will have the value.

    So set the Default property of the SitingCheckbox to following(my control name is Checkbox1😞

    If(Checkbox1.Text in ThisItem.Siting.Value, true, false)

    v-albai-msft_2-1621910270203.png

     

    Set the Default property of the SetoutCheckbox to following(my control name is Checkbox2😞

    If(Checkbox2.Text in ThisItem.Siting.Value, true, false)

    v-albai-msft_3-1621910270206.png

     

    Repeat above step for all other checkboxes.

    Best regards,

    Allen

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @v-albai-msft , Really appreciate your support. I feel it is so great... 

    As you said, I create a like this ( Still testing)

     

    dhananjaya_0-1621972550673.png

    and cording 

    ForAll(
    Split(Concatenate(
    If(Checkbox1.Value, Checkbox1.Text & ",", ""),
    If(Checkbox1_1.Value, Checkbox1_1.Text & ",", ""),
    If(Checkbox1_2.Value, Checkbox1_2.Text & ",", ""),
    If(Checkbox1_3.Value, Checkbox1_3.Text & ",", ""),
    If(Checkbox1_4.Value, Checkbox1_4.Text & ",", "")
    ),
    ","
    ),
    {Value: Result}
    )

     

    No errors give in the code, but when I try to add a record, it trigger run time error

    dhananjaya_1-1621972691350.png

    the issue is, I couldn't find any filed call Title, What can be this issue ? 😞

     

     

  • CNT Profile Picture
    CNT 10,921 Super User 2024 Season 1 on at

    @Anonymous Title is a field automatically created in a SP list and it is mandatory. But you can change it, GO TO,

    CNT_0-1621973628567.png

     

    Click in Title

    CNT_1-1621973694165.png

     

    Change to No

    CNT_2-1621973739748.png

     

    Refresh the datasource inside the Power App

     

    Please remember to give a 👍 and accept the solution as it will help others in the future.

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @CNT 

    When I check, there wasn't Title column. So for testing, I added it. But same error is triggering 😞 

    I am not the one who build SP table initially. Do u think is this due to  Title column was renamed to some other name ?

     

    dhananjaya_0-1622032860958.png

     

    dhananjaya_1-1622032901983.png

     

    dhananjaya_2-1622032977446.png

     

  • CNT Profile Picture
    CNT 10,921 Super User 2024 Season 1 on at

    @Anonymous Yup, that's possible. It could have been renamed. As I had mentioned, SP by default adds this mandatory Title Column and when PA writes back to SP, because this Column is not getting patched, u'r getting an error. Please ask the creator of the SP list about the mystery behind the Title column. Hope this helps!

  • Verified answer
    v-albai-msft Profile Picture
    v-albai-msft Microsoft Employee on at

    Hi @Anonymous ,

    You can get Required information for all columns in below Columns section:

    v-albai-msft_0-1622079240740.png

    All these required columns should have values when saving into Sp list on App side. Add all your required columns in your form or make them unrequired(not suggest).

    v-albai-msft_1-1622079461911.png

    I would strongly recommend you not to change the column property, just add these required columns into your form, since make them unrequired may cause other issues(especially for the Title column, this is very important in SharePoint side when doing some search function).

    Best regards,

    Allen

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-albai-msft @CNT 

    you both are gr8. Really help to fix my app issues.  yes, as you mention Comment column had required tick, so I added it into PA. Now issue get solved. 

     

    Thanks a again Guys. 🙂

     

  • CNT Profile Picture
    CNT 10,921 Super User 2024 Season 1 on at

    @Anonymous Glad to help!

     

    Please remember to give a 👍 and accept the solution as it will help others in the future.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans