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.
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.
Solved! Go to Solution.
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
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
@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
)
User | Count |
---|---|
164 | |
90 | |
73 | |
64 | |
62 |
User | Count |
---|---|
211 | |
153 | |
96 | |
88 | |
66 |