web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to write a startsw...

Power Apps

Unanswered

How to write a startswith statement with mismatching data types

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi,

I have the following 'StartsWith' function in my filter function :

StartsWith(
 'Monthly Cost',
 TextSearch.Text)

The 'Monthly Cost' is a number and the 'TextSearch is text.

How do I make this function work?

Regards,

Daniel

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Anonymous

You can call the Text function to convert 'Monthly Cost' to text. However, the disadvantage of this is that it results in an expression that is not delegable.

StartsWith( Text('Monthly Cost'), TextSearch.Text )

Was this reply helpful? Yes No

Join the conversation