cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TDB-Jim
Frequent Visitor

Set DataCard text dependent on multiple Date Pickers

 

I have an Editform which includes a 'Query Status' DataCard, and 3 DataCards with a date picker on each.

The date pickers represent the status of the Query - Date Opened, Date Approved or Date Closed.

 

I need to set the contents of the 'Query Status' DataCard to ...

 

  Open - IF there is a date in the Date Opened date picker 

  Approved - IF there is a date in the Date Opened AND the Date Approved date pickers 

  Closed - IF there is a date in the Date Opened AND the Date Approved AND the Date Closed date pickers 

 

This saves the user from having to manually select the status from a pick list after entering the appropriate date.

 

So far I have managed to set the first condition using ...

 

If(!Is blank(DateValue1.SelectedDate),"Open")

 

But I cannot expand the control to cover the other two date pickers - DateValue2 & 3.

 

Is this possible ?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @TDB-Jim 

 

Set "DefaultSelectedItems" property of the combo box

 

If(
    !IsBlank(ClosedDate.SelectedDate) && !IsBlank(OpenedDate.SelectedDate) && !IsBlank(ApprovedDate.SelectedDate),
    ["Closed"],
    If(
        !IsBlank(OpenedDate.SelectedDate) && !IsBlank(ApprovedDate.SelectedDate),
        ["Approved"],
        If(
            !IsBlank(OpenedDate.SelectedDate),
            ["Open"],
            Blank()
        )
    )
)

 

View solution in original post

2 REPLIES 2
StalinPonnusamy
Super User
Super User

Hi @TDB-Jim 

 

Set "DefaultSelectedItems" property of the combo box

 

If(
    !IsBlank(ClosedDate.SelectedDate) && !IsBlank(OpenedDate.SelectedDate) && !IsBlank(ApprovedDate.SelectedDate),
    ["Closed"],
    If(
        !IsBlank(OpenedDate.SelectedDate) && !IsBlank(ApprovedDate.SelectedDate),
        ["Approved"],
        If(
            !IsBlank(OpenedDate.SelectedDate),
            ["Open"],
            Blank()
        )
    )
)

 

TDB-Jim
Frequent Visitor

Hi,

Perfect!

Thanks very much.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,680)