web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate filter query getItems ...

Power Automate

Unanswered

filter query getItems by column modified = today()

(1) Share

Report

Report

Posted on by Greg68

138

Hello,

I'm using a flow in powerapps, and it works fine but I need to filter bu columns changed or modified Today()

my current Filter Query for getItems:

(Course_and_Cohort eq '@{triggerBody()['Getitems_FilterQuery']}') and (FinalGrade ne '0')

How is it possible to do this, please?

Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

grantjenkins 11,063 Moderator on at

Like (1)

Report
You should be able to add the following to your existing query to get what you're looking for.

Modified ge '@{startOfDay(utcNow())}' and Modified lt '@{startOfDay(addDays(utcNow(), 1))}'

Was this reply helpful? Yes No
Greg68 138 on at

Like (0)

Report

That's great, but what if I want to filter by the modified Column.
I have a Column named "FinalGrade" and when a grade is updated in this column for this modified row or entry, then the flow will filter out those modified or updated entries and email them, instead of emailing all the modified rows.

so can we filter by the modified column entry, instead of the modification of all the columns in SharePoint list?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

If your trigger is when an item is modified, then within your flow you can use Get changes for an item or a file (properties only) then check what specific columns have been changed. Not sure if that's exactly what you're looking for though.

Was this reply helpful? Yes No

Join the conversation