New to powerapps
We have a table to store user holiday balance between 2 dates.

column 1 – fromdate, datetime column

column 2 – toodate , datetime column

column 3 – balance, decimal

I have a label on a canvas, and would like to display the balance based on todays date being between the from and too dates.

LookUp(UserBalances, Today() >= fromdate && Today() < TooDate && User = User().Email).balance& "hrs"

however, we are receiving the following error :-

Error when trying to retrieve data from the network: The left side of the 'Equal' operator must be a property of the entity.