Thank you so much! I was in some way hoping this video would be of a lot of interest for folks. Hence, I went all out at it. Sadly, the initial response in terms of viewership is very low.
@@RezaDorrani i have a similar scenario for taking lunch order for members(outside org), where i save record from a "public" MS Form submission using Power Automate into a Sharepoint List. Member Head can submit for their group members and they can do multiple submission before a cut off date. I would take the latest submission using Power automate to generate the list of members in html table (for each group) and total number to send to the event organizer email. I tried to create a variable (using compose) to get latest entry of Member Head using "max()" expression in power automate. it seems like "max()" cant read the the DateTime field format of "yyyy-mm-ddThh:mm:ssZ" How can i get the latest submission Date Time? Thank you!
@@RezaDorrani Not sure why is my replies deleted... Thanks again for the prompt reply! I have figured out how to use max function. i would need to add calculated column in Sharepoint List to convert my SubmitDateTime to datenumber like in excel. Then, in power automate 1 Use Get to get sharepoint list 2 Select to build an array of datenumber column, make sure to convert to float type 3 Compose max function on Select output I have also tried your recommended first function method, below are my steps 1 Use Get to get sharepoint list with Orderby SubmitDateTime desc 2 Select to build an array of SubmitDateTime column 3 Compose first function on Select output Please do not remove my reply. Thank you!
@@niu745 Note: I do not delete any reply. Replies that include links to certain words are auto blocked by channel policy. I get 100s of comments per day. I don't have the time to sit and delete replies.
Your videos make the concepts so much easier to understand. They’re incredibly insightful! I’m currently working on an application, and each time I plan my next steps, one of your videos covers exactly what I need. It’s been immensely helpful in simplifying the process-thank you!😊
I can see how this would tie in nicely with your next video on bulk table updates, with a deep link to a screen in your app that is prefiltered to the logged in user's items only (so they can take bulk actions on their items). Spectacular as usual Reza!!!
I'm a big fan of your videos Reza! You inspired me to try power automate and I love it eversince, so now I still watch your videos to keep getting inspired :)
wow wow wow. Are you eaves dropping on my teams calls Reza???? I was quite literally just asked to do exactly this, just last week.I got the basics working no problem, but your union/union formula is going to be a life saver. Hadn't gotten that far yet and it's going to save much a ton of time. Fantastic video! Thanks again for all the great videos you produce.
Shoutout to you, well not regarding this video. I used Coalesce function in one of my apps and it worked like a charm what I wanted to achieve. I learned it from you. Thank you Reza ❤
Awesome content as always, Reza. How to handle sending reminder to individual(s) in Assigned to column given it is a multiple allowed people column. Thanks
Most welcome! I do not have a video reference on it and I would have to try out with multi select person column to know the steps. Il suggest checking on forums at powerusers.microsoft.com/
Thanks for the response, Reza. I had many errors while trying and your video just happened to come out at the same time. Was worth asking. Hope you get time to make a video on it one day. You have been a great teacher. 🙏
@denied501 thanks so much! Every 6 monts I ask subscribers for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets the max votes, I would definitely work on it.
Good stuff, this has been very helpful. Any chance you could expand on how to apply basically the same process to tasks that are a multi-select owner? So if a single task could be assigned to two or more people, how would you change the process so that the select statements could loop through the multi select person field?
Your video is amazing and very clear. I have a scenario where the 'Assigned To' field has more than one person assigned. Since this video only covers scenarios with a single assignment, could you refer me to other instructions that might be helpful?
Hi Reza this is exactly what I was looking for. A little help please, in addition to this data set, I have another people column that I wanted to CC on the emails, how do I do this?.
I would have to try that to know the steps. I showed 2-3 scenarios in video and for each of them the technique would probably be different. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Hello Reza. I have been trying to find a MS Power Automate CLOUD certification. Do you know if there is one available for CLOUD? I have only seen the Power Automate RPA Developer which only shows MS PA Desktop version.
I would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Video description has link to download entire app which includes all the code (members only - check description for details) The style code I had built using chatgpt
thanks for your videos they are a huge help... but when i use the people column in the sharepoint the flow doesn't work for example create html table always goes into a for each loop... maybe you can help me :)
I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar. Also, video description has link to download entire solution (members only)
Do you have a video to do this except send the list as an excel attachment instead and then could they make updates to excel reply back and have it update the sharepoint list?
Pick any sharepoint list of your choice and follow the steps. There is no way to show or share a sharepoint list here on comments. Entire solution is available for download to members (check video description for details)
This is truly an excellent video with valuable content and great presentation! One thing I would like to request: the monthly Gold Club subscription fee seems a bit high for us in India, making it difficult to join. Is there any possibility of offering a discount or concession for members from India? I’d love to join and learn more about your interesting topics. Your assistance would be greatly appreciated.
Most welcome! The membership price is set uniformly and applies equally to all members, regardless of their location. RUclips does not offer options for regional bassd pricing that would allow me to set different prices for different countries.
Dear Reza, i need to make automation when SharePoint is created send automated email to direct supervisor and after 24 h if no action taken as per a specific condition send to the manager, do you have any flow or video help me in that
I do not have a specific video reference for this scenario. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Dear Reza, thks for your video again. I try to follow your instructions but each time when I choose custom column in step create HTML table, it creates a loop not like your video, any chance you can help me with this. Thank you
You would need to loop through them and accordingly update the code. I do not have a video reference on the mentioned scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Hi reza - very good content I want to join but I have question before I join up - I don’t have ms work account - if I join will I be able to use any dev environment - specially for power apps - or if I join the club I only get access to the links and I will need to upload the solution into my own environment? Sorry for that
@@RezaDorrani ok , sorry is that mean i need to build the sharepoint library with all the columns on my own ? or there is way , is there any video how to use your projects?
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.
@@RezaDorrani Hi Reza, do you have any video controlling power automate to create records in power app data verse tables? I'm finding it hard to find here.
I have not faced any issues, hence not sure the reason for your error. Video description has link to download entire solution (members only - check description for details)
@ the video is great. It’s a scheduled workflow. In SharePoint designer we can create flows that can pause for a time no matter how long then execute the action. Poweautomate took that away by not letting the flow wait more than 29 days which is real sad. Now I might have to run schedule flow every day to check if it is 60 days to due date or not.
@ABCD-ABCDEFGH power automate never took anything away. It was never an option in the first place. Power Automate it not a replacement for SharePoint workflows. It's a successor. What's the problem if flow runs every day? It would run, check for due items and then send the email.
@@RezaDorrani it was an option in SharePoint Designer . I still have workflows that pause for like 200 days or more than send an email. I guess that’s the only option I have now. Run the workflow everyday check the date and send email. My point is something that we were able to achieve before we are no longer.
I get error when i choose pagination to 100000---- Error:Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'Get_files_(properties_only)' of type 'OpenApiConnection' at line '1' and column '3627' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'.'.
I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
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.
Can't imagine the amount the effort you put in to create such nice videos... Thank you🙏
Thank you so much!
I was in some way hoping this video would be of a lot of interest for folks. Hence, I went all out at it.
Sadly, the initial response in terms of viewership is very low.
@RezaDorrani I'm sure this will pick up.. this has really useful and practical content..
@@anilkumar-ml2sl I hope so.
This is God sent! Truly helped with my organization❤
Glad it helped and thanks so much
@@RezaDorrani i have a similar scenario for taking lunch order for members(outside org), where i save record from a "public" MS Form submission using Power Automate into a Sharepoint List. Member Head can submit for their group members and they can do multiple submission before a cut off date. I would take the latest submission using Power automate to generate the list of members in html table (for each group) and total number to send to the event organizer email.
I tried to create a variable (using compose) to get latest entry of Member Head using "max()" expression in power automate. it seems like "max()" cant read the the DateTime field format of "yyyy-mm-ddThh:mm:ssZ"
How can i get the latest submission Date Time?
Thank you!
Simply sort the data based on date and use first function
@@RezaDorrani Not sure why is my replies deleted...
Thanks again for the prompt reply! I have figured out how to use max function.
i would need to add calculated column in Sharepoint List to convert my SubmitDateTime to datenumber like in excel.
Then, in power automate
1 Use Get to get sharepoint list
2 Select to build an array of datenumber column, make sure to convert to float type
3 Compose max function on Select output
I have also tried your recommended first function method, below are my steps
1 Use Get to get sharepoint list with Orderby SubmitDateTime desc
2 Select to build an array of SubmitDateTime column
3 Compose first function on Select output
Please do not remove my reply. Thank you!
@@niu745 Note: I do not delete any reply. Replies that include links to certain words are auto blocked by channel policy. I get 100s of comments per day. I don't have the time to sit and delete replies.
I have no words to say how good this video is. Very clear, very valuable
Thanks so much
As always, packed with way more than what the topic title promises - thank you Reza.
Most welcome and very happy to hear the feedback
Your videos make the concepts so much easier to understand. They’re incredibly insightful! I’m currently working on an application, and each time I plan my next steps, one of your videos covers exactly what I need. It’s been immensely helpful in simplifying the process-thank you!😊
Great to hear this! Thanks so much for watching and liking the videos.
I can see how this would tie in nicely with your next video on bulk table updates, with a deep link to a screen in your app that is prefiltered to the logged in user's items only (so they can take bulk actions on their items). Spectacular as usual Reza!!!
Love the idea! It would be an awesome scenario.
I'm a big fan of your videos Reza! You inspired me to try power automate and I love it eversince, so now I still watch your videos to keep getting inspired :)
Awesome! Thanks so much
Great video again, well paced and very systematic to follow the concepts and understand. Thank your for staying consistent.
Much appreciated!
Such a well-explained video, Reza!! Loved how you made everything so simple and clear... Thank you for sharing this!
Glad it was helpful! Thanks for watching
😊
Hi Reza, I don't have words to express, how good your contents are, appreciate your knowledge sharing, thank you!😊
Wow, thank you so so much!
@@RezaDorrani , you are welcome! Every Monday, look forward to your new video 😁
Dear Reza Bro, you are the right guider for low code platform, 👏👏👏🙏
Glad to hear that
wow wow wow. Are you eaves dropping on my teams calls Reza???? I was quite literally just asked to do exactly this, just last week.I got the basics working no problem, but your union/union formula is going to be a life saver. Hadn't gotten that far yet and it's going to save much a ton of time. Fantastic video! Thanks again for all the great videos you produce.
You are most welcome! I am on Teams on all day 😉
Shoutout to you, well not regarding this video. I used Coalesce function in one of my apps and it worked like a charm what I wanted to achieve. I learned it from you.
Thank you Reza ❤
Thanks for sharing
Awesome Reza, you always brings very useful material, thank you for that.
Most welcome!
Perfect timing. Thanks for sharing 💥💥
Any time!
That was such a great vid, Reza, thanks so much
Most welcome
Great job as usual!
Thank you! Cheers!
Thank you so much Reza. I have learnt a lot from your videos.
Glad to hear that
I almost can’t do without power automate.. thanks Reza🤓
Absolutely Not :)
Awesome content as always, Reza. How to handle sending reminder to individual(s) in Assigned to column given it is a multiple allowed people column. Thanks
Most welcome!
I do not have a video reference on it and I would have to try out with multi select person column to know the steps. Il suggest checking on forums at powerusers.microsoft.com/
Thanks for the response, Reza. I had many errors while trying and your video just happened to come out at the same time. Was worth asking. Hope you get time to make a video on it one day. You have been a great teacher. 🙏
@denied501 thanks so much!
Every 6 monts I ask subscribers for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets the max votes, I would definitely work on it.
Very nice video Reza 👌👌
Good stuff, this has been very helpful. Any chance you could expand on how to apply basically the same process to tasks that are a multi-select owner? So if a single task could be assigned to two or more people, how would you change the process so that the select statements could loop through the multi select person field?
Thanks!
I would have to show that in a separate video. Would involve a different process.
Currently, I have no plans for a part 2.
I've the same requirement.
Your video is amazing and very clear. I have a scenario where the 'Assigned To' field has more than one person assigned. Since this video only covers scenarios with a single assignment, could you refer me to other instructions that might be helpful?
Glad to hear that!
I dont have a specific video reference on multi select person column.
That was superb loved it♥.
Thank you so much
Thanks Renza 🙏🙏🙏
Most welcome
Gracias por compartir sus conocimientos
Bienvenidos
Hi, this video is very helpful to me. I have a ques, can sharepoint restricted user to see only items assigned to him/her?
What is restricted user?
Hi Rez, do you have any idea how to set recurrence flow with the date column from dataverse?
Recurrence type trigger cannot be set from any data source column
Hi Reza this is exactly what I was looking for. A little help please, in addition to this data set, I have another people column that I wanted to CC on the emails, how do I do this?.
I would have to try that to know the steps. I showed 2-3 scenarios in video and for each of them the technique would probably be different. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Super Thanks!!!
Most Welcome!
Hello Reza. I have been trying to find a MS Power Automate CLOUD certification. Do you know if there is one available for CLOUD? I have only seen the Power Automate RPA Developer which only shows MS PA Desktop version.
I have not kept upto date with the certification program since years now.
I would like to know how to add the users display name in the email body while using the filter array.
I would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
I was looking for the same content..... thank you so much.... one thing, how will get style code... or can u share the code which u have used here
Video description has link to download entire app which includes all the code (members only - check description for details)
The style code I had built using chatgpt
How to get an email I'd from dataverse table lookup of users(systemusers) in place of assigned to email
@@shineremanan5523 I do not have a specific video ref on it. I suggest checking or posting your query on forums at powerusers.microsoft.com/
thanks for your videos they are a huge help... but when i use the people column in the sharepoint the flow doesn't work for example create html table always goes into a for each loop... maybe you can help me :)
I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
Also, video description has link to download entire solution (members only)
A great video as usual, full of information. Can you share the HTML Style code? We can use it then.
I made the html style by asking chatgpt.
Video description has entire solution shared for members (check description for details)
Do you have a video to do this except send the list as an excel attachment instead and then could they make updates to excel reply back and have it update the sharepoint list?
I have ones to export to excel but to update or reply back.
Hello, How else can I get the rows name? Are you able to show how you created the sharepoint?
Pick any sharepoint list of your choice and follow the steps. There is no way to show or share a sharepoint list here on comments.
Entire solution is available for download to members (check video description for details)
If you have a table in Excel with a due date, but not a status, would it be possible to send an e-mail 7 days before that date?
Status logic shown in video is not mandatory
This is truly an excellent video with valuable content and great presentation! One thing I would like to request: the monthly Gold Club subscription fee seems a bit high for us in India, making it difficult to join. Is there any possibility of offering a discount or concession for members from India? I’d love to join and learn more about your interesting topics. Your assistance would be greatly appreciated.
Most welcome!
The membership price is set uniformly and applies equally to all members, regardless of their location. RUclips does not offer options for regional bassd pricing that would allow me to set different prices for different countries.
Dear Reza, i need to make automation when SharePoint is created send automated email to direct supervisor and after 24 h if no action taken as per a specific condition send to the manager, do you have any flow or video help me in that
I do not have a specific video reference for this scenario.
I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Thank you Reza
Most welcome!
Dear Reza, thks for your video again. I try to follow your instructions but each time when I choose custom column in step create HTML table, it creates a loop not like your video, any chance you can help me with this. Thank you
I have not experienced the mentioned issue.
You can try downloading the solution shown in video (members only - check video description for details)
Hi, Reza what to do if assigned to have multiple people in the same record. Please help 🙏🏻
You would need to loop through them and accordingly update the code.
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Hi Reza how do i get the style code for the HTML table can you copy and paste it on the comment please!
I got that from chatgpt.
Entire solution is available for download to silver and gold members.
May I know how do you control the width of each column?
I belive in my case it's auto width based on css applied. I grabbed that css from chatgpt. Did not give any thought into setting widths.
@ you are very responsive. Thanks a lot :)
Hi reza - very good content I want to join but I have question before I join up - I don’t have ms work account - if I join will I be able to use any dev environment - specially for power apps - or if I join the club I only get access to the links and I will need to upload the solution into my own environment? Sorry for that
It would be your own environment.
@@RezaDorrani ok , sorry is that mean i need to build the sharepoint library with all the columns on my own ? or there is way , is there any video how to use your projects?
@@SamanBassam all links shared include a readme file which will walk you through the steps on how to create the lists or libraries
@@RezaDorranisure - sorry but can I take copy of the library template so I don’t create all the columns manually ?
@SamanBassam it depends on the video scenario shared. It would max take 10 mins to setup what is shared.
How Reza, can you please make a video on encrypting and decrypting emails that send from power automate cloud.
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.
Does this work for DataVerse tables too?
Video is specific to sharepoint but technique shown should work with any data source
@@RezaDorrani Hi Reza, do you have any video controlling power automate to create records in power app data verse tables? I'm finding it hard to find here.
@@DjOyda-i9u I don't have one
how to Join this membership and can we download and practice this Power apps & flow by Sliver Mode
Channel membership details
thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Super Hero ❤
Thanks
In case it help someone. I added a Condition after the Get Items action checking if the length is greater than 0, if false, do nothing.
Thank You for sharing
hey rezza I am getting error for the same i am getting the mail but it has no data to show'
I have not faced any issues, hence not sure the reason for your error.
Video description has link to download entire solution (members only - check description for details)
Can we send reminders for before or after 60,200 days
Check video again
@ the video is great. It’s a scheduled workflow. In SharePoint designer we can create flows that can pause for a time no matter how long then execute the action. Poweautomate took that away by not letting the flow wait more than 29 days which is real sad. Now I might have to run schedule flow every day to check if it is 60 days to due date or not.
@ABCD-ABCDEFGH power automate never took anything away. It was never an option in the first place. Power Automate it not a replacement for SharePoint workflows. It's a successor. What's the problem if flow runs every day? It would run, check for due items and then send the email.
@@RezaDorrani it was an option in SharePoint Designer . I still have workflows that pause for like 200 days or more than send an email. I guess that’s the only option I have now. Run the workflow everyday check the date and send email. My point is something that we were able to achieve before we are no longer.
@ABCD-ABCDEFGH My point is that power automate is NOT a replacement for SharePoint designer.
I get error when i choose pagination to 100000---- Error:Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'Get_files_(properties_only)' of type 'OpenApiConnection' at line '1' and column '3627' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'.'.
You need a premium license for that.
With standard license, max you can set is 5000.
@RezaDorrani thanks for the reply
I set this up but I'm only getting 12 rows of data. What am I missing?
I have not experienced the mentioned issue and hence not sure what is the cause 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! Could you please share the download link I am a member =)
nevermind! Found it
Looks like you got the link based on your response comment
How to send notification email to Action Assigned persons, if u show that one also it is better
I do not have a video reference on the mentioned scenario and would have to try it out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
@RezaDorrani thanks
Can I get the css code please 🥺
I had chatgpt build it for me.
I have shared entire solution with channel members (details in description)
🎉🎉
Thanks
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
Sir plz can you create a video for how to create microsoft 365 developer account
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.
in style i cant able to design
You can try downloading the solution shown in video (members only - check video description for details)
please can you make videos in urdu
I cannot