Filter - startswith not working

[d_Larbalestier]

Hi

I have the following filters. The else condition works perfectly. The IF condition containing StartsWith( Isn't filtering the results. 

Any ideas?

Thanks

Dan

[d_Larbalestier]

Also, StartsWith( works fine without GUID filtering. the problem obviously lies there but, i can't work out what it is.

Thanks in advance

Dan

[v-jefferni · Accepted solution]

Hi @d_Larbalestier ,

Could you please share more details? What do you mean by "Isn't filtering the results"? No result returned at all or the result is not correct?

Anyways, you can try and use With function to divide the StartsWith part condition:

With(
     {TmpTbl: Filter(Sort(...),...)},
     Filter(TmpTbl, StartsWith(...))
)

Use this formula to replace true value of the If statement. The two filers could be exchanged within the With function.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[d_Larbalestier]

@v-jefferni - thanks for the introduction to the With function. This resolved my issue