Hello,
I’m new to Power Apps, so I’ve been following a tutorial, but though I’ve followed it step by step, when I type the following into the formula bars for a couple of buttons (OnSelect), it’s not working for me, although it does work in the tutorial.
I’ve gone over it to see if I made any mistakes copying it, but as far as I can tell, I haven’t. And I’ve tried googling but I can’t seem to find anything, and because I’m new I have no idea what to try next, so any help is greatly appreciated.
I’ve tried to include all the relevant information, but if I have accidentally left anything out, please don’t hesitate to ask me, and if I can I’ll let you know.
The issue seems to be the same for all of them, but with slight differences. All of them identify the error as being related to the `=` signs used.
In one formula box, I have:
Sum(Filter('Leave Balance',LeaveId=ThisItem.LeaveId),'Total Leave')-Sum(Filter(LeavesAppliedByUsers,LeaveId.Value=ThisItem.LeaveId && RequestedBy.Email=User().Email),TotalDays) &" Days"
When I hover over the first `=` sign, ('Leave Balance',LeaveId=ThisItem), it comes up with ‘Delegation warning. The highlighted part of this formula might not work correctly on large data sets. The “Sum” operation is not supported by this connector.
Incompatible types for comparison. These types can’t be compared: Record, Record.’
When I hover over the second `=` sign, (LeavesAppliedByUsers,LeaveId.Value=ThisItem), it comes up with ‘Delegation warning. The highlighted part of this formula might not work correctly on large data sets. The “Sum” operation is not supported by this connector.
Incompatible types for comparison. These types can’t be compared: Text, Record.’
Then at the very bottom of the formula bar it says – ‘ “ Days” = There is an error in this formula. Try revising the formula and running it again.’
And in another formula bar, I have:
ClearCollect(LeaveSum,Sum(Filter(LeavesAppliedByUsers,LeaveId.Value=Gallery5_1.Selected.LeaveId && RequestedBy.Email=User().Email),TotalDays));
ClearCollect(TotalLeave,Sum(Filter( 'Leave Balance',LeaveId=Gallery5_1.Selected.LeaveId),'Total Leave'));
When I hover over the third `=` sign, (LeavesAppliedByUsers,LeaveId.Value=Gallery5_1) it comes up with ‘Delegation warning. The highlighted part of this formula might not work correctly on large data sets. The “Sum” operation is not supported by this connector.
Incompatible types for comparison. These types can’t be compared: Text, Record.’
When I hover over the fourth `=` sign, ('Leave Balance',LeaveId=Gallery5_1), it comes up with ‘Delegation warning. The highlighted part of this formula might not work correctly on large data sets. The “Sum” operation is not supported by this connector.
Incompatible types for comparison. These types can’t be compared: Record, Record.’
As I’ve said, any help would be greatly appreciated. Apologies if any similar questions to this have already been posted and answered, I’ve had a look around and I couldn’t find anything, but I might have just missed something.
