Answered

How to call sharepoint list data inside a component in power apps

(1) Share

Report

Posted on by PN-03041536-0

I have a callendar component in power apps, and a table as input that i initialize with the schema like this

Table(
    {
        Title: "title",
        Status: {Value: "Not Started"},
        EventDate: DateValue("7/02/2025"),
        NbOfEmployees: 1
    }
)

and when i call that calendar in the screen view i give the sharepoint list, and i use this filter to make visible the circle for my scheduled event?

CountRows(Filter([@Calendar].LunchData, EventDate = DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days))) > 0
it is not working
could anyone help me with that please? thanks

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Vahid Ghafarpour 712 Super User 2025 Season 2 on at

Like (3)

Report

I think by any reason they are not match, maybe the EventDate return datetime.

Did you try to cast them?

like this

CountRows(
Filter(
[@Calendar].LunchData,
Text(EventDate, "[$-en-US]yyyy-mm-dd") = Text(DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days), "[$-en-US]yyyy-mm-dd")
)
) > 0

Was this reply helpful? Yes No
PN-03041536-0 10 on at

Like (0)

Report

aww thank you so much @Vahid Ghafarpour. it is solved now.

Was this reply helpful? Yes No