Unanswered

Help needed for PVA to add a query

(0) Share

Report

Posted on by Kavyashree_A

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.

Categories:

General

All responses (4)

Answers (0)

Kavyashree_A 6 on at

Like (0)

Report

Re: Help needed for PVA to add a query

Thanks a lot! I will give this a try and let you know 🙂
Pstork1 66,263 Most Valuable Professional on at

Like (1)

Report
Re: Help needed for PVA to add a query

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.

Send the current date as a parameter to the flow

List the Rows in the Excel Table

Filter the array returned by the current date

Do an Apply to Each loop to assemble a markup string table of the results

Return that markup string to the Bot for display
Kavyashree_A 6 on at

Like (0)

Report

Re: Help needed for PVA to add a query

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.
Pstork1 66,263 Most Valuable Professional on at

Like (1)

Report

Re: Help needed for PVA to add a query

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.