Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Answered

Dataverse New Topics - Multiple Bots

(0) ShareShare
ReportReport
Posted on by

Hello, 

I've previously created a flow to pull from dataverse a list of topics that have been added in the last 30 days. This worked great when I had just one chatbot per Teams page they were created on. 

However, I'm now moving 3 chatbots under one Teams page environment... is there a way to filter the dataverse action so it only pulls the topics applicable to that chatbot as well the date created on filter? From what I can see there is 'parentbotid' and 'parent chatbot subcomponent' as data fields, I'm just not sure what the syntax would be or which one would work? I've tried a few times with no luck. If anyone has any ideas please?

 

Matthew5_0-1670340267916.png

 

 

Thank you

Categories:
  • HenryJammes Profile Picture
    HenryJammes on at
    Re: Dataverse New Topics - Multiple Bots

    Great to read - indeed it might be easier to filter on the bot name or schema name instead of the botid in Dataverse for Teams 🙂

  • Matthew5 Profile Picture
    Matthew5 on at
    Re: Dataverse New Topics - Multiple Bots

    Just found it! Looks like it can found under 'chatbots' and 'SchemaName' 

    Tested and working with your OData filter clause. Thank you very much

    Matthew5_1-1670346475510.png

     

  • Matthew5 Profile Picture
    Matthew5 on at
    Re: Dataverse New Topics - Multiple Bots

    Thank you so much for the prompt reply, I'm utilising PVA for Teams. I don't suppose there's a way to find that within Teams?
    I've had a quick look online and can't see any supporting articles online to find this, I've checked the dataverse tables it's blank (so I'm not very hopeful)

    Matthew5_0-1670345756015.png

     

  • HenryJammes Profile Picture
    HenryJammes on at
    Re: Dataverse New Topics - Multiple Bots

    It's actually a different ID.

    The bot id is the one for the Dataverse bot record. You can find in the PVA URL when editing a bot in the PVA portal.

    E.g. https://web.powerva.microsoft.com/environments/c53bf002-7923-4d1c-b5ae-3265093d59e1/bots/2d3aae11-a9f8-4796-abdc-99f6a84c0f6c

  • Matthew5 Profile Picture
    Matthew5 on at
    Re: Dataverse New Topics - Multiple Bots

    Thank you very much, I'll give this a go. 

    May I please ask, where I would find those IDs referenced? I can see 3 similar formatted numbers, as either 'Environment ID', 'Tenant ID' or 'Bot app ID' via the details section of PVA

  • Verified answer
    HenryJammes Profile Picture
    HenryJammes on at
    Re: Dataverse New Topics - Multiple Bots

    Hello @Matthew5,

    So, this one is a bit tricky but possible.

     

    For bots created in the current, production-supported, version of PVA, you need to filter based on the many-to-many relationship (bot_botcomponent) that exists between Chatbot (bot) and Chatbot Subcomponent (botcomponent).

     

    The OData filter clause would look like this:

     

    bot_botcomponent/any(o:o/botid eq '2e65b370-0258-47d3-805a-a7a9ed6bd2bd') and createdon ge '2022-11-30'

     

     

    For bots created in the new unified authoring experience (now in public preview), you indeed need to filter based on the many-to-one relationship (parentbotid).

     

    The OData filter clause would look like this:

     

    _parentbotid_value eq '5b1383be-76ce-40c3-ac45-e09ca5961b4a' and createdon ge '2022-11-30'

     

     

    You can learn more about OData and syntax for the Dataverse Web API here: Query data using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Learn

     

     

     

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics