Version information field

[marcoagastelum1]

Hello,

I am trying to see if I can add a field (i button below) where the user can click on the button and see how the status has changed, the date of when it changed and by who, is this possible?

Thanks in advance!

[WarrenBelz]

Hi @marcoagastelum1 ,

Put a custom card in the form and then put a label in the card with this as the Text

"Modified - " & Text(ThisItem.Modified,ShortDate) & " by " & ThisItem.'Modified By'.DisplayName

Make the Visible of the label a Variable (I will call it varShowMod). Then the button OnSelect would be

UpdateContext({varShowMod:!varShowMod})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[marcoagastelum1]

@WarrenBelz 

Thanks for the help! that worked 🙂

Only one issue, is there a way for it to create a list?

so that the user can know when it from "New" to " In progress" or "Completed"

looking for a list like below

Modified to "New" - 12/1/2020 by Jane Doe

Modified to "In Progress" - 12/2/2020 by Michael Johnson

Modified to "Completed" - 12/3/2020 by Adam Jones

Something like that, is that possible?

Right now I am just getting the latest change and it does not mention the status that it changed to like below:

Modified - 12/1/2020 by Jane Doe

Thanks Warren!

[WarrenBelz · Accepted solution]

Hi @marcoagastelum1 ,

The "low tech" way is available natively in SharePoint with Versioning, but this is not visible in Power Apps.

What you would need to do is create a separate SharePoint list (I will call it StatusChange below) - it only needs four fields

• A numeric field for the ID of the main item (IDRef).
• A Text Field for who modified it (ChangedBy)
• A Text Field with the new Status (StatusTo)
• A date and time field for when (StatusDate)

On the OnChange of the Status drop-down - something like this

Patch(
   StatusChange,
   Defaults(StatusChange),
   {
      IDRef:ThisItem.ID,
      ChangedBy:User().FullName,
      StatusTo:Self.Selected.Value,
      StatusDate:Now()
   }
)

To display, you would need a gallery with the Items (you need to get the ID from somewhere)

Filter(
   StatusChange,
   IDRef=YourCurrentRecordID
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @marcoagastelum1 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.