Answered

Filter collection by time when having time as text column in sharepoint list

(0) Share

Report

Posted on by Kayle

Hello all,

I am using a Gallery in my app which source is a collection from a sharepoint list. This is working and I get all values in my Gallery. Now I want to have only values which are now or in the future. I have a column in my sharepoint list with the name "End". This column is a text column and contains for example "10:00".

ClearCollect(bzqa; Filter('Teams Room BZQA'; Now() >= End ))

This does not work because End is not a type of time. Do I have to split "End" to minutes and seconds, or is there an easy way to check if the End value is in the past?

Kay

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 69,039 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Try adding either a TimeValue() or DateTimeValue() function around the End column in the formula. I suspect you'll need to use the DateTimeValue() function and add a static date to the time using concatenation before converting.

Was this reply helpful? Yes No
ShantanuP Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Is End text represents 24 hour clock? If yes then you can do something like following:

ClearCollect(bzqa; Filter('Teams Room BZQA'; Hour(Now()) >= Hour(TimeValue(End)) ))

Was this reply helpful? Yes No
Verified answer

mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

I would say the easiest way to do this with a text column would be to store the times as "numbers" in your text field. For example if you saved 10:00 as 1000 then its more useful as the ':' in between the numbers forces you to use it as a string or split it etc.

Once you have the times saving without the ':' then for the example you mentioned you just do:
ClearCollect(bzqa; Filter('Teams Room BZQA'; Value(Concatenate(Hour(Now()), Minute(Now()))) >= Value(End)))

This will convert the current time (8:50:24) to the number 850 then compare it to the number representation of End

Was this reply helpful? Yes No
Kayle on at

Like (1)

Report
Copy link

Link copied!

Thanks everyone for your help. The solution from @mmollet is working.

BR
Kay

Was this reply helpful? Yes No