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.
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!!!
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!😊
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.
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 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?
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 ❤
@@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.
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/
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)
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. TH-cam does not offer options for regional bassd pricing that would allow me to set different prices for different countries.
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)
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/
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?
@@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.
@ 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 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)
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.
As always, packed with way more than what the topic title promises - thank you Reza.
Most welcome and very happy to hear the feedback
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.
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.
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 😉
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
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
😊
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?
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.
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 😁
Great video again, well paced and very systematic to follow the concepts and understand. Thank your for staying consistent.
Much appreciated!
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
Gracias por compartir sus conocimientos
Bienvenidos
Perfect timing. Thanks for sharing 💥💥
Any time!
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 almost can’t do without power automate.. thanks Reza🤓
Absolutely Not :)
Great job as usual!
Thank you! Cheers!
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!
Awesome Reza, you always brings very useful material, thank you for that.
Most welcome!
Thank you so much Reza. I have learnt a lot from your videos.
Glad to hear that
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)
Thanks Renza 🙏🙏🙏
Most welcome
That was such a great vid, Reza, thanks so much
Most welcome
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)
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. TH-cam does not offer options for regional bassd pricing that would allow me to set different prices for different countries.
Thank you Reza
Most welcome!
That was superb loved it♥.
Thank you so much
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.
Super Hero ❤
Thanks
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)
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/
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.
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
🎉🎉
Thanks
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.
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.
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 I get the css code please 🥺
I had chatgpt build it for me.
I have shared entire solution with channel members (details in description)
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.
please can you make videos in urdu
I cannot