Power Apps

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 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,634 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!
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