Unanswered

Button not working

(0) Share

Report

Posted on by kORINNERB

Hi As part of my formula on my screen, when i press a button to send an email, i am also wanting to clear a column in sharepoint when i leave the screen, so i have put this below in the formula to patch the column to be blank but does not seem to working,

Not sure why it is not working

Patch('QHSE questions',{'Audit Complete':Blank()})

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@kORINNERB

The call to Patch requires us to specify the record to update as the second argument. This is missing in your formula, which explains why it doesn't work.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-patch

Was this reply helpful? Yes No
kORINNERB 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

I have tried following the advice but still seem to have an issue , ammended the formula below but still doesnt change?

Patch('QHSE questions',Defaults('QHSE questions'),{'Audit Complete':Blank()})

Also i want to set all items in that column to blank, not a specific record, is this the right formula to use?

Was this reply helpful? Yes No
zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

You'll use UpdateIf to update multiple items with that result.

UpdateIf('QHSE questions', true, {'Audit Complete': Blank()})

That should set all values in that column to blank.

Was this reply helpful? Yes No
kORINNERB 96 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you, i have tried the formula but it is not working for me, i checked the sharepint list and the column still has items in it.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kORINNERB ,

Please open this setting.

Best Regards,

Wearsky

Was this reply helpful? Yes No
bhartiA 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kORINNERB

You can use UpdateIf function, where you can use ID=Value(ThisItem.ID).

Hope it will work for you.

Was this reply helpful? Yes No