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.