cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kavyashree_A
New Member

Help needed for PVA to add a query

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. 

4 REPLIES 4
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Kavyashree_A
New Member

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.  

  1. Send the current date as a parameter to the flow
  2. List the Rows in the Excel Table
  3. Filter the array returned by the current date
  4. Do an Apply to Each loop to assemble a markup string table of the results
  5. Return that markup string to the Bot for display


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Kavyashree_A
New Member

Thanks a lot! I will give this a try and let you know 🙂

Helpful resources

Announcements
Power Virtual Agents News & Announcements

Power Virtual Agents News & Announcements

Keep up to date with current events and community announcements in the Power Virtual Agents community.

Power Virtual Agents Community Blog

Power Virtual Agents Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,418)