Change color of save button after changes in gallery row

[Jasmin_Sch]

Hi everyone,

I created a repeating table using a vertical gallery (datasource=SharePoint list)

I save/patch each row with a save button.

The color property of my save button:

If(ThisItem.IsSelected=true;Red;RGBA(0; 18; 107; 1))

But I want it rather to be like “if this item is changed”. After my users have made changes in a row I want the button in this row to turn and stay red until they have clicked the save button so that they don’t forget to save their changes.

Is this possible?

Thank you!

[RandyHayes · Accepted solution]

@Jasmin_Sch 

You will need to establish the logic in your Formula to determine if it is changed or not.

Now, how to put that in is going to be dependent on how you are populating the information in the gallery controls.

So for example, if you have an Items property on the Gallery for something like...Filter(yourDataSource, someCriteria)

And, let's just say you have a Title column and in your Gallery there is a TextInput control for changing the Title.  The Default property on it would be ThisItem.Title.

Then for your Color property on the Save button.

If(ThisItem.Title <> TextInputForTitle.Text, Red, RGBA(0; 18; 107; 1))

You would add into that formula any other column comparisons you need.

I hope this is helpful for you.

[Jasmin_Sch]

@RandyHayes Thank you 😘

[Jasmin_Sch]

@RandyHayes Just one more question.

Regarding my date picker column I am facing some difficulties:

ThisItem.LineDeliveryDate<>‘Input Delivery Date‘.SelectedDate

An error occurs below „<>“ (type not compatible. Function can not be evaluated)

What’s my mistake?

Thank you very much!

[RandyHayes]

@Jasmin_Sch 

What kind of column is LineDeliveryDate?

[Drrickryp]

@RandyHayes 

This is the one I recommended using a hidden form with her repeating gallery. She can probably leverage the form unsaved property to control the status of her save button as well as notifications and popup in some of her subsequent questions.

[RandyHayes]

@Drrickryp 

Yes, I recall that post!  That would make sense.

[Jasmin_Sch]

@RandyHayes A date picker column

[RandyHayes]

@Jasmin_Sch 

Go to your formula and put your cursor at these locations:

Then in the formula editor see what it is showing for the DataType:

[Jasmin_Sch]

@RandyHayes ThisItem.LineDelivery=Text

Input Delivery Date.Selected Date=DateValue

thank you!!