Answered

Patching all items' yes/no column with a button

(0) Share

Report

Posted on by Community Power Pla...

Hi! I have a PowerApp with a sharepoint list as data source, my requirement is if one button (check icon) is selected, it will patch all items' yes/no column to 'yes', how do i do it? Thanks in advance for any help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

cha_cha 4,932 Moderator on at

Like (0)

Report
Hello @Anonymous

You can either use ForAll with Patch.

On the OnSelect property of the code use:

ClearCollect(TempList,SharePointListName); ForAll( TempList as ABC, Patch(SharePointListName, LookUp(SharePointListName, ID=ABC.ID), { YesNoCol: true } ) );

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Do you want to click a check button to update a Yes/No column with 'yes'?

I want to tell you that we could only update a Yes/No with boolean value like true or false, you should change it to Text type if you want to update with yes or no.

Here is a simple formula to achieve your need by setting the OnSelect porperty of the check button as below:

UpdateIf(ListName,true,{'Yes/No':true})

Was this reply helpful? Yes No