Modern table control - Date format & lookup field issue

(2) Share

Report

Posted on by ThomasVDS

102

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (0)

Report

You need to put the filter inside the AddColumn() and not the inverse. Try that and will get all of the columns that you required.

Was this reply helpful? Yes No
timl 36,328 Super User 2025 Season 2 on at

Like (0)

Report
Hi ThomasVDS

I'd try wrapping AddColumns around the Search. That should hopefully work.

AddColumns( Search(Filter('Opportunity CRM',OpportunityStatus<>'OpportunityStatus (Opportunity CRM)'.Lost), TxtSearchOpportunities.Value,OpportunityID,OpportunityCandidate,OpportunityKey ), DeadlineFormatted, Text(OpportunityDeadline,DateTimeFormat.ShortDate,"nl-BE") )

Was this reply helpful? Yes No
Suggested answer

ThomasVDS 102 on at

Like (0)

Report
Thank you for your suggestions, but they did not work.

Via the following formula the lookup fields are shown, I added them also in the AddColumns part

Search(Filter(AddColumns('Opportunity CRM',DeadlineFormatted,Text(OpportunityDeadline,DateTimeFormat.ShortDate,"nl-BE"),AccountName,AccountID.AccountID,ContactName,OpportunityContact.ContactID),OpportunityStatus<>'OpportunityStatus (Opportunity CRM)'.Lost),TxtSearchOpportunities.Value,OpportunityID,OpportunityCandidate,OpportunityKey)

Was this reply helpful? Yes No