Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Update Text Label Depending on Condition

(0) ShareShare
ReportReport
Posted on by 224
I have a collection with Start Date, End Date, Notes, and True/False Column...
 
I'm trying to update a Text Label for all dates between Start and End that has a true value in the true/false column to display 📝.
 
I know I need to use ForAll, Sequence, and DateDiff together, but I can't seem to figure out how to get the dates from Start and End correctly.
 
I'm using the OOTB Calendar in Powerapps and basically it would display Info for the day and 📝 if the dates have a true value in the true/false column.
 
Below is what I have so far, and it works for the Start Date, but I need to update it so it captures al the dates between start and end.
 
If(IsEmpty(Filter(colUPCOMINGDAL,ThisItem.'Departure Date'= Parent.Selected.'Departure Date'&&ThisItem.'ACP Notes'= true )),ThisItem.Title&" "&ThisItem.Legs,"📝")
 
 
Can someone point me in the right direction?
Categories:
  • Suggested answer
    tsa-svd2srv Profile Picture
    tsa-svd2srv 192 on at
    Update Text Label Depending on Condition
    If I understand what you're asking, your Label's Text property should be something like:
    If(
        Not(IsBlank(LookUp(
            colUPCOMINGDAL,
            StartDate_ColumnName <= StartDatePickerName.SelectedDate && 
            EndDate_ColumnName >= EndDatePickerName.SelectedDate && 
            TrueFalse_ColumnName = true,
            Notes
        ))),
        "📝",
        ""
    )
    Let me know if it works.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard