If statement to return time range records

(0) Share

Report

Posted on by sher5817

SherazadAhmed-6424 asked • 16 hours ago | SherazadAhmed-3939 answered • 1 sec ago

Actions

Hello,

I am customizing a SharePoint online form with PowerApps and trying to to display time ranges in a combo box based on the time ranges that apply. My original function to show all time ranges was "Distinct('Calls Booked', 'Appt Window')". I have two columns that apply to the upper and lower range in the window.

How do I structure my formula to show all time ranges that fall within the current time, whatever that is? Here is a sample of my data:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @sher5817 are the appt window predefined categories or is it free text? if you have the time as 11:00 the first and second entries will be included, is that what you need?

Was this reply helpful? Yes No
sher5817 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi rubin,

The appointment windows are predefined. Please see the attachment for the sample data.

thanks,
Sherazad.

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@sher5817

Here you go:

add this to your combobox Item

Set(_Range, With( { _now: Hour(Now()) }, Filter(yourDataSource, And(_now >= 'Start Time', 'End Time' <= _end) ) ) )

Result

hope it helps,

R

Was this reply helpful? Yes No
sher5817 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rubin, I was unable to get this formula to work. Where doe the _end come from? Is that a name of one of the columns? And what is allowing you to show the data in the first column?

thanks,
Sherazad.

Was this reply helpful? Yes No