Incorporating if() into filter(), date picker questions

(0) Share

Report

Posted on by RMDNA

100

Hi all, I'm back!

First question: I have some filter conditions set on a gallery, but I'm trying to figure out how to incorporate an If() into it. I've looked elsewhere on the board, but I'm having trouble finding something that makes sense.

Essentially, if a project (Project.'Project Name') is selected from the dropdown (FP_drp_ProjectName), the gallery displays the correct items. However, I need to include that if that dropdown is blank, return all projects (but still filtered by the other conditions), since at the moment, clearing the dropdown empties the gallery.

SortByColumns(
 Filter(
 'Time Entries','Time Entries (Views)'.'Time Entries for Approval',
 Date > VarSelectedStartDate && Date < VarSelectedEndDate && 
 Project.'Project Name' = FP_drp_ProjectName.SelectedText.Result
 ),
 "msdyn_date",
 Ascending
)

Second question: is there a way to get the first date of a week when you pick a date in a DatePicker? I need to set the Sunday of a week as my StartDate variable. As far as I can tell, I can't really change the DatePicker all that much, so I want to ensure that selecting any date in a week starts you on that Sunday.

What would be really useful is also being able to get a list of all dates in that week.

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RMDNA :

Q1:

Please try this formula:

SortByColumns( Filter( 'Time Entries', 'Time Entries (Views)'.'Time Entries for Approval', Date > VarSelectedStartDate && Date < VarSelectedEndDate && If( FP_drp_ProjectName.SelectedText.Result=Blank(), true, Project.'Project Name' = FP_drp_ProjectName.SelectedText.Result ) ), "msdyn_date", Ascending )

Q2:

Do you want to get the first day of the week in which the date you choose is?
Do you want Sunday to be the first day of the week?

If so,please try this formula:

DateAdd( DatePicker1.SelectedDate, 1 - Weekday(DatePicker1.SelectedDate), Days )

Best Regards,

Bof
RMDNA 100 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft,

Thanks for the assist. I got the date part working, but when using your other formula, the gallery is now empty regardless of the dropdown selection. I get an error of "Blank() = PowerApps encountered an internal error trying to evaluate this expression."

Does it matter that there's not an explicit "blank" option in the data? I have the dropdown Default set to Blank( ) and a button that triggers Reset(FP_drp_ProjectName) to clear it of any selection.
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RMDNA :

There should be an explicit "blank" option in that drop down control.

For example,my drop down's items property is:

Table({Value:Blank()},{Value:1},{Value:2})

Best Regards,

Bof