Answered

Filter query to get files from today only

(2) Share

Report

Posted on by Patrick_Perea

Hello,

I wrote a PAD flow that takes files from a SharePoint library and downloads it to my local computer. That goes through with no issue, but I am trying to update the flow to only download the files that were uploaded today. I saw a filter query but getting error of bad request. I tried this in the step " formatDateTime(items('Foreach')?['createdDateTime'], 'yyyy-MM-dd') eq formatDateTime(utcNow(), 'yyyy-MM-dd') "

Categories:

Power Automate Desktop

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hey @Patrick_Perea

Can you please share the workflow ?

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helped you, please give it a Thumbs up 👍 and Mark it as a Solution ✔️.
This motivates me to solve more problems.

Thanks,
Sayan Patra
RPA Developer

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like (2)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (2)

Report
Copy link

Link copied!
@Patrick_Perea

Please find the below screenshot to apply filter in SharePoint file actions

Created ge '2024-07-09T00:00:00.0000000Z' and Created lt '2024-07-10T00:00:00.0000000Z'

In filter query syntax, ge means "greater than or equals to" and lt means "less than"

Thanks,
Deenuji Loganathan 👩‍💻
Power Automate Desktop Community Champion 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like (1)

Report
Copy link

Link copied!

Since this is going to be used from here on out can I remove the date with utcNow()

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like (1)

Report
Copy link

Link copied!

Thank you for the code but that wont work, when the user uploads a new file tomorrow

Was this reply helpful? Yes No
Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hey @Patrick_Perea

Try the below expression to get the file

Created ge '2024-07-10T00:00:00Z'
This expression retrieves items created on or after July 11, 2024 (in UTC time).

------------------------------------------------------------------------------------------------------------------------------
If my suggestion helped you, please give it a Thumbs up 👍 and and Mark it as a Solution ✔️.
This motivates me to solve more problems.
Thanks,
Sayan Patra
RPA Developer

Was this reply helpful? Yes No
Patrick_Perea 41 on at

Like (1)

Report
Copy link

Link copied!

That would not work this is a flow used multiple days and that script would only work for today.

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Moderator on at

Like (3)

Report
Copy link

Link copied!
@Patrick_Perea

You make it dynamic this logic using below actions:
Filter applied for SharePoint get files action with two variables:

Code (Copy and paste the below code into your power automate desktop):
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''yyyy-MM-dd''' Result=> FormattedDateTime SET FromDate TO $'''%FormattedDateTime%T00:00:00.0000000Z''' SET ToDate TO $'''%FormattedDateTime%T23:59:59.9999999Z'''

Thanks,
Deenuji Loganathan 👩‍💻
Power Automate Desktop Community Champion 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Just to add to what @Deenuji suggested (as their suggestion is correct) - the reason you need extra actions is because utcNow() and formatDateTime() are expressions that work in cloud flows, but not desktop flows. We don't have those expressions in PAD (except when you enable Power Fx, but that changes the syntax everywhere), and we need to use dedicated actions to perform those operations, such as Get current date time and Convert date time to text.

Was this reply helpful? Yes No