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

(0) 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 component framework

All responses (1)

Answers (0)

Suggested answer

Vahid Ghafarpour 167 on at

Like (1)

Report

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

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