Last Data modified

[rehankazi]

I need to display the last data modified date and time on my PA screen. How can I do it? I am using the text box but I am not aware of the formula to use for displaying the time and date when the excel file on my Onedrive was updated.

[BCLS776]

You could do this through a Power Automate flow that responds to your app:

Hope that helps,

Bryan

[rehankazi]

Thanks Bryan

But I dont want to have flow added, is there any way to show on the PA screen when ever the source excel file was modified or updated?

My source excel file is on Onedrive, and whenever it is modified the date and time should show on the PA screen.

[Anonymous]

Hi @rehankazi , @BCLS776 is right: the metadata for the data source is not read by PowerApps when it comes in, and you only have the option of selecting the data columns themselves. If you don't want to use  a Flow to grab the metadata, the only other solution would be to add a hidden column to your Excel that records the last modified time on save. That way it will appear as a data column to be used in the PowerApp.

Hope that helps

Ralph

[v-bofeng-msft]

Hi @rehankazi :

I’m afraid the solution provided by @BCLS776  is already the best. If you don’t want to use Power Automate, the only way to do this is to call the Graph API.

https://graph.microsoft.com/v1.0/me/drive/root/search(q='FileName')

You need to use this API to create a custom connector, and then you can call it directly in PowerApps to get the last modification date of the file:

This video may help you build a custom connector.

How to connect Microsoft Graph API in PowerApps 

Best Regards,

Bof

[rehankazi]

Thank you @BCLS776  and @Anonymous  for the tips. 

[rehankazi]

@v-bofeng-msft Thanks for the advice, API permission wont work for me as i dont have admin permission. I will go with automate. I am getting stuck at the below step. Are there more steps to be added?

[BCLS776 · Accepted solution]

---

@rehankazi wrote:

@v-bofeng-msft Thanks for the advice, API permission wont work for me as i dont have admin permission. I will go with automate. I am getting stuck at the below step. Are there more steps to be added?

---

You've done what you need to do with the flow. Now, head back to PowerApps and connect your app to this flow in the OnSelect property of a button, for example. It will create a statement that looks like: MyFlowName.Run()

You might find it easiest to Set() the value of a variable to the return from the statement, for example:

Set(varFileInfo, MyFlowName.Run())

Bryan 

[Anonymous]

Hi All,

Having some trouble here.

I created the flow inside my powerapp app. The name of the flow is Flow_data_hora.

the flow is exactly how you show here, and the label in the text is resultado_data.

I then inserted a button to run this flow: Flow_data_hora.Run()

But I can't seem to display it in a label.

resultado_data is not recognized anywhere!

Thank you!