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 |
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 |
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 |
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 |
---|---|
256 | |
107 | |
90 | |
51 | |
44 |