cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Filter Query of Sharepoint rows between dates (dates specified in column)

Hi All,

 

I'm trying to automate sending out an excel sheet of rows filtered by a date column.

 

I want to include any row that has a value of the last 7 days.

Here's what I've tried:

 

otflowscreenshot.PNG

 

But i keep getting this error :

 

The expression "2020-55-30" is not valid.
clientRequestId: 3e7e28fe-b34a-4ec3-9cc9-80ba03e5bf8a
serviceRequestId: 3e7e28fe-b34a-4ec3-9cc9-80ba03e5bf8a

 

 

Any help to filter the values by the last 7 days would be really helpful!

otsharepoint.PNG

Thanks!

 

 

2 REPLIES 2
Highlighted
Super User
Super User

Re: Filter Query of Sharepoint rows between dates (dates specified in column)

This sounds like a Power Automate question rather than a PowerApps question. You are welcome to post it here but I suggest you post this in the Power Automate Community instead. You’ll get a quicker and better response over there

Link to Power Automate Community
https://powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Frequent Visitor

Re: Filter Query of Sharepoint rows between dates (dates specified in column)

My Bad, I was switching back and forth between the two and posted here by mistake.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,022)