Answered

Retrieving Power Apps Modified Date

(1) Share

Report

Posted on by Phineas

4,866 Super User 2025 Season 1

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:

Using Apps Using Formulas

All responses (6)

Answers (1)

CA1105 469 on at

Like (0)

Report

Retrieving Power Apps Modified Date

Following..
Verified answer

Phineas 4,866 Super User 2025 Season 1 on at

Like (0)

Report

Retrieving Power Apps Modified Date

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

)
Phineas 4,866 Super User 2025 Season 1 on at

Like (0)

Report

Retrieving Power Apps Modified Date

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...
ronaldwalcott 3,810 on at

Like (0)

Report

Retrieving Power Apps Modified Date

Look in the table for the correct name.
Phineas 4,866 Super User 2025 Season 1 on at

Like (0)

Report

Retrieving Power Apps Modified Date

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

);
Suggested answer

CU25060357-0 35 on at

Like (0)

Report

Retrieving Power Apps Modified Date

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")