Notifications
Announcements
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?
Thank you
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).
_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
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
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
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)
Just found it! Looks like it can found under 'chatbots' and 'SchemaName' Tested and working with your OData filter clause. Thank you very much
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 🙂
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 545
chiaraalina 150
Michael E. Gernaey 112 Super User 2025 Season 2
