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

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
Super User

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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,250)