May 12 2021 06:29 AM
Hi,
My HR department have created a MS Form with Circa 40 questions however there are a lot of branches so only 5 or 6 responses are required to complete the form. So, I can't simply add every single possible answer on the approval I need to only send to the responder's line manager ones which were answered
I used this attach-microsoft-forms-response-in-email to get started but as a lot of response show that ALL answers inc blank should be included
I am open to all suggestions
Kindest Regards
Simon Richardson
May 12 2021 07:27 AM - edited May 12 2021 07:28 AM
@Simon Richardson it would in theory be possible with a mass of conditions - at least 40 - to check whether the question had an answer or was blank and then append the answer to one of 40 variables. Life is too short for that sort of complexity. So in the email include all the questions but if they haven't answered answered a question it will just be blank. No problem, the recipients will understand that and it will save you a truckload of work and a flow with a huge propensity to fail. Don't give in to HR just because they've asked for something!
Rob
Los Gallardos
Microsoft Power Automate Community Super User
May 13 2021 04:21 AM
May 13 2021 11:52 AM