cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AislingFaulkner
Helper II
Helper II

Getting ms form responses weekly

Hey guys,

 

I have a MS Form that users will fill out every week.  I use the response details to see who hasn't submitted it in the past week and send those people and email. 

 

My question is, how to I grab the responses from the past week only? At the moment I'm just using the excel sheet, and filtering the date in desc order and grabbing responses in the last 7 days, which is frustrating as there's a lot of responses.

 

I've tried to filter the ODATA, use filter array, and use a condition

 

 

addDays(utcnow('yyyy-MM-ddTHH:mm:ssZ'),-7)

 

 

But nothing is working

 

Any help at all is appreciated 

1 REPLY 1
Expiscornovus
Super User II
Super User II

Hi @AislingFaulkner,

 

As far as I am aware you can only collect those responses directly from the Excel. There is no API or action to query all the responses.

 

Unless you are already writing the response to another destination, like for instance a SharePoint list. If that's the case, can you share more details of your flow?

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,272)