cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
d_Larbalestier
Frequent Visitor

Filter - startswith not working

Hi

 

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

 

d_Larbalestier_0-1644237327136.png

Any ideas?

 

Thanks

 

Dan

1 ACCEPTED SOLUTION

Accepted Solutions

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.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

3 REPLIES 3
d_Larbalestier
Frequent Visitor

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

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.

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
Frequent Visitor

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,132)