Need to show column values of Sharepoint list item before update in Power App.

[RiyaKaul]

I have a scenario where on editing a ticket, I am patching those updated values to sharepoint list where for that particular ticket the column values are updated. Now in powerapps I need to show that before update what was the value of a column and what is its new value. How can I retrieve those previous values of only the columns that have been updated and show them in powerapps?

Thanks in advance. 

[WarrenBelz · Accepted solution]

Hi @RiyaKaul ,

One way would would be to set a Variable to the value of the current record in the List before saving.

UpdateContext(
   {
      varRecord:
      Lookup(
         ListName,
         ID=ThisItem.ID
      )
   }
);
SubmitForm(FormName)

The previous values would then be

varRecord.FieldName

on each of the fields.

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 @RiyaKaul ,

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.

[RiyaKaul]

Thank you so much. It worked for me.