Filter gallery on the last 7 days and filter by display name in combo box

(0) Share

Report

Posted on by jsmith2094

HI,

I have a gallery which uses this function: Filter('Raise New Idea','Last Updated' <= Today() && 'Last Updated' > DateAdd(Today(),-7,Days)). To filter on the last 7 days from SharePoint list.

on another gallery I want to filter on the last 7 days but then filter on developer.displayname from combox

The current function on the new gallery is: Filter('Raise New Idea', Developer.DisplayName in ComboBox1.SelectedItems)

how do I combine: Filter('Raise New Idea','Last Updated' <= Today() && 'Last Updated' > DateAdd(Today(),-7,Days)) and Filter('Raise New Idea', Developer.DisplayName in ComboBox1.SelectedItems) together ?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jsmith2094 ,

Please try:

Filter( 'Raise New Idea', 'Last Updated' <= Today() && 'Last Updated' > DateAdd(Today(),-7,Days) && Developer.DisplayName in ComboBox1.SelectedItems )

Best Regards,

Bof
jsmith2094 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft you are a legend !!! that worked perfectly!!!! thank you so much