Download sample file and follow along efficiency365.com/wp-content/uploads/2023/11/PO-Reminders.xlsx Learn how to generate reminders from Excel data using Power Automate. Step by step process with detailed explanation. Understand triggers, actions, conditions, variables and loops.
Nice video, I’ll have to come up with scenarios to use something like this. I assume the spreadsheet needs to be saved online somewhere for power automate to “find” it.
Thanks @RonDavidowicz Yes. The spreadsheet needs to be on OneDrive. Or any other SharePoint location. Check out my other best practices videos as well. Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @mazenbits4173 Check out my other best practices videos as well. Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
My case is little more complicated, but your video has given me some ideas to try through it.. i was thinking its easy but i am getting few setbacks when creating my flow :-(... any how big thumps up for making world more efficient.
Thanks @user-km4gt9iz2u Best is NOT to use Excel for tasks. Watch this video. Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Check out my other best practices videos as well. Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @ConTecHub Check out my other best practices videos as well. Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @akhilvashu480 Check out my other best practices videos as well. Efficient Tasks Management 2024 - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
I am not getting the excel columns under dynamic content after writing a function, eg: once add formatdatetime() and move to dynamic content, there are no columns listed for selection, but it exists before writing the function. Could you pls help on this.
Flow has saved successfully without error an after testing the flow getting , (Action 'Condition' failed: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'. 1) how to resolve the error.
Great video, thanks a lot😀 Just one query, I am not able to click on the TEST option even when there are no mistakes. Tried it with repeating this same problem but again test option is not getting activated
Thanks @vmmohan08 As suggested by you - I created a video about Copilot activation and usage. Have a look th-cam.com/video/Sjszdd5io8I/w-d-xo.html Check out my other best practices videos as well. Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
I am getting this error still after entering 0, The input parameter(s) of operation 'Apply_to_each' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Apply_to_each'.
Thanks @danielperkins8656 Check out my other best practices videos as well. Efficient Tasks Management 2024 - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Thanks @alexmamode2691 Check out my other best practices videos as well. Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html Cheers. Doc.
Download sample file and follow along
efficiency365.com/wp-content/uploads/2023/11/PO-Reminders.xlsx
Learn how to generate reminders from Excel data using Power Automate.
Step by step process with detailed explanation.
Understand triggers, actions, conditions, variables and loops.
Nice video, I’ll have to come up with scenarios to use something like this.
I assume the spreadsheet needs to be saved online somewhere for power automate to “find” it.
Thanks @RonDavidowicz
Yes. The spreadsheet needs to be on OneDrive. Or any other SharePoint location.
Check out my other best practices videos as well.
Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
This is a great video... thanks a lot.
Thanks @mazenbits4173
Check out my other best practices videos as well.
Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
My case is little more complicated, but your video has given me some ideas to try through it.. i was thinking its easy but i am getting few setbacks when creating my flow :-(... any how big thumps up for making world more efficient.
Thanks @user-km4gt9iz2u
Best is NOT to use Excel for tasks. Watch this video.
Task Management Best Practices - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Check out my other best practices videos as well.
Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
Great explaining video
Thanks @ConTecHub
Check out my other best practices videos as well.
Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
Sir, please create more videos on Powerautomate and Powerapps
Thank you, sir, creating this video 🙏
Thanks @akhilvashu480
Check out my other best practices videos as well.
Efficient Tasks Management 2024 - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
Everyone showing with one plus business or sharepoint. Is it possible to do the same task with normal one drive or other location
Yes Power Automate works on regular (personal) OneDrive as well. Local drive? No.
I am not getting the excel columns under dynamic content after writing a function, eg: once add formatdatetime() and move to dynamic content, there are no columns listed for selection, but it exists before writing the function. Could you pls help on this.
Add one extra step above this one and check.
Most probably, some syntax issue.
Flow has saved successfully without error an after testing the flow getting , (Action 'Condition' failed: Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'In function 'parseDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.
1) how to resolve the error.
what is the input date?
Great video, thanks a lot😀
Just one query, I am not able to click on the TEST option even when there are no mistakes. Tried it with repeating this same problem but again test option is not getting activated
It test is not enabled, it means some error.
Just recreate the flow from scratch and follow the steps. It will work.
How to Get or Activate the Copilot. Pls do one Video on the same
Thanks @vmmohan08
As suggested by you - I created a video about Copilot activation and usage.
Have a look th-cam.com/video/Sjszdd5io8I/w-d-xo.html
Check out my other best practices videos as well.
Efficient Tasks Management - th-cam.com/video/vLFpWVfUfQ8/w-d-xo.html
Task Apps Comparison: th-cam.com/video/ViWJIzMPQZg/w-d-xo.html
Teams Meeting - Agenda, Action Points, Notes - th-cam.com/video/k0t8_mNkMDw/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
@@efficiency365 Thanks a lot
I am getting this error still after entering 0, The input parameter(s) of operation 'Apply_to_each' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Apply_to_each'.
I cannot help you without seeing the entire flow.
Just start from scratch and go step by step. It will work.
I get the same error
Very useful
Thanks @danielperkins8656
Check out my other best practices videos as well.
Efficient Tasks Management 2024 - th-cam.com/video/DJcxPtu-rcg/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.
I am getting error in Apply to each option. Although it seems correct. Please help
It is difficult to troubleshoot remotely. Check the previous step.
Better still, create a new flow from scratch and follow instructions.
Good
Thanks @alexmamode2691
Check out my other best practices videos as well.
Efficient Tasks Management using the New Planner 2024 - th-cam.com/video/kgxqzDirw1o/w-d-xo.html
Microsoft Teams Meetings - 16 Best Practices - th-cam.com/video/l3Bvq-I0hy4/w-d-xo.html
Microsoft Teams - 15 Best Practices - th-cam.com/video/W8Ufx_znKxI/w-d-xo.html
OneDrive Best Practices Part 1 - th-cam.com/video/D7ZrfphW4vo/w-d-xo.html Part 2 - th-cam.com/video/nFx6YQxc-b4/w-d-xo.html
Smart and Effective Email - 5 powerful ways - th-cam.com/video/6NEFSMqHgQE/w-d-xo.html
Outlook Calendar Best Practices : Part 1 - th-cam.com/video/GzsQnecjAQo/w-d-xo.html and Part 2 - th-cam.com/video/padKH8ys5Cs/w-d-xo.html
OneNote - Best Practices - th-cam.com/video/m-4AY1cMi8s/w-d-xo.html
Microsoft 365 Best Practices - th-cam.com/video/kVC_YcL5ObU/w-d-xo.html
Cheers. Doc.