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)

Sort by

Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

I was successful with all lowercase startswith

try

startswith(new_name, 'Provos')

Was this reply helpful? Yes No
TomGaz 54 on at

Like (0)

Report
Copy link

Link copied!

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,704 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 54 on at

Like (0)

Report
Copy link

Link copied!

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