Answered

Clearing an entire column in a Sharepoint list

(1) Share

Report

Posted on by Kazzao

Hi Powerapps community,

I've been progressing with a work app and have recently hit a wall. I've attempted several answers on this forum but the results the question-asker requires differ from mine somewhat.

Basically I'm designing a checklist for monday-friday. Go to X, check if it's okay, if so, respond with Yes or No via dropdown box.
This data is then displayed in a sharepoint list with each of the tasks each day with a Yes or No associated to it.

Question: What I'm stuck with now is, on a Friday afternoon, I'm required to backup the list (done that) but afterward, will need to clear the columns for the following Monday.

The columns are labelled "Loaded" & "Unloaded*. with Yes or N/A as the answers.
I'd hoped something like Patch('Source', Unloaded, Blank() ) would work, but no luck.
I've also tried playing around with Clear and Remove functions with little results.

Anyone able to shed some light on what I'm doing wrong here?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kazzao ,

Try

UpdateIf( Source, Uploaded="Yes" || Uploaded="N/A", {Uploaded:Blank()} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Kazzao 26 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey Warren,

Appreciate your hasty reply. I've tried playing around with your response a little before responding.
It still seems to not update the Sharepoint list. Do note, the page where I'm using the button that clears the fields in on a seperate 'Settings" type page. Not sure if that interferes with the data. Not being on the same screen as the form and all.

UpdateIf( 'Source'.Unloaded, Unloaded.Value = "Yes", {Unloaded:Blank()} )
Here's what I've been playing around with. I changed the unloaded to just 1 column to begin with.

I was also getting a red line underneath the Unloaded section unless I placed a .Value afterward, but dont think that helped too much. Also, do you mind explaining the use of curly brackets in your response?

For the time being I'm happy with just attempting to add/remove select data using a button that isn't apart of a form and learning from there 😅

Really appreciate your response mate.
Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Kazzao ,

Your Unloaded field must be a Choice field? If so try

UpdateIf( 'Source', Unloaded.Value = "Yes", { Unloaded:{Value:Blank()} } )

I have also done a blog on Controls and their references that may be helpful to you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Kazzao 26 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

Thanks again so much for your persistence. I did manage to get the desired result using a slightly tweaked version of your code.

UpdateIf( 'Source', Unloaded.Value = "Yes", { Unloaded:{Value: " "} } )
Having the Value set to " " rather than blank() set the sharepoint list to the blank default choice selection.

Appreciate you linking your blog also. I've enjoyed reading it.

Thanks again mate.