Answered

Find the latest modified date from a specific file (within 6 days)

Like (0) Share

Report

Posted on 12 Jun 2024 18:20:53 by Nutela

I need to find the specific file latest modified witin 6 days. I have over 20 files named the same but in different folders each time.
And finding the latest one is necessary.
But i always get an error.

Could i please get help on how to write the expression ?

Im Sure its gonna be a simple solution

lessOrEquals(item()?['Modified'], 5)

Unable to process template language expressions in action 'Get_Files_(Properties_only)' inputs at line '0' and column '0': 'The template language function 'lessOrEquals' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'.

I have the same question (0)

All responses (2)

Answers (1)

Nutela 10 on 13 Jun 2024 at 16:58:37

Like (0)

Report

Re: Find the latest modified date from a specific file (within 6 days)

this is great !!

Thank you !!

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on 13 Jun 2024 at 01:29:06

Like (0)

Report
Re: Find the latest modified date from a specific file (within 6 days)

Hi @Nutela ,

Please check this test:

We first get the files from the past six days and sort them in descending order according to the modified column. Then take the top one to get the most recently modified files.

addDays(utcNow('yyyy-MM-dd'),-6)

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No