Hi @Anonymous ,
Could you please share more details about your scenario? Where would you like to display the message when month and date meet the condition? Which type is the date column, Date and time not include time?
Assuming the date column is Date and time column without time, you could leverage Month and Day functions to retrieve month and day value from a Date time value, please refer to below official doc:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datetime-parts#syntax
Or you could convert the Date and time value into Text for comparation:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text#datetime
Text(DateValue, DateTimeFormat.ShortDate)
On your end, the formula in your post could be modified to:
If(!IsBlank(LookUp(DataSource;Text(nameofcolumn, DateTimeFormat.ShortDate) = "15/03/2021")) ; "Not Avaliable"; "Avaliable")
This means if look up the data source and find any record that date time field value equals to the string "15/03/2021", then return the message "Not Avaliable", otherwise return message "Avaliable".
Another way is to convert the string "15/03/2021" to a Date time format for comparation:
If(!IsBlank(LookUp(DataSource;nameofcolumn = DateValue("15/03/2021","eu-ES"))) ; "Not Avaliable"; "Avaliable")
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue#syntax
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
