Filter not working

(2) Share

Report

Posted on by kat7777777

112

Hello!

I am trying to do a starts with filter in my flow. In my filter query I have a startswith(fieldname, "HiringNumber6") It is working but I have several hiring numbers that are like HiringNumber6-1 for example and it is only pulling one value. How do I get it to pull all of the values including the ones that have additional numbers?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

Comparisons are case sensitive.

Try

startswith(tolower(fieldname), 'hiringnumber6')

If you have large number of data sets then set the pagination threshold.

Thanks

Was this reply helpful? Yes No
Suggested answer

Valantis 1,383 on at

Like (1)

Report
Copy link

Link copied!
Hi @kat7777777,

Your filter startswith(fieldname, "HiringNumber6") is too specific. It's only matching the exact prefix "HiringNumber6" without the hyphen.

Change it to: startswith(fieldname, "HiringNumber6-")

This will pull all records like HiringNumber6-1, HiringNumber6-2, HiringNumber6-10, etc.

The startswith() function matches character-by-character, so including the hyphen captures all the variants you need.

If you also want records with just "HiringNumber6" (no hyphen), use:

startswith(fieldname, "HiringNumber6-") or fieldname eq 'HiringNumber6'

Give it a try and let me know how it works.

Was this reply helpful? Yes No
Valantis 1,383 on at

Like (0)

Report
Copy link

Link copied!

Hi @kat7777777,

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Also, if the issue is resolved, it would be great if you could mark the answer as solved so others with the same question can find it easily.

Thanks and have a great day!

Was this reply helpful? Yes No