How to use Send Email with Options with Multiple Responses in Microsoft Power Automate Cloud Flow?
Вставка
- Опубліковано 15 вер 2024
- This video demonstrates the process to collect multiple email response from an end user in a parallel way (rather than the traditional way). The mutiple response received from users are executed in a parallel fashion and the responses are collated and stored in an Excel file stored in Microsoft One Drive for Business.
Girish Uppal provides a workaround solution to the 'Send Email with Options' default control available within Power Automate to collect multiple responses.
#microsoft #powerplatform #powerautomate #cloudflow #onedrive #automation
✔️You can visit girishuppal.com (Girish Uppal) website to get more productivity tips.
✔️Please subscribe to @powertechspeck youtube channel / @powertechspeck to get more productivity tips and tutorial content from Girish Uppal
✔️You can view my Linkedin Profile at: / girishuppal
✔️You can view the badges earned by me at: www.credly.com...
Thank you for this video and for all your content. I learned a lot when I watch your videos. But I have one question in regards to this video. What is it that prevents the workflow from being canceled when the first user submits their response?
Concurrency
Thank you, I learned a lot on your videos !! 😊
just a question, degree of parallelism max value is 50. so does it mean once exceed 50 the loop will terminate or stop ?
Hi Anime, Degree of Parallelism indicates how your operations will be executed in a parallel thread. It cannot exceed 50 as per your question. Looping will continue and will not terminate unless it encounters logically or operational errors.
So is it by changing the concurrency that prevent the flow from canceling after the first response or is it the apply to each loop that prevents the workflow from canceling after the first response?
Enabling concurrency does the trick.
If someone does not respond to the mail, can we get the data into excel file?
i have the same question - did u ever find out? thanks for sharing!
What if one person doesn't respond? I don't see my flow continue unless all respond.
I listen to the video again and heard you mention this as an issues. Is there a work around or do you have a flow that can send individually but add to the same file
You can use Microsoft forms connector (if you want individual responses)
You can put a condition in flow, that after x days flow should terminate on its own.
@@PowerTechSpeck Do you have any examples
Good day,
Can you please assist, while adding the Add row in table am getting below error , can you help me out.
"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Add_a_row_into_a_table' at line '1 and column '8151' is invalid. Action 'SendEmailOptions' must be a parent 'foreach' scope of action 'Add_a_row_into_a_table' to be referenced by 'repeatItems' or 'items' functions"
Your assistance will be highly appreciated.
Hi Bertus, Looks like your Excel table is not well formed with a Table schema and hence you are getting this error. Please fix up Excel and re-run this flow.
In case you are not able to resolve then I will be happy to do a screen share session. Connect me through LinkedIn
I have uploaded the code and screenshot in Git Hub repo github.com/girishuppal/Power-Automate-Flows . Please have a look in to it.
I got an issue at 12:08 about "Add a row into table". When I enter Custom value, there is no "Row" item to add "Current item". Could you help on this? Thank you. @PowerTechSpeck
You need to format your Excel content in to a table. Open excel, then add your table content. Select the table content (Insert > Table) option so that the table is marked as Table and then you can then refer that table in Power Automate
@@PowerTechSpeck Thanks. I format "myExcel.xlsx" by your method. "row" item is appear. But after all the procedure write as yours. I found issue the same as others user( Bertus) metioned. Could you help again? Thank you.
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Add_a_row_into_a_table' at line '1 and column '5149' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Add_a_row_into_a_table' to be referenced by 'repeatItems' or 'items' functions.'.'.
@@PowerTechSpeck I can fill the "Current item" in Row after table content marked. But I still find the following issue when I save the file. Could you help on this? Thanks.
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Add_a_row_into_a_table' at line '1 and column '5174' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Add_a_row_into_a_table' to be referenced by 'repeatItems' or 'items' functions.'.'.
The item should be looped under the iteration context. Use foreach loop in the parent and then iterate through the content.
Also it uses Excel online for business connector and not just Excel connector
Hi Sir,
While adding the Add row in table am getting below error , can you help me out.
"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Add_a_row_into_a_table' at line '1 and column '6576' is invalid. Action
'Apply_to_each' must be a parent 'foreach' scope of action 'Add_a_row_into_a_table' to be referenced by 'repeatltems' or 'items' functions.'.'.
Hello @yashwanth5791 - I replied using LinkedIn. Hope your queries are resolved.
Hi I got the same problem. Can I get the result too please? Thanks
Hi Felix, Please fix up your excel table template. Happy to connect through LinkedIn.
I have uploaded the code and screenshot in Git Hub repo github.com/girishuppal/Power-Automate-Flows . Please have a look in to it.
@@Fkenfbzsna I have uploaded the code and screenshot in Git Hub repo github.com/girishuppal/Power-Automate-Flows . Please have a look in to it.
so difficult. thanks but u gotta improve on ur teaching skills.
Ok. Thanks