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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Change data in sharepo...
Power Apps
Answered

Change data in sharepoint from Yes to No

(0) ShareShare
ReportReport
Posted on by 31

I have created a form to input information into my share point list (Vehicle Access List). On a separate canvas I have a Gallery display page that has been filtered to only display vehicles selected as Yes/ True they are inside. The column is called “InsideV”. 

I need a function that allows me to click icon/button that would change the InsideV for that selected gallery listing to No/False. This should remove that gallery listing from the displayed list. 

thanks for any help

Categories:
I have the same question (0)
  • Ami K Profile Picture
    15,687 Super User 2024 Season 1 on at

    Hi @Tcmoseley ,

     

    Simple example. On the OnCheck property of the Checkbox control, use:

     

    Patch(
     'Your Data',
     ThisItem,
     {'Your Yes No Column': true}
    )

     

    On the Uncheck property of your Checkbox control, use:

     

    Patch(
     'Your Data',
     ThisItem,
     {'Your Yes No Column': false}
    )

     

    On the Items property of the Gallery, enter:

     

    Filter(
     'Your Data',
     'Your Yes No Column' = true
    )

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

  • Tcmoseley Profile Picture
    31 on at

    66DFBDF1-1F79-4933-96FE-CA8B255F4AE2.jpeg

    I am getting this on both the Onuncheck and Oncheck. 

  • Verified answer
    Tcmoseley Profile Picture
    31 on at

    I solved the issue with your help thank you. 

    The Onselect needed to be…

     

    Patch(

            Data Source in share point,

            Gallery.Selected,

            {Column in share point: false}
    )

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

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 316 Most Valuable Professional

#2
11manish Profile Picture

11manish 242

#3
Valantis Profile Picture

Valantis 198

Last 30 days Overall leaderboard