Announcements
I've created a simple bot to get the lists of birthdays and anniversaries by name, unique badge number, month, and event type (birthday and anniversary) . I want to know if we can add any queries to get today's events. For example, if the user wants to know what events (birthday/anniversary) are for today, how do I do that? my Chabot is simple with only topics and no power to automate.
Unfortunately, the only way to do that would be to call a Power Automate flow to do the query. Depending on where the events are stored its a relatively easy flow to build, but there is no way to query it inside a Bot other than using Power Automate, unless the events are all stored in an entity inside PVA. But storing the events in a custom entity in PVA would take more work than writing a PA flow to retrieve them.
The events are stored in an excel file on SharePoint as well as on my system. Could you help me with how to call and use a power automate flow for this particular question? Any help would be appreciated. Thanks.
Make sure the events in the Excel file are in the form of an Excel Table. If they are then its a relatively easy flow to create.
Thanks a lot! I will give this a try and let you know 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 410
Romain The Low-Code... 160 Super User 2026 Season 1
chiaraalina 63 Super User 2026 Season 1