Power Platform Community Forum Thread Details

I have created a model driven app with two tables. One is called new_Contracts and the other is called new_ContractsExtensionOptions. There is a lookup field to the new_ContractsExtensionOptions to the new_Contracts table. A record in the new_Contracts table can have several related records in the The new_ContractExtensionOptions table. I want to create a new column in the new_Contract Table that looks at all the related records in the new_ContractExtensionOptions table and returns the latest extension date from a field called new_EndDate in the new_ContractExtensionOptions table. However if there are no contract extension option records in the new_ContractsExtensionOPtions table, I want the value to be returned to be the new_InitialContractEndDate which is a column/Field in the new_Contracts table. I have a lookup/relationship that is a one to many from the new_Contracts table to the new_ContractsExtensionOptions table but when I try adding a column using the fx formula option it keeps throwing up errors and doesn't seem to identify or see the related table for me to reference it in the formula. I don't know what I'm doing wrong or if there are some setting that need to be applied to use the formula function. I've tried using the formula function in one of the tables and it just keeps throwing out errors that it doesn't recognise FILTER or MAX or the syntax. Help i've been trying to figure this out for two days.

If(
 IsBlank(
 Lookup(
 'new_ContractsExtensionOptions',
 'new_Contracts',
 new_ContractsExtensionOptions.new_ContractId = new_Contracts.new_ContractId,
 new_EndDate,
 Descending
 )
 ),
 new_InitialContractEndDate,
 Lookup(
 'new_ContractsExtensionOptions',
 'new_Contracts',
 new_ContractsExtensionOptions.new_ContractId = new_Contracts.new_ContractId,
 new_EndDate,
 Descending
 )
)

Categories:

Building Power Apps