Update Text Label Depending on Condition

(0) Share

Report

Posted on by as733y

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:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

tsa-svd2srv 204 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No