Shane, I'm new to power automate. I'm trying to create a scheduled flow that runs on the 1st & rd. Monday of each month. I started with it running every Monday, to test the rest of the flow. Thanks
Hello, I'm learning power automate. I've been breaking my head on how to show list of employees that applied for leaves in a month dynamically. I used this StartofMonth logic, the flow also ran successfully, however I'm getting blank outputs. Can you please guide me on what I should do to fix this. Thanks!
You need to start by figuring out exactly what the oData filter of Get Items wants. So don't make any dynamic, have an action and type in queries until you get it right. Then once you have the exact syntax, then you can figure out how to make it dynamic. Copilot/ChatGPT are very good at oData if you need help troubleshooting.
Thanks for the video, if you set "Start of Month Today" to startOfMonth(addDays(utcNow(),0)) and kept everything the same, would it run as a false condition on the first of the month? I had a hard time following the last bit of the video for the first of the month.
nice video Shane. I have a doubt, i have a sharepoint list with item an each item have a date, those items are contracts. If this contracts have to create for hymselfs weekly, monthly, anually, etc because they renovate. How would i do it? Thanks Shane
Love this! Thank you. Can you show or point to a video for: "When a status changes, how to pull a modified date from SharePoint list/library, add say three days and compare again with say status and act if condition is met dealing with UTC/EST?" Please.
Yes, you would have to work out the conditional logic but it is possible. The recurrence would be daily then the first step of the flow would be to check is the day the day you want or not. If yes, then send.
Shane, looking to trigger a flow on lease docs when expiration date is 30 days away. i have been searching for a long time and cant find a solution. maybe you can help point me in a good direction... thank you for all the wonderful content.
This video Scheduled Flow and SharePoint oData query - Using Recurrence to check for overdue approvals ruclips.net/video/qGqqQjGMun8/видео.html Have the flow run every day and check if any items meet your criteria 😎
Great video!!!! I have one request in pagination reports can we set automated email excel export for every month 1st week day? please could you help me on this...??
Hi Shane, I have seen your video and you have explained it nicely. Can you help in creating a flow which sends reminder to people who have not filled an entry (only to those who have access to the list) when no item is added on SharePoint list? Is it possible to achieve this? Would appreciate if this can be done.
In Forms I am using a dropdown with multiple branching with the same name. In Flow I am trying to use to ignore all the empty values and keep the selected value but cannot get it to work. Is this something you have come across? I have gone through all your videos on Flow but cannot find the solution. Thanks you.
Hi Shane, powerapps doesn't appear to let users clear and save 'date/choice/ lookup/ person and other data types. Upon submitform() the original values are retained and it fails to clear, no error messages are given so it can be pretty misleading to users who belive they have cleared there data. Do you know of a solution!?
Wouldn't this be more straightforward to say `addToTime(addToTime(startOfMonth(utcNow()), 1, "Month"), -1, "Day")` - That's adding a month to the start of the current UTC month, deducting 1 day?... The only issue with this will be at the beginning and end of the month, however, when you'll get a bit of UTC time-zone crossover. I'm new to all of this, so if you could correct me if I'm wrong, I'd really appreciate it.
Great video @Shane Young. I configured a Scheduled flow on monthly basis, starts from start of the month(1st Jan), when it will trigger on every month?1st Jan, 1st Feb, 1st March like this? or not Could you please clarify me.
Great video as always., thanks for putting so much effort in these QTT... I have a question, what I would have tried to do is to compare the month of today vs the month of today+1 day, but I have no idea if there is a function to get the only the numeric value of the month with flow formulas... Do you have any pointers on where I can read more of the available formulas and the syntax that can be used for flow expressions? Thanks!
I am still looking for a solution on how to print a form or report from PowerApps. Related to this, a multi column pdf report export would be handy as well. Any ideas?
I have a video on printing with a 3rd party ruclips.net/video/m4Fu9af2h1c/видео.html I also have a lot of PDF creation content. You can't print the screen but you can recreate it. Half of our customer projects include making a PDF these days.
@@ShanesCows Does anyone know why Microsoft doesnt have a print function for PowerApps? This seems like a basic requirement especially for companies that need to maintain hard copy records or wish to save complex reports to PDF.
I dont want to delete the last day of the every month file. If file doesnt exist of last day then i dont want to delete last but one day file in power automate
It is possible. You will have to create logic to do it but is possible. I haven't done it before though. I would use this same logic idea but work backwards from the last day of the month until you find a Friday.
Say if I wanted to run this for every month of the year on every last day of the month besides February, would it work start of the month -1 in the compose of start of month tomorrow? Thank you.
The logic I showed first checks to see if Today is the last day of the month. By checking if tomorrow is a different month then today. So I think you have what you want?
@@ShanesCows I think so although was calculated for February with 10 days left where month to month varies -so was thinking calculating start of month minus one would work for all months to determine last day of month?
Very clever Shane! Thanks for this tip! 😃😃
Happy to help 🐶
Shane,
I'm new to power automate. I'm trying to create a scheduled flow that runs on the 1st & rd. Monday of each month. I started with it running every Monday, to test the rest of the flow.
Thanks
Hello,
I'm learning power automate. I've been breaking my head on how to show list of employees that applied for leaves in a month dynamically.
I used this StartofMonth logic, the flow also ran successfully, however I'm getting blank outputs.
Can you please guide me on what I should do to fix this.
Thanks!
You need to start by figuring out exactly what the oData filter of Get Items wants. So don't make any dynamic, have an action and type in queries until you get it right. Then once you have the exact syntax, then you can figure out how to make it dynamic.
Copilot/ChatGPT are very good at oData if you need help troubleshooting.
Thanks for the video, if you set "Start of Month Today" to startOfMonth(addDays(utcNow(),0)) and kept everything the same, would it run as a false condition on the first of the month? I had a hard time following the last bit of the video for the first of the month.
Hi, could you please let me know what we can do for the last day of the current quarter.
I am trying to created a recurring task in planner for the third Monday of every month. I can't figure out the dates. Any tricks? Thank you!
This video really helps me. Thank you.
Glad to help. 😀
I have question I want to add numeric value 2 on list item value on first of the month.please help me how will update it.
Hi Shane,
Could you please guide on "How to fetch first Monday or any other day of every month."
FIRST!!!!
Also, clever logic function there. This can be very handy.
This is why you are my favorite Wes! 🐶
nice video Shane. I have a doubt, i have a sharepoint list with item an each item have a date, those items are contracts. If this contracts have to create for hymselfs weekly, monthly, anually, etc because they renovate. How would i do it? Thanks Shane
Love this! Thank you. Can you show or point to a video for: "When a status changes, how to pull a modified date from SharePoint list/library, add say three days and compare again with say status and act if condition is met dealing with UTC/EST?" Please.
I think the best I have right now is ruclips.net/video/dbsc-Mvh7Co/видео.html where I talk about time zones
Hello! I'm just wondering if it's possible to send a scheduled email via automate every 2nd working day after the last end month?
Yes, you would have to work out the conditional logic but it is possible. The recurrence would be daily then the first step of the flow would be to check is the day the day you want or not. If yes, then send.
@@ShanesCows Thank you for this. I appreciate it. Will try doing that 😁
Shane,
looking to trigger a flow on lease docs when expiration date is 30 days away. i have been searching for a long time and cant find a solution. maybe you can help point me in a good direction... thank you for all the wonderful content.
This video Scheduled Flow and SharePoint oData query - Using Recurrence to check for overdue approvals
ruclips.net/video/qGqqQjGMun8/видео.html Have the flow run every day and check if any items meet your criteria 😎
@@ShanesCows thank you! i will watch that right now.
Great video!!!! I have one request in pagination reports can we set automated email excel export for every month 1st week day?
please could you help me on this...??
Hi Shane, another great video. Is there a way that you could get it to check if 2 days time is the last Friday of the month? Thanks
Hi Shane,
I have seen your video and you have explained it nicely. Can you help in creating a flow which sends reminder to people who have not filled an entry (only to those who have access to the list) when no item is added on SharePoint list? Is it possible to achieve this? Would appreciate if this can be done.
In Forms I am using a dropdown with multiple branching with the same name. In Flow I am trying to use to ignore all the empty values and keep the selected value but cannot get it to work. Is this something you have come across? I have gone through all your videos on Flow but cannot find the solution. Thanks you.
Hey Phil - I haven't done that one yet. Sorry
thank you for this , A much easier way to get EOM !!
Happy to help. Have a great day. 🐶
Hi Shane. I guess I can build the same logic in the Recurrence Trigger condition, right? If I schedule it run daily.
Maybe? I haven’t tried.m that
Hey Shane thanks for the refresher on this one. Question: Have you made a tutorial on using the microphone? I couldnt find it.
I have not. I haven't used it for any real projects so haven't gotten to learn it yet.
Hi Shane, powerapps doesn't appear to let users clear and save 'date/choice/ lookup/ person and other data types. Upon submitform() the original values are retained and it fails to clear, no error messages are given so it can be pretty misleading to users who belive they have cleared there data. Do you know of a solution!?
Thanks for the video BTW, great content as always!!!
I don't. I wish I did. I get this question from time to time :(
Wouldn't this be more straightforward to say `addToTime(addToTime(startOfMonth(utcNow()), 1, "Month"), -1, "Day")` - That's adding a month to the start of the current UTC month, deducting 1 day?... The only issue with this will be at the beginning and end of the month, however, when you'll get a bit of UTC time-zone crossover. I'm new to all of this, so if you could correct me if I'm wrong, I'd really appreciate it.
hi shane, i have a calendar app on power apps, is it possible to have a notification when the date/time is due?
Yes, adapt this flow to only return items that are due. Then send a notification. 😊
Thanks Shane
Happy to help
Great video @Shane Young.
I configured a Scheduled flow on monthly basis, starts from start of the month(1st Jan),
when it will trigger on every month?1st Jan, 1st Feb, 1st March like this? or not
Could you please clarify me.
Every month will trigger the same day. In this case the 1st
Great video as always., thanks for putting so much effort in these QTT... I have a question, what I would have tried to do is to compare the month of today vs the month of today+1 day, but I have no idea if there is a function to get the only the numeric value of the month with flow formulas... Do you have any pointers on where I can read more of the available formulas and the syntax that can be used for flow expressions? Thanks!
This video does exactly that? You could also use the FormatDate expression or action to break a date down to its month number.
I am still looking for a solution on how to print a form or report from PowerApps. Related to this, a multi column pdf report export would be handy as well. Any ideas?
I have a video on printing with a 3rd party ruclips.net/video/m4Fu9af2h1c/видео.html I also have a lot of PDF creation content. You can't print the screen but you can recreate it. Half of our customer projects include making a PDF these days.
@@ShanesCows Does anyone know why Microsoft doesnt have a print function for PowerApps? This seems like a basic requirement especially for companies that need to maintain hard copy records or wish to save complex reports to PDF.
I dont want to delete the last day of the every month file. If file doesnt exist of last day then i dont want to delete last but one day file in power automate
How to get the last Friday date of previous month?
It is possible. You will have to create logic to do it but is possible. I haven't done it before though. I would use this same logic idea but work backwards from the last day of the month until you find a Friday.
Hi Shane, How To Create An Online Course LMS Website With powerapps
I haven't done it. SOrry.
Say if I wanted to run this for every month of the year on every last day of the month besides February, would it work start of the month -1 in the compose of start of month tomorrow? Thank you.
The logic I showed first checks to see if Today is the last day of the month. By checking if tomorrow is a different month then today. So I think you have what you want?
@@ShanesCows I think so although was calculated for February with 10 days left where month to month varies -so was thinking calculating start of month minus one would work for all months to determine last day of month?
@@rnavarrette2010 I only did 10 because it was the 18th the day I was doing it. 1 day is correct
great video . Thank you
Glad you enjoyed it
Awesome..😀
If (EOM) check the pay check else go to sleep 😴 again 👍👍👍👍
💰🤑