Using valueof Attribute for FetchXML Filters | Cross-Table Comparisons

Using valueof Attribute for FetchXML Filters | Cross-Table Comparisons

In this article, you'll discover how to utilize the valueof attribute within FetchXML to create filters that compare column values within the same row. This technique can be used in a number of scenarios, such as finding contact records where the firstname column matches the lastname column (Scenario 1) or performing cross table comparisons to fetch rows where the contact fullname column matches the account name column (Scenario 2).

If you're looking for more information on utilizing FetchXML and other Microsoft Dynamics 365 tools, be sure to check out the author's other articles.

Link to the article: https://rajeevpentyala.com/2024/04/28/fetchxml-filter-on-column-values-in-the-same-row/

Published on:

Learn more
Rajeev Pentyala – Microsoft Power Platform
Rajeev Pentyala – Microsoft Power Platform

Sharing my knowledge on Power Platform, Dynamics 365, Azure & .Net Stack

Share post:

Related posts

Filter Related Records with addPreSearch() | Model Driven App

In this experiment, the author attempts to combine the addPreSearch() method in the Client API with the recently documented FetchXml functiona...

1 month ago

Custom Lookup Filtering In Basic Forms – Power Pages

In this blog we will see how to use custom lookup filtering in basic forms. Basic forms in power pages with lookup fields often face issue wit...

3 months ago

Filtering Dynamics 365 Finance and Operations Dataverse Virtual Entities in Customer Portal

Filtering Dynamics 365 Finance and Operations Dataverse Virtual Entities in Customer Portal Fabien Leal Fri, 04/28/2023 - 11:35 Body ...

1 year ago

How to Filter MS CRM Lookup with Custom Conditions Using JavaScript?

In the world of customer relationship management, Microsoft Dynamics CRM is a popular platform that offers businesses the ability to effective...

1 year ago


In this post, you will learn about converting Query Expression to FetchXML and vice versa in Dynamics 365. Dynamics 365 is a powerful tool for...

2 years ago

Column comparison using FetchXML (Valueof node)

Comparison of column was challenging part while executing FetchXML in Dynamics CRM. Microsoft added one new node inside FetchXML condition tag...

2 years ago

Exploring additional filtering capabilities in Sales Forecasting

If you're a seller or manager looking to track sales performance, Dynamics 365's sales forecasting feature is an invaluable tool. In the 2022 ...

2 years ago

Related Record Filtering with the Lookup Dropdown PCF

A new feature has been added to Dataverse's LookupDropdown PCF control that allows for related record filtering. This means that dropdown valu...

2 years ago

D365 CRM Entity Relationships

In this post, we delve into the different types of entity relationships in Microsoft Dynamics 365 CRM and offer insights into how they work. U...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy