Hey @forbudt4u
you can get the SharePoint version history by making a SharePoint HTTP Rest API Call:
https://<tenantname>.sharepoint.com/sites/<sitename>/_api/web/lists/getbytitle('<listname>')/items(<ItemID>)/versions
So you would need to let the user maybe click on a button before accessing the app (like having a "Welcome Page" before your actual app to first trigger the Flow and afterwards changing the screen).
Your Flow could look like this:
In "PowerApps (V2)" you define a number input "ID" to get the correct item from the SharePoint list (maybe in Power Apps oder Power Automate doing a lookup for the correct item, we need the internal unique SharePoint list item ID). Next use the SharePoint - Send an HTTP request to SharePoint action:
Site Address: Your SharePoint Site Collection
Method: Get
URI: _api/web/lists/getbytitle('<InternalListName>')/items(@{triggerBody()['number']})/versions
The compose is used to show me the output using a formular:
outputs('Get_Version_History')?['body/d/results'][1]?['Created']
The [1] always makes sure to get the second item from the top (0=first item in an array; 1 = second item in an array...). Finally we can give a respond to Power Apps giving the LastLogin Timestamp:
In Power Apps on your Button - OnSelect you configure:
Set(varLastLogin,'PowerApps-GetSPVersion'.Run(2))
(I used a fixed value "2" for my ID in the list, you maybe need to make it dynamic).
Setting the value to a label:
varLastLogin.lastlogin
Best regards
Marvin
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
