Time Stamp when the drop down field updated

(0) Share

Report

Posted on by Samyuktha

Hi Family,

I am trying to get this scenario in my Power App.

I have a multi text filed called Time Stamp and I want to display this field in Read only mode to Users.

I have a Drop Down Field called Status with options "Status A, Status B, Status C, Status D".

Whenever User change the Status field in forward direction like from Status A to Status B I want to add a line in Time Stamp field saying "Status changed from Status A to Status B by User Name at Now()."

Whenever User change the Status field in backward direction like from Status B to Status A I want to add a line in Time Stamp field saying "Status returned back from Status B to Status A by User Name at Now()."

Could you please help me with elaborated steps on how I can achieve this.

Thanks

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Samyuktha

Can you provide more details on your app?

Is this a Form you are working with, or freestyle?

If a Form - what is the Item property of the form?

If freestyle - what is the formula you are using to create/update your records?
Samyuktha 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
I am using Power App Standalone Canvas App.
I am using SubmitForm() to submit the records into SP List.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Samyuktha

Okay - so it is a Form. What is the Item property of the form?
Samyuktha 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Gallery2.Selected
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Samyuktha

Since the selected record of the Gallery may or may not be reliable (this depends on the Items property of the Gallery), I would recommend the following:

1) Whatever it is that takes you to the Edit form (i.e. button, icon, etc.) add the following formula to it: Set(glbCurrentRecord, ThisItem)

2) Change the Item property of the Form to glbCurrentRecord

That should all work identical to what you have now, except that you will now have a variable for the form - which we'll use next.

However, before going to the next step, the following information is needed:

For the Status column:

a) What type of column is it - Text, Choice, etc? I am guessing it is a Choice, but want to be clear how it is defined in your list.

b) What is it about the status that determines that it is moving forward as opposed to moving backward?

c) If you have a dropdown control for the Status, what is the Items property of that control?
Samyuktha 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
1) Status is a Choice Column
2) there is no control to determine forward/backward status. It just has options in it like A) Status, A1)Status B) Status, B2 Status, C3) Status, D) Status, E)Status.. etc. If we can skip this moving forward or backward requirement, can you provide remaining solution?
3) Items property of dropdown control is Choices([@'List Name'].Status)
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Samyuktha

So then without a clear way of knowing what is forward and what is backward, you can certainly update your existing column with information when it is changed.

To do so, the Update property of the 'Time Stamp' column would look like this:

If( !(yourStatusDropdown.Selected.Value = ThisItem.Status.Value), Self.Default & Char(10) & "Status changed from " & ThisItem.Status.Value & " to " & yourStatusDropdown.Selected.Value & " by " & User().FullName & " on " & Text(Today(), ShortDate) & " at " & Text(Now(), ShortTime), Self.Default )
Samyuktha 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes
Thankyou so much. Now we have some hope that we can achieve this in Power App. Can you update the formula to stop appending duplicated status changes.

For example: If status changed from A1 to A3, (append) then A3 to D1, (append) then D1 to A2, (append) then if user change from A2 to A3 again (don't append) this is duplication. We don't want to append this duplicated status change into Timestamp.