15
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
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)
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (