Automatic reminders from Excel data - Power Automate - Step by Step

[@efficiency365]

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.

[@akhilvashu480]

Sir, please create more videos on Powerautomate and Powerapps Thank you, sir, creating this video 🙏

[@efficiency365]

Thanks @akhilvashu480 Check out my other best practices videos as well. Efficient Tasks Management 2024 - kzbin.info/www/bejne/envGqYOqqpKlmck Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@mazenbits4173]

This is a great video... thanks a lot.

[@efficiency365]

Thanks @mazenbits4173 Check out my other best practices videos as well. Task Management Best Practices - kzbin.info/www/bejne/envGqYOqqpKlmck Efficient Tasks Management using the New Planner 2024 - kzbin.info/www/bejne/oZjboq16nteqZ9E Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@contechub]

Great explaining video

[@efficiency365]

Thanks @ConTecHub Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@RonDavidowicz]

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.

[@efficiency365]

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 - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@danielperkins8656]

Very useful

[@efficiency365]

Thanks @danielperkins8656 Check out my other best practices videos as well. Efficient Tasks Management 2024 - kzbin.info/www/bejne/envGqYOqqpKlmck Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@Jyoti-h1h]

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.

[@efficiency365]

Thanks @user-km4gt9iz2u Best is NOT to use Excel for tasks. Watch this video. Task Management Best Practices - kzbin.info/www/bejne/envGqYOqqpKlmck Check out my other best practices videos as well. Efficient Tasks Management using the New Planner 2024 - kzbin.info/www/bejne/oZjboq16nteqZ9E Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@alexmamode2691]

Good

[@efficiency365]

Thanks @alexmamode2691 Check out my other best practices videos as well. Efficient Tasks Management using the New Planner 2024 - kzbin.info/www/bejne/oZjboq16nteqZ9E Microsoft Teams Meetings - 16 Best Practices - kzbin.info/www/bejne/omSlp6RjfpWbr5Y Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@sushmita8643]

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

[@efficiency365]

It test is not enabled, it means some error. Just recreate the flow from scratch and follow the steps. It will work.

[@sharathsekhar7386]

Everyone showing with one plus business or sharepoint. Is it possible to do the same task with normal one drive or other location

[@efficiency365]

Yes Power Automate works on regular (personal) OneDrive as well. Local drive? No.

[@naveenpareekk]

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'.

[@efficiency365]

I cannot help you without seeing the entire flow. Just start from scratch and go step by step. It will work.

[@reeh710]

I get the same error

[@vmmohan08]

How to Get or Activate the Copilot. Pls do one Video on the same

[@efficiency365]

Thanks @vmmohan08 As suggested by you - I created a video about Copilot activation and usage. Have a look kzbin.info/www/bejne/iZvWq5eaas6ibqs Check out my other best practices videos as well. Efficient Tasks Management - kzbin.info/www/bejne/rH2poYqMm7qZh5o Task Apps Comparison: kzbin.info/www/bejne/jJq6e3ywgrWEkMk Teams Meeting - Agenda, Action Points, Notes - kzbin.info/www/bejne/oWHXaZKjg9CAetk Microsoft Teams - 15 Best Practices - kzbin.info/www/bejne/jWm4l6uVr9N-rqs OneDrive Best Practices Part 1 - kzbin.info/www/bejne/emi9o5mmnbxnrNE Part 2 - kzbin.info/www/bejne/pHfbZ4yHrchgmJY Smart and Effective Email - 5 powerful ways - kzbin.info/www/bejne/bH-od4aDpq2ah6c Outlook Calendar Best Practices : Part 1 - kzbin.info/www/bejne/favWgqGbmM90h9E and Part 2 - kzbin.info/www/bejne/ppLHfHturthoedU OneNote - Best Practices - kzbin.info/www/bejne/o16XcoxnmLKcbtU Microsoft 365 Best Practices - kzbin.info/www/bejne/oYemkIyZgZqCmLc Cheers. Doc.

[@vmmohan08]

@@efficiency365 Thanks a lot

[@gajendrapalbaghel1730]

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.

[@efficiency365]

what is the input date?

[@soumyav8266]

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.

[@efficiency365]

Add one extra step above this one and check. Most probably, some syntax issue.

[@i_m_pratt_bratt]

I am getting error in Apply to each option. Although it seems correct. Please help

[@efficiency365]

It is difficult to troubleshoot remotely. Check the previous step. Better still, create a new flow from scratch and follow instructions.