Hi @Anonymous ,
Do you mean that:
1)you have a lookup field which looks up to contract no in Contracts list?
2)you want to filter this lookup field to only display active contract?
Could you tell me the data type of the field that records status of contract in Contracts list?
I assume that this field is named status and its data type is Choice.
If so, actually your key point is to avoid delegation.
Since Choices() function is not delegate, so I do not suggest you use this common solution to set lookup field.
You could set like this:
1)if you use form to update this lookup field
set the combo box's Items:
Filter(Contracts,status.Value="active")
set this field datacard's Update:
{Value:DataCardValue5.Selected.'contract no',Id:DataCardValue5.Selected.ID}
//DataCardValue5 is this combo box name
2)if you use patch to update this lookup field
set the combo box's Items:
Filter(Contracts,status.Value="active")
Patch function should be like this:
Patch(...,....,
{lookupfieldname:
{Value:DataCardValue5.Selected.'contract no',Id:DataCardValue5.Selected.ID},
...
}
)
//DataCardValue5 is this combo box name
Best regards,
