Detect if any changes were made

[Elitezone]

Hello,

I have a formula:

If(IsBlank(DataCardValue11.Text);Notify("Musisz wskazać nazwę propozycji.";NotificationType.Error);
If(IsBlank(DataCardValue18.Selected.Value);Notify("Musisz wybrać przynajmniej jedną nazwę kategorii.";NotificationType.Error);
If("Zmiana Legislacyjna" in DataCardValue18.SelectedItems.Value && IsBlank(DataCardValue22.Text);
Notify("W przypadku wybrania pola kategoria 'Zmiana legislacyjna' należy uzupełnić dodatkowe pole dotyczące zmiany przepisu.";
NotificationType.Error);
If(Len(DataCardValue19.Text) < 79;Notify("W polu opis zmiany należy wprowadzić minimum 80 znaków.";NotificationType.Error);
If(IsBlank(DataCardValue9.Selected.Value);Notify("Musisz wskazać zasięg zmiany.";NotificationType.Error);
UpdateContext({variableDefault:" "});UpdateContext({showDialog:true;variableDefault:""}))))))

This formula is placed on button - it has a lot of verification, and then if all is correct it set showDialog to true - this shows popup do you really want to save?

My problem is that this popup will be shown even if no changes were made. And saving means a lot in my app (It delete a lot of data - reset likes etecera).

Is it possible to detect if changes were made? Or even set button inactive if there are no changes?

I will be grateful for your help 😉

Thank you.

[v-jefferni]

Hi @Elitezone ,

There is a logical problem in you formula.

You are in the Form of Edit Mode, so the If statement always returns the false result "DisplayMode.Edit".

Modify the formula to:

If(Form4.Mode=FormMode.Edit && varChange1=1; DisplayMode.Edit;DisplayMode.Disabled)

For the second question, if varChange equals 1, then it means value has been changed, why the hint would be "Nothing Changed"?

I suppose that you want to make the button's hint be "Saved" when user has no operation on any controls?

If so, I suggest you set another variable on the OnChange properties:

Set(varOperate1,1)
Set(varOperate2,1) 
etc.  

And OnVisible of the screen:

Set(varOperate1,0);Set(varOperate2,0)

The button's Tootip should be:

If(varOperate1=0&&varOperate2=0,"Saved",varChange1=0&&varChange2=0&&(varOperate1=1||varOperate2=1),"Nothing changed","")

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Elitezone]

@v-jefferni 

If(varOperate1=0&&varOperate3=0&&varOperate4=0;"NO changes made";varChange1=1||varChange3=1||varChange4=1&&(varOperate1=1||varOperate3=1||varOperate4=1);"Save changes";"")

Tooltip works perfectly like that! 

I wanted to have a dynamic tooltip - when button is active it had to show SAVE! when inactive DO SOME CHANGES!

This solution works but it is a bit crude 😉 Button is not dynamic - it won't change unless I click in a different place on the Screen. But it works. That is the most important thing!

All your solution works right now! I just have last problem with making this validation:

I tried to do it like this::

Set(varChange2;If(DataCardValue18.Selected.Value=Gallery1.Selected.Kategoria.Value;0;1));;Set(varOperate2;1)

But it shows DataCardValue18 invalid type of argument.

Gallery1 is a parent gallery to this screen.

Kategoria is a name of Sharepoint list field (drop down).

Something is wrong... I was trying your Text but it was showing unknown name so I thought that for drop down I need Selected.Value... But still something is off.

Lack of this solution kills my app and I will have to delete all solution because when someone change only category - button will be still blank... 

[JefferNi]

Hi @Elitezone ,

If the Items of the Dropdown is List.Kategoria, rtry:

Set(varChange2;If(DataCardValue18.Selected.Kategoria=Parent.Default;0;1));;Set(varOperate2;1)

Regards.

[Elitezone]

@JefferNi @v-jefferni 

Name was not recognized, and invalid type of argument.

[v-jefferni]

Hi @Elitezone ,

Which formula did you apply on the Items of the Dropdown Box?

If is Distinct(), then should be DataCard.Selected.Result;

If is List.Column, then should be DataCard.Selected.ColumnName.

You can see the recommended results list dropping down after putting up a dot after some schema, right? The answer is mostly in the list.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution  to help the other members find it.

[Elitezone]

@v-jefferni 

Choices([@IdeaBox_1].Kategoria)

This is my formula on dropdown list Items. It takes from Sharepoint list. 

This formula does not work:

Set(varChange2;If(DataCardValue18.Selected.Value=Choices([@IdeaBox_1].Kategoria);0;1));;Set(varOperate2;1)

Invalid type of argument.

With Selected.Value it does not even show "tips or possible choices".

When I change Selected.Value to SelectedItems Choices appears as a choice after it but it spams errors:

Set(varChange2;If(DataCardValue18.SelectedItems=Choices([@IdeaBox_1].Kategoria);0;1));;Set(varOperate2;1)

Invalid type of argument.

[Elitezone]

@v-jefferni 

I also tried this:

Set(varChange2;If(DataCardValue18.Selected.Value=Choices(IdeaBox_1;ThisItem.Kategoria);0;1));;Set(varOperate2;1)

But it shows that function Choices has invalid arguments. 

[v-jefferni]

Hi @Elitezone ,

What field type is the Kategoria column in "IdeaBox_1" List? Choices or LookUp? 

Please share the details about SP list column settings and Control settings in the form.

Best regards,

Community Support Team _ Jeffer Ni

[Elitezone]

Column type: Choice (menu from which you can choose)
DropDown menu

Allows multiple selection.

Required yes

Pola wyboru = Field of choices (allows multiple selection)

From control (if I understand correctly):

COMBI FIELD

[v-jefferni]

Hi @Elitezone ,

Is it the right setting that allow multiple selected? Since IMO category is mostly unique for an item.

When I switched to yes of the list column's "Allow multiple selection", in my test app it caused an error in the DataCard Default property:

How did you deal with the error?