Reset value after clicking button

[Elitezone]

Hi everyone,

Thanks to your help I recently implemented Likebox to my proposition app. It work flawlessly but I have one problem.

When people send propositions they can edit them on EditForm. So for example you send one proposition - get a lot of likes and then edit it into something different.

I get it that some changes are sometimes required and I allow people for that but that should cost them a reset of likes.

So on Edit form I have a button with a bit of validations:

If(IsBlank(DataCardValue11.Text);Notify("Need a proposition name.";NotificationType.Error);
If(IsBlank(DataCardValue18.Selected.Value);Notify("Need a category name.";NotificationType.Error);
If("Legal change" in DataCardValue18.SelectedItems.Value && IsBlank(DataCardValue22.Text);
Notify("You need to write a legal change basis.";
NotificationType.Error);
If(Len(DataCardValue19.Text) < 79;Notify("In this field you need at least 79 characters"; NotificationType.Error);
SubmitForm(Form4))));Navigate(Screen8;Fade))

I give people likes with this function:

If(
    User().Email in Split(
        ThisItem.'Kto polubił';
        ";"
    );
    Notify("Możesz polubić propozycję tylko 1 raz.");
    Patch(
        IdeaBox_1;
        ThisItem;
        {
            Polubienia: ThisItem.Polubienia + 1;
            'Kto polubił': ThisItem.'Kto polubił' & ";" & User().Email
        }
    ))

Polubienia= Likes (number field) in Sharepoint list

Kto polubił = Who liked - single line value (text) in Sharepoint list

Is there a simple way to clear values of likes and who liked when you Submit a form?

[Anonymous · Accepted solution]

Hi @Elitezone,

You could add the Polubienia and Kto polubił fields to your form, but set their visibility to false. Set the Update property of Polubienia to 0 and the Update property of Kto polubił to Blank(). These values will be updated to the Sharepoint list each time the form is submitted.

[Elitezone]

It was hard, but I belive that I made it work.

I change my function Submit to variable, and this variable was making a MsgBox visible. On this MsgBox I placed yes/not, on yes it was submitting form, on no it was setting variable to false.

And I changed update properties that you said.

Seems to work greatly.

[Anonymous]

Hi @Elitezone, that sounds like a good way of doing it! 👍

[Elitezone]

@Anonymous 

Something is wrong with this solution!

1 error:

In gallery there is a label:

ThisItem.Polubienia

The value 0 is on a position that was edited.

No value is on a new position.

This is problematic. They are both technically the same but shows the different stuff.

Also, I cannot add like to the one with value 0. It shows that I already liked that.

It is because this Blank() function does not work. I added it in Kto polubił Update section but it just doesn't delete the data.

It delete amount of likes but it does not delete email of people that liked.

I have no idea why.

Edit#

I have fixed 1 error - I made this sharepoint field default value 0.

Now it is good, but the second one is critical...

[Anonymous]

Hi @Elitezone,

Ok, regarding the number Polubienia, there are a couple of things you could do. Firstly, a quick fix would be to have the label in the gallery visible only if the value is greater than zero. To do this, on the Visible property put:

ThisItem.Polubienia > 0

 
Alternatively, you could use Blank() in the Update property, but it would require a setting change. See this link for some details: http://powerappsexamples.com/patch-null-value/

For your Kto polubił text field, instead of using Blank() in the Update property, try simply setting it to 

""

Hopefully that fixes it!

Joel

[Elitezone]

For the first problem - I just set default value in sharepoint for this field. It worked.

Second one was solved. Thanks to your suggestion.

Thanks.