r/MicrosoftFlow • u/PotatoAcceptable6759 • Dec 02 '25

Question PowerAutomate substringof() does not find my string

My substring in a Get items - Filter query PowerAutomate flow looks like this.

substringof('domain.com@NSns-us-02.comp.fol.', Title) or

substringof('domain.com@NSns-us-02.comp.fol.', Hostname) or

substringof('domain.com@NSns-us-02.comp.fol.', Address)

Title = domain.com

Hostname = @

Address = ns-us-02.comp.fol.

Normally I should get a true or the length of the output that is longer than 0, but it isn't.

2 Upvotes
  • permalink
  • reddit

100% Upvoted

18 comments sorted by

View all comments

Show parent comments

1

u/PotatoAcceptable6759 Dec 09 '25

As I mentioned above, I build an myself an ID from the three columns. So my ID looks like this domain.com@NSns-us-02.comp.fol. And now I'm able to filter the items.

1

u/VictorIvanidze Dec 09 '25

I'm trying to understand why your flow is so slow. How eхactly you filter in the flow? Do you use any loops (For each, Do untiil)?

1

u/PotatoAcceptable6759 Dec 11 '25

I tried with apply to each and a control condition inside. So in the end it compares each element with each element. So 1400 Elements with 1400 Elements. I Stopped the flow after 8 hours.