Service | Customer Service, Contact Center, Fie...

Using a Field as a parameter

(0) Share

Report

Posted on by SovereignAutos

Good Morning,

I am creating some views using advanced find, and am wondering if it is possible to use a related or otherwise field as a parameter

so for example:

createdon <= entity[modified_date]

Thank you

All responses (2)

Answers (0)

Sort by

Suggested answer

onurizgi 360 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If the entity you want to compare is related to the entity you are searching for, you can do this search. For example, suppose the Customer entity is related to the Person entity 1:N. You can compare the Created Date on the Customer entity to the Modified Date on the Contact entity.
Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!
Hi SovereignAutos,

No, you can only compare columns within a single table as this doc says:

Use column comparison in queries (Microsoft Dataverse) - Power Apps | Microsoft Docs

As a workaround, you could create a calculated field to do this. The following is my test:

1. I create a Person entity which has a N:1 relationship with Contact entity:

2. Create a calculated field(Date and Time) and set it's value to Contact Modified date(You first have to select the Lookup field and then type a period like <LookupFieldName>.<RelatedFieldName>):

3. Create a view with Advanced Find(We could not select the column to compare in Advanced Find):

4. Because we could not select the column to compare in Advanced Find, we need to use View Design and FetchXML Builder in Xrm ToolBox.

5. Open the view with View Design and edit it's fetchxml:

Fetchxml should be like this:

6. You could execute it to preview, then save and publish it.

Result:

Reference:

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/column-comparison

We can now do column comparison with Fetch/Web API! | It Ain't Boring (itaintboring.com)