Unanswered

If row exists in sub-collection, where value is datetime format

(0) Share

Report

Posted on by PGTips

I have a collection (called ABC) and a sub collection (called scheduleItems). The following works to check if the first item in the sub collection = 10:00 (and then changes a colour accordingly).

If(Text(DateTimeValue(First(First(ABC).scheduleItems).start.dateTime),
DateTimeFormat.ShortTime24
) = "10:00",

Orange,RGBA(0,0,0,0))

But how would I create the above when looking for 'any' row that matches "10:00"?

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

What you need to do is to remove first from your formula.
PGTips 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried doing that, but it just complains about DateTimeValue having invalid arguments. Could you show an example of how you mean? 🙂
Slaverty 218 on at

Like
a
(0)

Report
Copy link

Link copied!

I think a filter would do the job for you

IF(CountRows(Filter(ABC, ScheduledItems = 10:00)) < 1, false, true)

Add in whatever format conversion you require.
PGTips 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I understand the idea, thanks @Slaverty - but it still doesn't quite work. The date value I'm extracting is actually two layers of collection deep like this:
PGTips 35 on at

Like
a
(0)

Report
Copy link

Link copied!

OK I figured it out:
~~If(CountRows(Filter(ABC,Text(DateTimeValue(First(scheduleItems).start.dateTime),DateTimeFormat.ShortTime24) = "11:00")) <1,true,false)~~

Nope, thought that worked but it doesn't. Still getting it wrong using first rather than filter
Slaverty 218 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you looking for any entries that match 10:00 within the "dateTime" table, or within the whole collection (scheduleItems/Start)?
PGTips 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Any item in ABC.scheduleItems where the start.dateTime value = 10:00.

But the format the dateTime value is in, looks like this: 2020-02-03T10:00:00.0000000
PGTips 35 on at

Like
a
(1)

Report
Copy link

Link copied!

Cracked it - this now works, where 10:00 is the time converted from the long string.

If(CountRows(Filter(First(ABC).scheduleItems, Text(DateTimeValue(start.dateTime),DateTimeFormat.ShortTime24) = "10:00"))=1,"True","False")