Forum Discussion
Incompitable types of comparison. These types can't be compared: record,record
Incompitable types of comparison. These types can't be compared: record,record.
Sum(
Filter('Balance Leave', LeaveId = ThisItem.LeaveId),
'Total Leave'
) - Sum(
Filter(
LeaveAppliedUsers,
LeaveId.Value = ThisItem.LeaveId && RequestedBy.Email = User().Email
),
TotalDays
) & " Days"..
Please help with this
1 Reply
It seems like you're encountering an error related to comparing incompatible types in PowerApps, specifically regarding comparing records.
The error message suggests that there is an attempt to compare two records that have incompatible types. This typically happens when you're trying to compare different types of records, such as comparing a record from one data source with a record from another data source.
In your case, the issue seems to be related to comparing records from different tables ('Balance Leave' and 'LeaveAppliedUsers').
To resolve this error, you need to ensure that you're comparing fields of the same type. Here's a breakdown of your formula and potential areas to check:
1. **Filter Conditions**: Review the conditions inside the Filter function to ensure that you're comparing fields of compatible types. Make sure that 'LeaveId' is of the same type in both tables ('Balance Leave' and 'LeaveAppliedUsers').
2. **Comparison Operators**: Verify that you're using comparison operators appropriate for the types of data you're comparing. For example, if 'LeaveId' is a text field, use the "=" operator for comparison.
3. **Data Source Alignment**: Ensure that the fields you're comparing are aligned between the two data sources ('Balance Leave' and 'LeaveAppliedUsers'). If the fields have different names or types, you may need to adjust your formula accordingly.
Without seeing the full context of your app and data model, it's challenging to provide a specific solution. However, reviewing the above areas should help you identify and resolve the issue with comparing incompatible types in your PowerApps formula. If you need further assistance, please provide more details about your data model and the specific comparison you're trying to make.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
