The For a selected row trigger is deprecated. I did the whole exercise but the flow is no longer appearing in the excel file either. So we cannot run it anymore
@RezaDorrani surely, "the For a selected row, complete a custom action" template is already deprecated and no longer works. As a workaround, one just needs to create a blank flow and add the For a selected row Excel online for business trigger. Then just follow the same steps as the video
Reza, thank you so much. I really appreciate you taking the time to make M 365 app tutorials beside Power Platform. For businesses, using these two components is so important.
Hello M.Reza, toujours un plaisir de regarder ta chaîne☺, avec les nouveautés sur PowerApps(Canvas) merci beaucoup tes vidéos sont d'une grande aide. A quand les vidéos sur le driven apps et tout ce qui va avec(les plugins, les web-ressources...)?? J'espére que tu comprends le français😅
Thanks so much! I have plans to cover model-driven apps, plugins and many other topics. Most requested topics are around canvas apps and hence the focus is there.
Another awesome video! This gave me a lot of ideas for how I can use this in my own job. Is there any way to trigger the flow with a button in the worksheet instead of having to open the Power Automate pane? Is it possible to customize the ribbon and add an icon in the ribbon to run the flow directly?
@@RezaDorrani thank you for the quick response! I guess opening the PA pane isn't that big of a deal, but being able to assign flows to a shape or button like a macro in the desktop version of Excel would allow users to create some great interactive dashboards in Excel online.
@dwang085 if there was a way to trigger the flow automatically when a cell value changed maybe you could have data validation in its own little table? Then write the flow to first evaluate the selected value when you pick something from the drop down list? This way it would only send the email if a certain value was selected. That might also allow the flow to reset the drop down list value back to a default ? Idk. Just an idea
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, Thanks to your tutorial, been using it for my daily process since March. Can you suggest an alternative template to manually trigger the flow since the For a selected row is already deprecated?
Hi Reza, thank you for posting, your content is great. I created a flow to get two tables from excel and send an email, it works great. I shared the flow for a run only user, they get an environment error in Excel and. We only have 1 environment. User has all correct permissions. can access excel and power automate the flow doesn't show up for them either. Thank you
Most welcome! I have not experienced the mentioned issue and hence not sure what is the fix for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
Hi Reza, Thanks a lot for this amazing new tutorial. It's not an old one but now this features is Deprecated ("For a selected row, complete a custom action (Deprecated)), do you think that we can continue to use it ? ot to do it in a different way ? Thanks
@@RezaDorrani each time i try to add the url my message is deleted so when i'am opening this template from power automate i have in the title For a selected row, complete a custom action (Deprecated)
@@RezaDorrani i've found why : if i'am looking "for a selected row" from template, i can only the deprecated one but if "Build an instant cloud flow", i find "For a selected row (excel online for business) and then everything is ok ! So for me, when i click on templates from excel, it's not working because i only found the other that is not working. Very strange, your flow is as instant cloud flow ?
Hi Reza, Thanks a lot for your videos on power apps/automate. I have learned lot from your videos. I have one request, if you could create one video on this topic or if you have already please let me know. I have 2 lists in sharepoint, 1. One for user hierarchy. 2. Another for data. Want to create an app, where logged in user can see all items assigned to him/her. Also, if a manager open that app he can see all items of his team members only.
Most welcome! I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Reza, amazing video as always, thanks: I have a quick question regarding a previous video tittle "Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email" There seems to be a limit of 1000 rows to pull into Excel using the power automate so could you please state if there is a workaround this? Appreciated
Hi Rezza, I question! Suppose we have an excel table and there is a power automate flow which adds columns dynamically into that table. Can we trigger that flow from that excel file and once it adds the columns then itwill also refresh/update the excel file????
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hello Reza, Can you please tell me how to add rows to Microsoft Entra ID (aaduser) table in dataverse through power automate? I have added to other look up columns like office, doctor, but i am not getting how to add this Microsoft Entra ID (aaduser) table column.
I have some question, please reply. 1. In reminder date, when the email arrived? is there any specific time? 2. Is this possible to add any company group mail to the mail list so that all the employees can get same mail? your video is very helpful. thanks.
Hello Reza, i have Microsoft 365 Business Basic subscription and this option is missing for me in excel online. Do i need to upgrade my Office 365 plans if yes to which version?
Hello, I have a problem with the number and date fields as soon as I try to run the flow I get the following message The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Integer.'. In your demo, I see that when you select yours fields it says formatted each time but I don't have this indication on my side (my excel file is stored in a sharepoint and not onedrive. An idea ? Thanks a lot
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hello Reza, If one of my inputs for the excel for a selected row trigger is a file. How to I get this to attach? I keep getting an error. I choose the name of the input for the name part of input from the dynamic content. For the content I choose the content bytes of the input. I keep getting the following error: "Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'The template language expression 'triggerBody()?['entity']['file_1']?['name']' cannot be evaluated because property 'file_1' doesn't exist, available properties"
I have not tried with file so not sure. I will recommend posting your issue on forums in case someone has done something similar powerusers.microsoft.com/
how to do it when I have in excel a file with dates and when the deadline approaches a specific date it automatically power automate reminds me about it , is it possible?
For that, you need to run the flow on a daily schedule, and query excel file to check if any dates match todays date and then send email. I do not have a specific videos reference on this though.
I have an excel in sharepoint which has Expiry date for certificates, on a recurrence check everyday, I want excel to send me an email notification if the date is expired. But for me, "For a selected row, complete a custom action" says (Deprecated) and it gives error while running the flow. please advise.
Is there a way to fix the regional number formate in excel, i have a shared sheet between people is my departemet And if i see numbers like 1.5 they see it as 1,5 Thanks
@@RezaDorrani i cannot see the flow in my excel when i create it in production environment my company doesn’t allow me to create in default pls help flow is not showing
@@shifamomin6547 Currently you cannot create a flow in non-default environment that you can call directly from excel. It's a limitation in product. I'm not aware of any workarounds.
how did it work for you with multiple selected rows? I tried on mine and received an error. The input body for trigger 'Selected_Row_-_Process_the_filtered_report' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.
Worked as shown in video. I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
I do not have a video reference on the scenario mentioned. I would recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@Gunasekaran8 It requires E3 license or above as per documentation and is not rolled out to all regions for excel client yet but should be in excel online if file is in Onedrive or SharePoint
How to send for multiple selected rows? For each column its working but for rondom selected columns its not working. Is there any other way to send to multiple rows at a time?
The For a selected row trigger is deprecated. I did the whole exercise but the flow is no longer appearing in the excel file either. So we cannot run it anymore
Can you share any link or reference that mentions about the deprecation?
Im not aware of anything that was announced, hence asking
@@RezaDorrani I sent you details via a PM in your LinkedIn.
@@MicrosoftAzureAI can you share the findings here for everyone?
@RezaDorrani surely, "the For a selected row, complete a custom action" template is already deprecated and no longer works. As a workaround, one just needs to create a blank flow and add the For a selected row Excel online for business trigger. Then just follow the same steps as the video
@@MicrosoftAzureAI same case. can you share your work around process?. thanks
Great Explanation, like from Brazil.
Many thanks!
Reza, thank you so much. I really appreciate you taking the time to make M 365 app tutorials beside Power Platform. For businesses, using these two components is so important.
Thanks so much. I hope these videos work and encourage me to make more on such topics.
Another cracking video. Thanks for sharing and will be extremely useful for most of the power users in my organisation.
Great to hear!
Brother the way you explain your content is truly amazing. So easy to follow and understand, with a consistent pace. Keep up the amazing work.
Awesome! Thank you!
amazing, each time I watch your videos I learn a ton of stuff
Happy to hear that!
Your video help me a lot sir. Thankyouu so so much. I hope u have a lots of luck 😇. Cant wait another video about Power Automate
Most welcome Fadhil
Hello M.Reza, toujours un plaisir de regarder ta chaîne☺, avec les nouveautés sur PowerApps(Canvas) merci beaucoup tes vidéos sont d'une grande aide. A quand les vidéos sur le driven apps et tout ce qui va avec(les plugins, les web-ressources...)?? J'espére que tu comprends le français😅
Thanks so much!
I have plans to cover model-driven apps, plugins and many other topics.
Most requested topics are around canvas apps and hence the focus is there.
This is really awesome!🎉😊
Thank you! Cheers!
Reza, This session Very Useful for us! Thank you!!
Glad to hear that!
Another awesome video! This gave me a lot of ideas for how I can use this in my own job. Is there any way to trigger the flow with a button in the worksheet instead of having to open the Power Automate pane? Is it possible to customize the ribbon and add an icon in the ribbon to run the flow directly?
Great!
Trigger from button or customize icon - Im not aware if thats an option. From what I read, No.
@@RezaDorrani thank you for the quick response! I guess opening the PA pane isn't that big of a deal, but being able to assign flows to a shape or button like a macro in the desktop version of Excel would allow users to create some great interactive dashboards in Excel online.
@@big1975E an area to explore
I would love a button too. My group uses a google sheet with scripts that trigger based on cell conditions which is pretty handy
@dwang085 if there was a way to trigger the flow automatically when a cell value changed maybe you could have data validation in its own little table? Then write the flow to first evaluate the selected value when you pick something from the drop down list? This way it would only send the email if a certain value was selected. That might also allow the flow to reset the drop down list value back to a default ? Idk. Just an idea
Nice one Reza!!
Thanks!
Great -
Best way to end the weekend.
🙏
As usual, contents are great!
Much appreciated!
This video came in handy. Than k you Reza
Most welcome
Good use case thanks Reaza!
Most welcome
Hi Reza,
Could you please do a video on how to create an envelop from template in Esign using powerautonate
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Very different but nice topic Reza.. thanks !!!
Glad you liked it!
Hi Reza,
Thanks to your tutorial, been using it for my daily process since March. Can you suggest an alternative template to manually trigger the flow since the For a selected row is already deprecated?
I am not aware of its depreciation and not sure of what alternatives are available
So Good as usual
Thanks
thanks my man.
Most welcome
Hi Reza, thank you for posting, your content is great. I created a flow to get two tables from excel and send an email, it works great. I shared the flow for a run only user, they get an environment error in Excel and. We only have 1 environment. User has all correct permissions. can access excel and power automate the flow doesn't show up for them either. Thank you
Most welcome!
I have not experienced the mentioned issue and hence not sure what is the fix for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
@@RezaDorrani Hi Reza, I gave the user owner access to the flow and that worked. Appreciate your time.
Looking good Reza!
Thanks
Hi Reza,
Thanks a lot for this amazing new tutorial.
It's not an old one but now this features is Deprecated ("For a selected row, complete a custom action (Deprecated)), do you think that we can continue to use it ? ot to do it in a different way ?
Thanks
Im not aware of any depreciation for this feature.
@@RezaDorrani each time i try to add the url my message is deleted so when i'am opening this template from power automate i have in the title
For a selected row, complete a custom action (Deprecated)
@@nicolasg1848 I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani i've found why : if i'am looking "for a selected row" from template, i can only the deprecated one but if "Build an instant cloud flow", i find "For a selected row (excel online for business) and then everything is ok !
So for me, when i click on templates from excel, it's not working because i only found the other that is not working.
Very strange, your flow is as instant cloud flow ?
@@nicolasg1848 yes, its an instant flow
Very good thx
Welcome
Hi Reza, Thanks a lot for your videos on power apps/automate. I have learned lot from your videos. I have one request, if you could create one video on this topic or if you have already please let me know.
I have 2 lists in sharepoint,
1. One for user hierarchy.
2. Another for data.
Want to create an app, where logged in user can see all items assigned to him/her. Also, if a manager open that app he can see all items of his team members only.
Most welcome!
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Very informative. ।thanks Reza
Amazing 🎉🎉🎉❤❤
Thanks so much
Is it possible to use Onedrive for the attachment instead of sharepoint? For the last section
Possible
Reza, amazing video as always, thanks:
I have a quick question regarding a previous video tittle "Power Automate Export to Excel | Dynamically create Table, Columns & Add Rows to Excel | Send Email"
There seems to be a limit of 1000 rows to pull into Excel using the power automate so could you please state if there is a workaround this? Appreciated
I believe there is a pagination setting in that action. Check documentation on it.
Hi Reza, can we move the flow to another environment and would it still be connected to the excel file and triggers from the new environment?
Currently, it only works from default environment
@@RezaDorrani Thanks for the confirmation
Hello Reza, I was wondering what is the limit on how many rows you can trigger at one time?
Limit will be on threshold on flow really. I have not tested its limits so not sure.
Hi Rezza, I question!
Suppose we have an excel table and there is a power automate flow which adds columns dynamically into that table.
Can we trigger that flow from that excel file and once it adds the columns then itwill also refresh/update the excel file????
Not sure about this scenario as this is not something I have tried.
Hi Reza, i have followed all your actions but the PDF attachment in the emails are blank? do i need to add something else.
The steps are as shown in video. Not sure why it would not be working for you.
Can you plz make one flow for action reminder on action due date
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Can you do tutorial on how to populate email to excel. Please? 😊
Currently not in my plans but if I get a lot more requests on this topic, then I would add it to my backlog
Hello Reza, Can you please tell me how to add rows to Microsoft Entra ID (aaduser) table in dataverse through power automate? I have added to other look up columns like office, doctor, but i am not getting how to add this Microsoft Entra ID (aaduser) table column.
Aad user table is a virtual table. You cannot add data to it.
I have some question, please reply.
1. In reminder date, when the email arrived? is there any specific time?
2. Is this possible to add any company group mail to the mail list so that all the employees can get same mail?
your video is very helpful. thanks.
1 - what time in video was this shown?
2 - You can do this in send an email action
Hello Reza, i have Microsoft 365 Business Basic subscription and this option is missing for me in excel online. Do i need to upgrade my Office 365 plans if yes to which version?
The template may no longer be available. But if you create a new flow and check in triggers, you will find the option
@@RezaDorrani thanks for quick answer. I mean the button "Automate Work" is missing in my online Excel File. I see only the Scripting option
@@dzhan84 Ohh! I’m not sure about that for the plan you mentioned
Hi Reza, could you please confirm which license is required for these connectors in power automate?
E3 and up
@@RezaDorrani thanks
Hello,
I have a problem with the number and date fields as soon as I try to run the flow I get the following message
The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Integer.'.
In your demo, I see that when you select yours fields it says formatted each time but I don't have this indication on my side (my excel file is stored in a sharepoint and not onedrive.
An idea ?
Thanks a lot
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
why I do not have the formatted columns? please guide
What time in video were formatted columns shown?
Hello Reza,
If one of my inputs for the excel for a selected row trigger is a file. How to I get this to attach? I keep getting an error. I choose the name of the input for the name part of input from the dynamic content. For the content I choose the content bytes of the input. I keep getting the following error: "Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'The template language expression 'triggerBody()?['entity']['file_1']?['name']' cannot be evaluated because property 'file_1' doesn't exist, available properties"
I have not tried with file so not sure. I will recommend posting your issue on forums in case someone has done something similar powerusers.microsoft.com/
how to do it when I have in excel a file with dates and when the deadline approaches a specific date it automatically power automate reminds me about it , is it possible?
For that, you need to run the flow on a daily schedule, and query excel file to check if any dates match todays date and then send email.
I do not have a specific videos reference on this though.
I have an excel in sharepoint which has Expiry date for certificates, on a recurrence check everyday, I want excel to send me an email notification if the date is expired. But for me, "For a selected row, complete a custom action" says (Deprecated) and it gives error while running the flow. please advise.
I am not sure of what options are there are some folks are sharing that its deprecated.
Is there a way to fix the regional number formate in excel, i have a shared sheet between people is my departemet
And if i see numbers like 1.5 they see it as 1,5
Thanks
Im not aware of the issue or its fix
Hi Reza I cannot seee the flow created with that excel although i have automate tab i cannot trigger the flow
Flow must be created in default environment
@@RezaDorrani i cannot see the flow in my excel when i create it in production environment my company doesn’t allow me to create in default pls help flow is not showing
@@shifamomin6547 currently- This only supports flows in default environment
@@RezaDorrani I have similar use case can u suggest how to create flow in that case?
@@shifamomin6547 Currently you cannot create a flow in non-default environment that you can call directly from excel. It's a limitation in product. I'm not aware of any workarounds.
How can i make excel trigger a webhook?
Not someone I have tried, hence not sure
how did it work for you with multiple selected rows? I tried on mine and received an error.
The input body for trigger 'Selected_Row_-_Process_the_filtered_report' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.
Worked as shown in video.
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
I do not have a video reference on the scenario mentioned. I would recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
i am facing the Action branching condition error while sending the e-mail
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
How thay Power automate tab enanle it in excle??
?
@RezaDorrani in excel Top side. Generally unable to see that power automate Tab option. How to enable it
@@Gunasekaran8 It requires E3 license or above as per documentation and is not rolled out to all regions for excel client yet but should be in excel online if file is in Onedrive or SharePoint
How to send for multiple selected rows?
For each column its working but for rondom selected columns its not working. Is there any other way to send to multiple rows at a time?
I believe it only supports single rows
need your help
Best to directly post the question
Hello Reza,
Can you able to help me with my project ? I m ready to pay.
Hello,
I do not offer 1:1 consulting services