Automated Time Blocking Plan with AI and Power Automate

#PowerAutomate #prompts #ai
Do you want to regain control of your day? See how you can use AI Prompts in Power Automate to create an automated daily time blocking plan that gets your Outlook events for the day and Microsoft ToDo tasks for the day and creates a customized time blocking plan for you with generative AI.
CODE
Filter Query Expression for Outlook Get Events
start/dateTime ge '@{addHours(utcNow(),-12)}' and start/dateTime le '@{addHours(utcNow(),10)}'
Append to events string expression
@{items('Loop_through_events')?['subject']} event from @{convertTimeZone(items('Loop_through_events')?['start'],'UTC','Central Standard Time')} to @{convertTimeZone(items('Loop_through_events')?['end'],'UTC','Central Standard Time')},
Filter ToDo Tasks
@equals(formatDateTime(convertTimeZone(item()?['dueDateTime/dateTime'], 'UTC', 'Central Standard Time'), 'yyyy-MM-dd'), formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Central Standard Time'), 'yyyy-MM-dd'))
LINKS
View the prompt used: aka.ms/prompt/timeblocking
Download the flow: aka.ms/sample/ai-time-managem...
Power Platform Prompts Repo - aka.ms/powerplatform-prompts
Power Platform Samples Repo - aka.ms/powerplatform-samples
Was this helpful? Buy me a coffee: www.buymeacoffee.com/aprildunnam
Need help? Book office hours with me: aka.ms/april/officehours
00:00 - Intro
00:26 - What We're Building
00:45 - Building the Flow
02:36 - Filtering Calendar Events for Current Day
05:20 - Getting ToDo's for Current Day
06:59 - Calling and Creating a Custom AI Prompt
11:07 - Bringing it all together

[@toluvictor]

This is a really cool use case. Thanks for this April

[@AprilDunnam]

Glad you think so. Thank you for watching!

[@Soticoker]

Thanks April, a good practical use case and great material to learn how to use Power Automate AI features!

[@AprilDunnam]

Thank you, I'm glad you found it helpful!

[@DanielMedic]

Good job April
BG
Daniel

[@AprilDunnam]

Thanks Daniel!

[@XYZD-zw8jd]

Hello April,
I'm stuck with a expression, can you please help me regarding instant or automated plug-in using power fx formula in dataverse accelerator app(Model-driven apps).
The problem statement is : On Create of Contact record
1. If Contact contains Account lookup
a. Get the value from Account (any field from Account)
b. Set it into the Contact record (from the Connected Account only)
2. If Contact is not having Account lookup - the field should not be setup.

[@dougydoe]

Thanks for sharing April. Tried to download it from the Sample Gallery but can't seem to find it! Wondering if you've uploaded it as yet. Thanks

[@AprilDunnam]

Hey there! There was a delay in getting the PR processed but it's up there now :). Here's the link: aka.ms/sample/ai-time-management-flow

[@dougydoe]

@@AprilDunnam Thank you. I've uploaded it into my environment now. Appreciated.

[@mairafernandaamayaquitian]

Hi April, thank you so much, I receive the error The input parameter(s) of operation 'Filter array' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Filter array'. I'm a dummy and I couldn't solve it, any guidance?

[@DanielWeikert]

Thx
would love to see more on the AI hub as well as copilot studio with flow integration
br

[@AprilDunnam]

For sure, thanks for the suggestion. I will add that to my list!

[@121211332525]

Terrific flow here - love it, but ss this in the repo yet? I'm not seeing it

[@AprilDunnam]

Hey there! There was a delay in getting the PR processed but it's up there now: aka.ms/sample/ai-time-management-flow

[@121211332525]

@@AprilDunnam I wound up creating by scratch, but it's throwing an error on the Filter Array (time) 'The template language function 'convertTimeZone' expects its first parameter to be a string that contains the time. The provided value is of type 'Null'. Any suggestions? When you initial the variables do you put anything in the 'value' for time/date?

[@121211332525]

@@AprilDunnam I got the solution imported, but am getting the same error as I'm getting below - expecting its first parameter to be a string that contain the time, but provided value is null. .. should we have the time represented somewhere?

[@121211332525]

​@AprilDunnam After a very long time working on this, it seems it only works when you have current tasks in MS ToDo, but as soon as you have completed items or something overdue it throws errors (null errors). I presume we would have to create conditions to keep going on with the flow if null values are detected -but I don't know how/where to do that yet.. .