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?
This video was very helpful but Can you create a video tutorial on this where you started from the start, I am using this as my guide to send for multiple responses but I’m having a hard time create excel in one drive It’s not linking to the excel I selected from one drive.
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?
@@PowerTechSpeck thank you! i am having another issue: can the answer posted into excel be overwritten? For example, in that send with option i am asking about status of a report. if the answer is pending (and it gets written to the excel via the trigger update row), it will trigger a reminder email in another flow and they will have the choice again to give an answer - in that case, teh answer needs to be overwritten in that table. is it feasable? if yes how? thanks so much for your precious help!
I want to send to 1000 people with send an email with options this flw will not work for this as concurrency control is upto 50 Please can you upload that video
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.'.'.
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
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.'.'.
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
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
This video was very helpful but Can you create a video tutorial on this where you started from the start, I am using this as my guide to send for multiple responses but I’m having a hard time create excel in one drive It’s not linking to the excel I selected from one drive.
Hi Jessa - Make sure that your excel has table structure in it. Create a table in excel stored in one drive, you should be able to refer it
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!
Use Timeout condition
@@PowerTechSpeck thank you! i am having another issue: can the answer posted into excel be overwritten? For example, in that send with option i am asking about status of a report. if the answer is pending (and it gets written to the excel via the trigger update row), it will trigger a reminder email in another flow and they will have the choice again to give an answer - in that case, teh answer needs to be overwritten in that table. is it feasable? if yes how? thanks so much for your precious help!
I want to send to 1000 people with send an email with options this flw will not work for this as concurrency control is upto 50
Please can you upload that video
I will queue that request. Thanks
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
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.
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.
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
Not at the moment. I will try to author video once my backlog eases a bit. Thanks.
so difficult. thanks but u gotta improve on ur teaching skills.
Ok. Thanks