Retrieve month from a sharePoint

[loopingmurdock]

Hello Guys.

Am trying to compare the month from a column in a sharePoint with PowerApps?

I have tried this:

If(!IsBlank(LookUp(Add_Expensive, DateOf = Month(Now()))), "Avaliable", "UnAvaliable")

Even if both month are 6 (June).

Add_Expensive = SharePoint Data.

DateOf = Column format date.

Thank you for your time.😉

[Ashwin7104 · Accepted solution]

Hey @loopingmurdock ,

Please use the below formula since Month(column) is not delegable

If(
    !IsBlank(
        LookUp(
            Add_Expensive,
            DateOf  >= Date(
                Year(Now()),
                Month(Now()),
                1
            ) And DateOf < DateAdd(
                Date(
                    Year(Now()),
                    Month(Now()),
                    1
                ),
                1,
                Months
            )
        )
    ),
    "Avaliable",
    "UnAvaliable"
)

.
If this post helped you, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[loopingmurdock]

Thanks, The code works perfect but don't understand the structure of the 1s.

[loopingmurdock]

To do a countRows() i just copy the code completely sorry to bother you?

[Ashwin7104]

Hey @loopingmurdock ,

First and second 1's mark the 1'st of every month like 1st June. The third 1's is used to add one month to the current month. 

[Ashwin7104 · Accepted solution]

Hi @loopingmurdock ,

For using countrows,

1) replace LookUp with Filter function

2) Directly using Countrows will throw delegate issue. So assign the filtered records to a collection and then count the rows

Thanks.