Have you ever tried to get the version number of your app developed in PowerApps to display in your app?
This version number helps you check that your user is running the right version of your app.
With the following expression you can get the version number of your existing app.
In my case my app is call version and the following expression is used to get the number:
CountRows(PowerAppsforAppMakers.GetAppVersions(First(Filter(PowerAppsforAppMakers.GetApps().value,properties.displayName = "version")).name).value)
!Note! The PowerAppsforAppMakers connector was recently renamed and the following code is th the corrected version of the code:
CountRows(PowerAppsforMakers.GetAppVersions(First(Filter(PowerAppsforMakers.GetApps().value,properties.displayName = "version")).name).value)
This doesn’t work as I applied the line you gave above in a label… “PowerAppsforAppMakers” doesn’t exist. Can you give me some help?
You will need to add a connection to the Power Apps for App Makers connection. If you try to add a connection and search for Makers then you should find it.
Thank you for the fast response. I was able to find the App Makers connection and add it. However, the name has changed from “PowerAppsforAppMakers” to “PowerAppsforMakers”. After applying that change, your function validates with no errors. However, I get nothing for the countrows function. Any further ideas?
Hi Brad.
Looking at the total expression, I would start to split this up and use labels and galleries to display part of the expression. Or withihn the overall expression you can select parts of it . PowerApps will show you a preview of the data.
So where the full expression is:
CountRows(PowerAppsforAppMakers.GetAppVersions(First(Filter(PowerAppsforAppMakers.GetApps().value,properties.displayName = “version”)).name).value)
You could try and check the value of
Filter(PowerAppsforAppMakers.GetApps().value,properties.displayName = “version”)
and then
First(Filter(PowerAppsforAppMakers.GetApps().value,properties.displayName = “version”)).name
Hi Pieter, Thank you again for your quick response!
So for simplicity, I put this line in the App::OnStart method:
ClearCollect(GetApps, PowerAppsforMakers.GetApps().value)
This runs fine and gives me 5 columns (Id, name, properties, tags, type) when I look at my collections. Unfortunately, I get no rows.
I feel like I am missing something basic for this not to work. Any more suggestions?
Thank you,
Brad
Maybe a silly question, but has your app been published?
Not a silly question. Yes, it has been published. When I look at the details of my app and click the Versions tab, I am up to Version 48.
Hi Brad,
I just tested the code again ( I updated the code to use the new Connector name in the post) and for me I’m still getting a single number returned.
It appears PowerAppsForMakers.GetApps() does not get apps constructed from a SharePoint list form (i.e. [SharePoint list view] > Power Apps > Customize forms). Note that what Pieter shares above is a count of the number of versions for an app. This count should match the latest version number given in the version history because the numbers are re-calculated when a prior version is deleted. The real “version” number given by PowerAppsForMakers can be found with the following:
First(Filter(PowerAppsforMakers.GetApps().value, properties.displayName = “[name of your app]”)).properties.appVersion
Note that this doesn’t return a version number, but a version date instead. Also note the slight difference from Pieter’s guidance where he said to use “properties.displayName = ‘version'”. That “version” was placeholder text that needs to be updated per the name of the app being queried.
Thanks Paul
While this code from Paul correctly returns the publishing date of the last version, it appears to do this regardless of the version of the running app. So it doesn’t seem suitable for the use case in the original post – that of checking which version the user is currently running.
(This code could come in handy, though – if the publishing date of the currently running version could be compared with the date of the last released version, it should be possible to create an ‘update needed’ alert to the user.)
This is great. If we need to extract the latest published version, how would we do it? Can you guide on that?
You can actually use, PowerAppsforAppMakers.GetAppVersions(“App ID”) to extract all versions of your app. It will also include the status like published.
Good day Pieter,
I noticed something weird when applying this to my app.
I am using exactly the same syntax like yours, only use it to set variable called varVersion.
Set(varVersion, CountRows(PowerAppsforMakers.GetAppVersions(First(Filter(PowerAppsforMakers.GetApps().value,properties.displayName = “My App Name”)).name).value))
I get the number, but it only maxed up to 150.
My real version was around 600 something.
Any idea why would this happened?
It looks like the AppVersions might have a limit of 150 item.
I have been using this code for over a year and it stopped working this morning. It shows the date as 6/11/2021 11:01am but I have published multiple times and it is not updating. When I hover over the code, it says “invalid date”. Did anything change in the core of power apps to mess up the coding? I haven’t touched the code and it is messed up in all of my apps – i opened, updated and save/publish but the date/time isn’t updating.
(First(Filter(PowerAppsforMakers.GetApps().value,properties.displayName = “MyAppName”)).properties.appVersion)
I managed to get the version date of the last published version into my application (sorry, german version…):
Set (
MyVersions;
PowerAppsfürEntwickler.GetAppVersions(“xxxxx-xxxxxxxx-yyyyyyyy-yyyyyyy”)
);;
Set (PublishedVersion; “Version: ” & First(Filter(MyVersions.value.properties;properties.lifeCycleId = “Published”)).properties.appVersion
So I can use the global variable PublishedVersion everywhere in my PowerApp. But from my point of view this implementation by Microsoft is worthless, because in this way it shows the version number of the latest version on the server, but not the version number of the PowerApp, that might come out of the browser cache in the current browser session. And this is what I need to know: Does the user work with the latest published version, or with a former cashed version? The variable always shows the latest version an not the currently into the browser loaded version 🙁 …
I’ve created an idea fro this:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Version-of-app-available-in-App-object/idi-p/1205654#M34150
@Harald
I see a possible error in your code:
Set (PublishedVersion; “Version: ” & First(Filter(MyVersions.value.properties;properties.lifeCycleId = “Published”)).properties.appVersion
should be:
Set (PublishedVersion; “Version: ” & First(Filter(MyVersions.properties;properties.lifeCycleId = “Published”)).properties.appVersion
There is no MyVersions.value in my opinion. Correct?
I have been using this feature for over a year and today none of my apps are updating the version date. I created a new label, added the code again to it by typing it all out and it is not showing the correct date. All of my apps show last Friday even if i did not publish the app last friday. Any ideas on troubleshooting? I noticed because I published an app multiple times and the date is still 10/1. Did microsoft update something?
Hi Marie, I just tried this out and it still works for me.
The main problem I am facing is that the throttling limit on the api is 100 calls every 60 seconds, so any versions above 100 are not displayed. A real annoyance: perhaps Microsoft never expected that an app would ever have more than 100 versions which is a bit short-sighted of them!
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hi Pieter veenstra,
I have app versions of more than 1700 in prod and i am facing issue bcoz it has a limit of 100 rows .
Can u please help me in this issue.It would be helpful in my project.
Thanks in advance
I would consider just manually type a version number in a label
I have entered the code in onstart property and these working fine till 100 version i am getting popup but if the version is more than 100 due to delegation the popup is being visible for latest version as well
One error with the logic on this – it’s showing the count of total SAVED versions, not published versions. So if you have a revision that you’re working on but haven’t published yet, it’ll still count towards the total in the published app.
You’ll want to include a filter to only include published versions:
CountRows(Filter(PowerAppsforMakers.GetAppVersions(First(Filter(PowerAppsforMakers.GetApps().value,properties.displayName = “Your App Name”)).name).value, properties.lifeCycleId = “Published”))
Personally ??I started to go back to just putting a label inside my app that displays a version number text that is manually updated. That ways I can at least see which version is in Dev, Test and Production.