OdataFilter with startsWith() doesn't work within Dataverse List rows

(0) Share

Report

Posted on by TomGaz

Hi,

I've got Dataverse table Orders with field Name.

And I've got flow with DV action List rows. I made OdataFilter which works. This is orders DV table

and I need another condition, that if field Name startsWith 'Provoz'.....

But when I try set expression startsWith(new_name, 'Provoz') still I got expression invalid.

All the modifications of the startsWith function that I tried and all of them returned an invalid expression:

startsWith(new_name, 'Provoz') - logical namestartsWith(new_name, "Provoz")
startsWith(new_Name, 'Provoz) - schema namestartsWith(new_Name, "Provoz")
startsWith(Name, 'Provoz') - name of fieldstartsWith(name, 'Provoz')

Can anyone advise me where I am making a mistake? I am out of logical ideas.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Building with Why 351 Super User 2025 Season 2 on at

Like (0)

Report

I was successful with all lowercase startswith

try

startswith(new_name, 'Provos')

Was this reply helpful? Yes No
TomGaz 24 on at

Like (0)

Report

Hi @Building with Why,

thanks for replay.

I try your suggestion. But with the same result. I have no idea where could be problem with expression.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,443 Super User 2025 Season 2 on at

Like (1)

Report

In this case, you cannot include "startswith" as an expression.
Simply enter it in the "Filter rows" field like the other conditions.

Was this reply helpful? Yes No
Verified answer

TomGaz 24 on at

Like (0)

Report

Hi @Chriddle,

yes it is as you write. It is one of the options.I just wanted to avoid "redundant" use of actions in flow.
In my case I've used condition with startswitch - it works here.

What I regret is that I did not find this fact anywhere in the MS documentation - that startswith() does not work in the OdataFilter Dataverse action.

Thanks.

Was this reply helpful? Yes No