Change color of save button after changes in gallery row

(0) Share

Report

Posted on by Jasmin_Sch

149

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
Jasmin_Sch 149 on at

Like (0)

Report

@RandyHayes Thank you 😘

Was this reply helpful? Yes No
Jasmin_Sch 149 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Jasmin_Sch

What kind of column is LineDeliveryDate?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Drrickryp

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

Was this reply helpful? Yes No
Jasmin_Sch 149 on at

Like (0)

Report

@RandyHayes A date picker column

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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:

Was this reply helpful? Yes No
Jasmin_Sch 149 on at

Like (0)

Report

@RandyHayes ThisItem.LineDelivery=Text
Input Delivery Date.Selected Date=DateValue

thank you!!

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Jasmin_Sch

So there it is...they are not the same type and thus cannot be compared without conversion.

If LineDelievery is a Text value, what format is the date stored in that column? In other words, is it ShortDate, LongDate, ShortDateTime, etc?

Was this reply helpful? Yes No