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

(0) Share

Report

Posted on by DarylMcC

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:

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!

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DarylMcC 20 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No