I am getting the error that characters are used in an unexpected way.
"For example, the character '\' isn't expected after a number, like this: '32\'. A space ('32') would be expected so that it's just the number 32 or another number (as in '323') would be expected.
Filter('HSS Picksheet020521Z', StartsWith(Title,ResourceDropDown.SelectedText.Value)), If(IsBlank(SerialSearchBox.Text),Filter('HSS Picksheet020521Z','Serial Number'=V1),Filter('HSS Picksheet020521Z',StartsWith('Serial Number', SerialSearchBox.Text)))
Solved! Go to Solution.
If you copied and pasted, check the first isBlank. Make sure it's IsBlank and not Isblank. Surprisingly enough you can get some really strange errors when there are case mismatches in the commands.
Is your SerialSearchBox a simple text input or something else?
You can easily prove what I am saying by replacing that comma with a ';'. The issue is the construction of the statement. The first filter statement is not within the If() so you can't separate it from the other statements with a comma.
This is what ended up working:
<Filter('HSS Picksheet (6)', And(Title = ResourceDropDown.Selected.Result), StartsWith('Serial Number',SerialSearchBox.Text))>
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!