Category: Fetch

My AI Foundry is free for You!

~ Jonas Rapp ~ Leave a comment

Yes, it’s true, I share my Azure AI Foundry OpenAI provider for you out there.

Why do I cover the cost for using Azure AI Foundry in FetchXML Builder?

I’m pretty proud that I introduced the AI Chat feature in FetchXML Builder this summer. Like I’ve said many times, “I surely know more than a robot!”, but during the development this summer, I learned quite a lot about AI, and more importantly, I’m impressed by the knowledge it has in the FetchXML area.

Continue reading “My AI Foundry is free for You!” →

FetchXML improve for us to achieve more

~ Jonas Rapp ~ Leave a comment

I got a challenge from my colleague at CRMK:

I need to set owners on accounts with a team with the same name as the account.

Mia @ CRMK

Is that even possible??
Yes, it actually is.

Continue reading “FetchXML improve for us to achieve more” →

Layouts in FetchXML Builder

~ Jonas Rapp ~ 4 Comments

This is a new feature. A brand new fancy feature. This tool is now going from two dimensions to three dimensions.

As always, we can work with the query and see the data. From now on – work also with the layouts to get nice designs.

How do we show the data in the Model Driven Apps? Keep on reading…

Don’t like to read? See my simple tutorial video instead!

Continue reading “Layouts in FetchXML Builder” →

Know the Dataverse, Solution, and Publisher

~ Jonas Rapp ~ 5 Comments

Why are Solutions a new feature in FetchXML Builder?

Solutions have nothing to do when we’re working with queries, right?
So why is this the best feature I have released this last year, or longer?

I know, the subject seems like a crazy big blog…
…anyway, go on and see why you should know it!

Continue reading “Know the Dataverse, Solution, and Publisher” →

Dataverse Metadata in FetchXML Builder

~ Jonas Rapp ~ Leave a comment

I like smart tools.
I like smart code.
I don’t like smart tools and cool code – if I have to write it again.

One of the best XrmToolBox tools is the Metadata Browser – at least for me 😊

Continue reading “Dataverse Metadata in FetchXML Builder” →

Custom Translations – the Easy Way

~ Jonas Rapp ~ 4 Comments

In many customer projects and products, I have built solutions for managing translations in Microsoft Dynamics 365 / CDS / CRM.
Sure, the metadata can be translated to show labels etc in the language of the user, but having a custom solution for translations ensures localized content for texts that are shown to the user from code or automation.

Continue reading “Custom Translations – the Easy Way” →

Querying date intervals in the Common Data Service

90 days from now
~ Jonas Rapp ~ 13 Comments

Querying date intervals in Microsoft Common Data Service, Power Apps and Dynamics 365 is not always possible using Advanced Find nor is it as easy as working with plain SQL.

TL;DR – with FetchXML this is quite possible!

Continue reading “Querying date intervals in the Common Data Service” →

Create view: Active Contacts in My State

~ Jonas Rapp ~ 14 Comments

Microsoft Dynamics 365 Customer Engagement and Common Data Service offer us the querying language FetchXML to retrieve data. Since this is the language used for views saved in the system, we can use FetchXML Builder for XrmToolBox to alter the features of views beyond what is possible using platform features, without making them unsupported.

Continue reading “Create view: Active Contacts in My State” →