Get version number or release date of the app

[Anonymous]

Is there any way to get the current version number or release date of your app using a formula?  It would be really good to get metadata about the app using formulae, similar to the User object.

Thanks

[v-yamao-msft]

Hi xx,

Currently, we could get the version number or release date in web.powerapps.com, on an app tile, click the ellipsis (. . .), and then click Details.

It seems that there is no function can be used to get the version number or release date.

Please consider to create an idea at PowerApps Ideas Forum, I will collect and report it from my side.
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,
Mabel Mao

[Anonymous]

Idea added:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Get-app-metadata-from-within-the-app/idi-p/47153

[Lachlan_w · Accepted solution]

Hello,

You can now do most of this using the PowerApps for App Makers connection.

I've written a blog outling how to get the version number into you app. You can find that here.

While researching the topic I saw a lot of the metadata you are after was included in the dataset retrived when you run the get versions function.

I hope that helps.

Cheers,

Lachlan

[lachlan_hughes]

Building on the solution in the blog above I found a nice neat little way of getting a "v6.7" label in my app.

I just built all the original functions in the video linked above into the one button:

ClearCollect(myAppVersions,PowerAppsforAppMakers.GetAppVersions(appID));
ClearCollect(myAppVersionsv2,Ungroup(myAppVersions, "value"));
ClearCollect(myAppVersionsv3, Filter(myAppVersionsv2, properties.lifeCycleId="Published"));

Then I setup a new label with the text:

"v" &
//count number of rows in myAppVersionv3
CountRows(myAppVersionsv3) &
"." &
//Need to remove the "T" and "Z" from the version name (which is really just a time stamp)
//Count the number of rows in myAppVersionv2, where the name is greater (aka newer) than the last published version
CountIf(myAppVersionsv2, Value(Substitute(Substitute(name, "T", ""), "Z", "")) > Value(Substitute(Substitute(First(myAppVersionsv3).name, "T", ""), "Z", "")))

This label counts the number of published versions as the leading version number

It then counts the number of saved, unpublished (aka "draft") versions since the last published version as the trailing number

Thanks,

Lachy

[vsslasd]

Where is the video ?

[lachlan_hughes]

---

@Lachlan_w wrote:

I've written a blog outling how to get the version number into you app. You can find that here.

[SachinG31]

Hello @lachlan_hughes , i have followed your video step by step. i have around 170 version of update in my app

 i am trying to setup the app version , i followed all the steps but in my case result is not correct.

This is what i am writing on button on select

Set(appnumber,GUID("****************"))
ClearCollect(myAppVersion,PowerAppsforMakers.GetAppVersions(appnumber))
ClearCollect(myAppVersionUngropped,Ungroup(myAppVersion,"value"))
Set(PublishedVersion,LookUp(myAppVersionUngropped,properties.lifeCycleId="Published").properties.appVersion);
ClearCollect(MyPublishedVersion,Filter(myAppVersionUngropped,properties.appVersion<=PublishedVersion));

and on display html label 

"<b>Current Version: </b>"&CountRows(MyPublishedVersion)

 Where is the mistake, i have tried same formula for another App having 30 version for that it gives  correct result.Just now i tried for one more app and it gives correct result , for version less than100, it works but for after it does not , i guess , BUT WHY???

[SnowFlake]

@SachinG31  I hit the same issue,
It may be an API throttling limit: Power Apps for Makers - Connectors | Microsoft Docs

Name Calls Renewal Period

API calls per connection

100

60 seconds

My App is currently on version 212 and I only get 100 results. 

[rbunge]

Appears 100 is the max it returns -- even when Page Size (flow) or $top (canvas app) parameters are used.

I had seen the API call limitation, but isn't it just one call that's made to get the table of versions? Otherwise seems you'd never be able to get more than 100, since there is a 60-second renewal period.

Hopefully someone from -msft will scan this thread and reply. I've had to stop using the number of the version, and instead use the published date, as that appears to correctly display the most recent published date.

Would also be nice if in the metadata that comes over we had the actual version number as it's displayed in the Versions tab, as opposed to having to CountRows to arrive at the version number.