Adding items to collection based on If condition

(0) Share

Report

Posted on by venka91

1,119

Hi there,

i want to get help on adding the below items into collection. Please assist.

Based on the if condition, if it is future time slot, the collection should not hold that value.

If(TimeValue(Now())<TimeValue("5:30"), Set(varddtimeItems, "5:30 AM"),
If(TimeValue(Now())<TimeValue("8:30"), Set(varddtimeItems, "8:30 AM"),
If(TimeValue(Now())<TimeValue("18:45"), Set(varddtimeItems, "6:45 PM"),
If(TimeValue(Now())<TimeValue("21:30"), Set(varddtimeItems, "9:30 PM")))))

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the below forumula, but it is storing only one value.
I am expecting, if my current time grater the pas time, the collection should hold the values of past time slots.

ClearCollect(ddItem, {varddtimeItems:
If(TimeValue(Now())>TimeValue("5:30"), "5:30 AM",
If(TimeValue(Now())>TimeValue("8:30"), "8:30 AM",
If(TimeValue(Now())>TimeValue("18:45"),"6:45 PM",
If(TimeValue(Now())>TimeValue("21:30"), "9:30 PM"))))})
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

I managed to get the items of dropdown by writing the formulas directly into the Item Property of dropdown. But still, i am getting Blank space on my drop down, when the if condition fails. How to clear these whitespaces.

In Item property of drop down :

["Select",(If(TimeValue(Now())>TimeValue("5:30"), "5:30 AM")),
(If(TimeValue(Now())>TimeValue("8:30"), "8:30 AM")) ,
(If(TimeValue(Now())>TimeValue("18:45"),"6:45 PM")) ,
(If(TimeValue(Now())>TimeValue("21:30"), "9:30 PM"))]

But this is giving blank space for the If conditions that are false.
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

One quick solution is to change the box items to this:

Filter(["Select",(If(TimeValue(Now())>TimeValue("5:30"), "5:30 AM")),
(If(TimeValue(Now())>TimeValue("8:30"), "8:30 AM")) ,
(If(TimeValue(Now())>TimeValue("18:45"),"6:45 PM")) ,
(If(TimeValue(Now())>TimeValue("21:30"), "9:30 PM"))],!IsBlank(Value))
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

ok, I do not see the blanks now. but for the past dates also this validation pulls only past time slot.
If it is pass date, it should show all 4 time slots. and for current date, it suppose the validate the formula i told above.
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

what is the name of the value that is the past time slot is it in a gallery so thisitem.something or is it a variable or a datepicke? i need to use it to reference the formula
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

no datas are coming from gallery.
This is standalone drop down. Based on the datapicker, if chosen date is past, the drop down must show all the time slots, 5:30, 8:30, 6:45 and 9:30
In case if the date is today, drop down should validate the If formula and show only the past time slots, Example, if the curernt time is 15:00, then it should show only 5:30 and 8:30 current date.