Hello,
I would like to use the modern table control in my canvas app using dataverse tables.
Contact and AccountID are lookup fields.
My first attempt
Formula
Search(Filter('Opportunity CRM',OpportunityStatus<>'OpportunityStatus (Opportunity CRM)'.Lost),TxtSearchOpportunities.Value,OpportunityID,OpportunityCandidate,OpportunityKey)
Result
Then I tried to solve date format issue by using the AddColumns formula
New Formula
Search(Filter(AddColumns('Opportunity CRM',DeadlineFormatted,Text(OpportunityDeadline,DateTimeFormat.ShortDate,"nl-BE")),
OpportunityStatus<>'OpportunityStatus (Opportunity CRM)'.Lost),TxtSearchOpportunities.Value,OpportunityID,OpportunityCandidate,OpportunityKey)
Result
By using the AddColumns formula, the lookup fields are empty now...
I would like to have 3x OK.
How can I solve this issue?
Thanks.
Kr