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 (2)

Answers (0)

Suggested answer

Valantis 698 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
Suggested answer

abm abm 32,971 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