Thanks for this video Andrew! I’ve been working on creating an asset version history feature on my Power App, which contains a SharePoint list as my data source. I was wondering if you had any insight on parsing the JSON back into the Power App and potentially formatting it so it says something along the lines of this: 12/11/2024 at 14:00 Status was changed from “Active” to “Faulty” Status in this case is one of my choice columns. Cheers
Interesting, so every time someone changes a choice field and saves. It then saves the change to a separate data source, which is a SharePoint list? So do you have 2 data sources or 2 different lists? 1 for the assets, and a separate 1 for the asset version history?
@@andrewhess123 At the moment, I have one data source with all my assets (the SharePoint list). The changes are currently saving to a collection, using the Collect function, which I’ve named ‘colAllItems’. This is to test if it stores the data correctly. I was thinking about using a SharePoint list to store the changes, which you’ve mentioned, instead of a collection, but my main focus is to be able to show the changes between each version of the item in a user friendly format. Basically, I need to compare the outputs of each version of the same item and only show the difference in a text label or something that the user can read. I have a unique barcode column which can track the item between two lists rather than using ID if needed. I’ve tried getting SharePoint’s built-in version history to appear in Power Apps, but I’ve had no luck either, and there aren’t a lot of tutorials out there.
Thank you for this. Could you possibly make a video on how to export to excel? using the new flow?
There have been a few requests using Excel. So I should make one in the future.
Thanks for this video Andrew! I’ve been working on creating an asset version history feature on my Power App, which contains a SharePoint list as my data source.
I was wondering if you had any insight on parsing the JSON back into the Power App and potentially formatting it so it says something along the lines of this:
12/11/2024 at 14:00
Status was changed from “Active” to “Faulty”
Status in this case is one of my choice columns.
Cheers
Interesting, so every time someone changes a choice field and saves. It then saves the change to a separate data source, which is a SharePoint list? So do you have 2 data sources or 2 different lists? 1 for the assets, and a separate 1 for the asset version history?
@@andrewhess123 At the moment, I have one data source with all my assets (the SharePoint list). The changes are currently saving to a collection, using the Collect function, which I’ve named ‘colAllItems’. This is to test if it stores the data correctly.
I was thinking about using a SharePoint list to store the changes, which you’ve mentioned, instead of a collection, but my main focus is to be able to show the changes between each version of the item in a user friendly format.
Basically, I need to compare the outputs of each version of the same item and only show the difference in a text label or something that the user can read.
I have a unique barcode column which can track the item between two lists rather than using ID if needed.
I’ve tried getting SharePoint’s built-in version history to appear in Power Apps, but I’ve had no luck either, and there aren’t a lot of tutorials out there.
I wasn't sure if I should of deleted the first 3:21 because it wasn't necessary, but left it in there anyways 😀 Chapters are there just in case!