I am trying to search after 2 posssible columns 'RegNr' and 'Rekvistion Nummer' gallery with sahrepint list data source "Rekviistion"
I need to enter || function in the formula below
SortByColumns(
Filter(Rekvisition; StartsWith('Reg.nr'; tbSearchRekv.Text)); "ID"; Descending)
like that
SortByColumns(
Filter(Rekvisition; StartsWith('Reg.nr'; || 'Rekvisition Nummer' ; tbSearchRekv.Text)); "ID"; Descending)
but it gives error . How can I adjust it
Solved! Go to Solution.
I think something like this would work for your situation - we also should have a check there for when the text is blank so that we don't try filter when its blank:
SortByColumns(
Filter(
Rekvisition;
tbSearchRekv.Text=""
||
(
StartsWith('Rekvisition Nummer' ; tbSearchRekv.Text)
||
StartsWith('Reg.nr'; tbSearchRekv.Text)
)
);
"ID";
Descending
)
@iAm_ManCat |
My blog |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
I think something like this would work for your situation - we also should have a check there for when the text is blank so that we don't try filter when its blank:
SortByColumns(
Filter(
Rekvisition;
tbSearchRekv.Text=""
||
(
StartsWith('Rekvisition Nummer' ; tbSearchRekv.Text)
||
StartsWith('Reg.nr'; tbSearchRekv.Text)
)
);
"ID";
Descending
)
@iAm_ManCat |
My blog |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
It worked likea charm, Thanks for help.
Excellent, glad I could help!
@iAm_ManCat |
My blog |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
User | Count |
---|---|
122 | |
87 | |
86 | |
75 | |
67 |
User | Count |
---|---|
214 | |
181 | |
137 | |
96 | |
83 |