Unanswered

Retrieving Power Apps Modified Date

(1) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I am using the following to pull in the 'current' app version of my Power App into the main screen of the app.

In the history there is also a 'Modified' date column. Is it possible to use a similar formula to pull in the
'Modified' date so I can display it in the 'Published' label on my screen?

Excerpt of 'App version history' -

Formula used at 'OnStart' to retrieve app version number -

Set(varAppVersion,
CountRows(PowerAppsforMakers.GetAppVersions(First(
    Filter(
        (PowerAppsforMakers.GetApps()).value,
        properties.displayName = "Invoice_App"
)
).name).value));

Section of App main screen -

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

CU25060357-0 37 on at

Like (0)

Report

The modified date is within GetAppVersions as well.

Set(
varAppPublishedDate,
First(
Sort(
PowerAppsforMakers.GetAppVersions(
First(
Filter(
PowerAppsforMakers.GetApps().value,
properties.displayName = "Invoice_App"
)
).name
).value,
modifiedTime,
Descending
)
).modifiedTime
);

And then for your label:

"Published on " & Text(varAppPublishedDate, "[$-en-US]mmmm d, yyyy")

or if you want the time included.

"Published on " & Text(varAppPublishedDate, "[$-en-US]mmmm d, yyyy 'at' h:mm AM/PM")

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Power Apps 'OnStart' didn't like the formula.

Got an error.

Error message is -
"Name isn't valid. 'modifiedTime' isn't recognized."

The only options to choose from for 'value' are -
id
name

properties
tags
ThisRecord
type

The column name in the version section of the app is 'Modified'. However 'Modified' is also not available for
'value' in the formula.

The formula used in 'OnStart' to return app details -

Set(

varAppPublishedDate,

First(

Sort(

PowerAppsforMakers.GetAppVersions(

First(

Filter(

PowerAppsforMakers.GetApps().value,

properties.displayName = "Invoice_App"

)

).name

).value,

modifiedTime,

SortOrder.Descending

)

).modifiedTime

);

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Look in the table for the correct name.

Was this reply helpful? Yes No
Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

I don't understand.

You say, "Look in the table for the correct name."

What table?

In the varAppVersion formula the only options to choose from that I am given are:
id
name

properties

tags

ThisRecord

type

...and the .name).value) is what is returning the Version number.

Set(varAppVersion,

CountRows(PowerAppsforMakers.GetAppVersions(First(

Filter(

(PowerAppsforMakers.GetApps()).value,

properties.displayName = "Invoices_App"

)

).name).value));

When I get to the following spot, in my varPublishDateTime formula, once I enter the period (.) I get a list
of items including 'lastModifiedTime'.

However, I don't believe this is the place to acquire this meta data, as I haven't identified the specific app
as yet.

How am I to proceed?

'OnStart' Publish DateTime formula -

Set(varPublishDateTime,

First(
Sort(
PowerAppsforMakers.GetAppVersions(
First(
Filter(

PowerAppsforMakers.GetApps()).value,

properties.lastModifiedTime...

Was this reply helpful? Yes No
Verified answer

Phineas 5,325 Super User 2025 Season 2 on at

Like (0)

Report

Found my answer.

Thank you all for your patience.

'OnStart' formula to get current App Version and Date/Time published -

Set(

appVersion,

CountRows(

PowerAppsforMakers.GetAppVersions(

LookUp(

PowerAppsforMakers.GetApps().value,

properties.displayName = "App Name Here",

name

)

).value

)

);

Set(

appTimeStamp,

PowerAppsforMakers.GetApp(

LookUp(

PowerAppsforMakers.GetApps().value,

properties.displayName = "App Name Here",

name

)

).properties.appVersion

)

Was this reply helpful? Yes No
CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report

Following..

Was this reply helpful? Yes No