Answered

Search + Filter Question for Two Related Dataverse Tables

(0) Share

Report

Posted on by cmanning

228

I recently needed to filter a Dataverse view per this thread,
Dataverse Views - Can I Use a Variable From My Canvas App and Send to the 'Filter By' In My View? and @dpoggemann provided a great solution as shown below.

// Gallery - ITEMS Property (Works)
Search( Filter( AssignedUserss, 'AssignedUserss (Views)'.'DIApp Home User Dashboard' ), User().Email, "cr4de_assignedemail" )

Now using the code above, I need to also filter WHERE Close Date has not been reached +90 days. So if the close date is 4/15/2022 (+90 days) then it would displayed in the gallery but if close date is 1/1/2022 (+90 days) then it would not be displayed.

Here is my gallery.
DI App - User Dashboard NEED TO Filter by Close Date.png

This code is for the Close Date in the gallery.

// Close Date in the gallery Where DRID is the lookup column 
Text( ThisItem.DRID.CloseDate, "[$-en-US]mm/dd/yyyy" )

Thanks for any feedback.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @cmanning ,

Have you tried code similar to the following to apply the additional filters? http://powerappsguide.com/blog/post/filter-records-by-specific-date-todays-date-or-range-of-dates

Was this reply helpful? Yes No
cmanning 228 on at

Like
a
(0)

Report
Copy link

Link copied!
@dpoggemann - I apologize for my late response but I had some critical tasks become my top priority.
Thank you for putting me on the right track! Here is the solution.
// Gallery Items Property Sort( Filter( Search( AssignedUserss, User().Email, "cr4de_assignedemail" ), 'AssignedUserss (Views)'.'DIApp Home User Dashboard', DateAdd( DRID.CloseDate, 90, Days ) > Today() ), PercentAllocated, Descending )

Was this reply helpful? Yes No