Button not working

[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()})

[timl]

@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

[kORINNERB]

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?

[zmorek]

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. 

[kORINNERB]

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.

[v-xiaochen-msft]

Hi @kORINNERB ,

Please open this setting.

Best Regards,

Wearsky

[bhartiA]

Hi @kORINNERB 

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

Hope it will work for you.