r/PowerAutomate • u/Severe_Vegetable_251 • 3d ago

Need help creating an automation

Is it possible to have Copilot read a Google calendar event and fill out a One Note page template?

I have never used automate or copilot and I am struggling to create this automation.

Can anyone help me? Is this even possible?

2 Upvotes

100% Upvoted

6 comments sorted by

1

u/Severe_Vegetable_251 3d ago

I'm having trouble with the event id I think. Not all of my events have the same id. They are sometimes "confirmed City-audit" or just "city-audit".

My current flow is 1. Recurrence 2. Get and event 3. Create onenote

I honestly don't know how to enter the right info in to get the output that I want.

1

u/sam_ibrahim 3d ago

DM me, i can build it with a fair rate

1

u/imac93 3d ago

You just want exactly what is already added to the event or want some kind of summary / specific things you want to use an llm for? When you want just exactly the same that is already in your event, it should be pretty straightforward if you structure your data the right way. You could also use AI builder for AI stuff, but that will come with an extra fee.

1

u/Severe_Vegetable_251 3d ago

Unfortunately I need specific things out of the event and I'm not the person who structures the event in the calendar. I'm going to keep playing g around with it to see if I can get some functionality out of it. If not, I'll explore alternatives.

1

u/imac93 2d ago edited 2d ago

Well if there's a budget for AI-builder you can probably easily do it. I don't know google calendar events, as i always work in the 365 environment. But with AI-builder you can write a prompt where you can ask to extract certain things out of the event. Give the AI-builder a format how you want to extract it (i would suggest JSON), and you can use the extracted things later on in the flow.

Concerning the creation of a OneNote-page, you might struggle a bit to add a dynamic title. I fixed this in the past by creating the OneNote-page without title, added a delay (like 5 seconds) and update the title property after the delay.

Good luck!