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

MS Forms survey response details to excel

So, I am working on automation tracking for another department at my company. The purpose of it is to collect names for a survey that will be sent out to the specified/requested employees to fill out at a later date. They have a MS Forms survey where they are collecting the names for this future survey, 5 are required but the responder can provide up to 25 total names. The department needs the first/last name and the email of each employee in the responses put into an excel spreadsheet.

 

I currently have an automated flow that will check each answer in a response to see if it can pull an O365 profile from the provided name, then validates the domain in the email(s) associated with the profile, then adds them to the excel spreadsheet if all checks out. It works, but after running the flow a few times the excel actions break with the 429 error and only way I've been able to fix it is to delete the action and redo it. Obviously this is inefficient, so I'm trying to find ways that may help work around or minimize this issue.

 

Has anyone found a better work around than to redo each broken excel action item? Is it possible to create more than one row in excel in a single step using something like functions? Is there a more efficient way to automate this than what I'm doing? I've included a screen shot of part of the flow below to provide a visual example of what it's doing right now.

 

Screenshot 2021-11-05 125601 (2).png

 

Expressions used are;

empty(outputs('P6_Search')?['body/value'])

endsWith(items('Rater_-_P6')?['Mail'], 'redacted')
0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,837)