Hello guys,
I am struggling to get this one working. I have already searched a lot but cannot find the solution. This is the code I have right now in the "Items" of a gallery:
Filter(
SPList,
Or(
StartsWith(
Title,
txtInputInvSearchBar.Text
),
StartsWith(
'Group No.',
txtInputInvSearchBar.Text
),
'Invoice Amount' = Value(txtInputInvSearchBar.Text)
) And (StartsWith(
'Group Administrator'.DisplayName,
txtInputUserFilterInv.Text
) And 'Amount Received' = Blank() And 'Revised Invoice' = false)
)
I am trying to filter the gallery based on the information entered in an input text box.
The idea is that the user can filter by "Invoice No" OR "Group No" OR "Amount". The first two columns are text and the last one is a number.
Right now, my code only displays results where the text entered into the input text box has an exact match with the amount. However, if I start typing "T", which is the first letter of one of my invoices, the gallery displays no records.
I don't understand what I am doing wrong, if the conditions are in an OR statement, the system should display info because the "T" in the input text matches one of the OR statements.
Extra info:
- Data source is a SharePoint list
- Delegation must be taken into consideration as I have more than 2,000 records
- I tried a workaround where I created a separated input text box to handle only the "Amount" filter condition, and adding an AND statement. It works, but I would really prefer to avoid this route, if possible, to enhance the user experience.
Your help would be really appreciated.
Thank you 🙂
