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

Efficiency 365 by Dr Nitin

Подписаться 68 тыс.

Просмотров 11 тыс.

50% 1

Видео Поделиться Скачать Добавить в

Опубликовано:

2 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@efficiency365 11 месяцев назад

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.

@sushmita8643 2 месяца назад

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 2 месяца назад

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

@RonDavidowicz 11 месяцев назад

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 11 месяцев назад

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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Task Apps Comparison: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ViWJIzMPQZg.html Teams Meeting - Agenda, Action Points, Notes - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k0t8_mNkMDw.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.

@Jyoti-h1h 3 месяца назад

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 3 месяца назад

Thanks @user-km4gt9iz2u Best is NOT to use Excel for tasks. Watch this video. Task Management Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DJcxPtu-rcg.html Check out my other best practices videos as well. Efficient Tasks Management using the New Planner 2024 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kgxqzDirw1o.html Microsoft Teams Meetings - 16 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l3Bvq-I0hy4.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.

@i_m_pratt_bratt 4 месяца назад

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

@efficiency365 4 месяца назад

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

@akhilvashu480 5 месяцев назад

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

@efficiency365 5 месяцев назад

Thanks @akhilvashu480 Check out my other best practices videos as well. Efficient Tasks Management 2024 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DJcxPtu-rcg.html Microsoft Teams Meetings - 16 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l3Bvq-I0hy4.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.

@naveenpareekk 2 месяца назад

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 2 месяца назад

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

@sharathsekhar7386 2 месяца назад

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

@efficiency365 2 месяца назад

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

@soumyav8266 4 месяца назад

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 4 месяца назад

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

@vmmohan08 11 месяцев назад

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

@efficiency365 11 месяцев назад

Thanks @vmmohan08 As suggested by you - I created a video about Copilot activation and usage. Have a look ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Sjszdd5io8I.html Check out my other best practices videos as well. Efficient Tasks Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Task Apps Comparison: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ViWJIzMPQZg.html Teams Meeting - Agenda, Action Points, Notes - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k0t8_mNkMDw.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.

@vmmohan08 11 месяцев назад

@@efficiency365 Thanks a lot

@contechub 11 месяцев назад

Great explaining video

@efficiency365 11 месяцев назад

Thanks @ConTecHub Check out my other best practices videos as well. Efficient Tasks Management - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vLFpWVfUfQ8.html Task Apps Comparison: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ViWJIzMPQZg.html Teams Meeting - Agenda, Action Points, Notes - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-k0t8_mNkMDw.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.

@alexmamode2691 4 месяца назад

Good

@efficiency365 4 месяца назад

Thanks @alexmamode2691 Check out my other best practices videos as well. Efficient Tasks Management using the New Planner 2024 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kgxqzDirw1o.html Microsoft Teams Meetings - 16 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l3Bvq-I0hy4.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.

@danielperkins8656 5 месяцев назад

Very useful

@efficiency365 5 месяцев назад

Thanks @danielperkins8656 Check out my other best practices videos as well. Efficient Tasks Management 2024 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DJcxPtu-rcg.html Microsoft Teams Meetings - 16 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l3Bvq-I0hy4.html Microsoft Teams - 15 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W8Ufx_znKxI.html OneDrive Best Practices Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D7ZrfphW4vo.html Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nFx6YQxc-b4.html Smart and Effective Email - 5 powerful ways - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6NEFSMqHgQE.html Outlook Calendar Best Practices : Part 1 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GzsQnecjAQo.html and Part 2 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-padKH8ys5Cs.html OneNote - Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-m-4AY1cMi8s.html Microsoft 365 Best Practices - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVC_YcL5ObU.html Cheers. Doc.