Answered

To check if list doesn't start with specific text values

(0) Share

Report

Posted on by ayush1tyagi

Hello

I have a list containing only one row sometimes two rows . What i want is to check if list doesn't start with these specific text values (Commerce/DC4Router) then i need to perform some actions

Till now this i have tried but it doesn't work as this condition works when list start with Commerce/DC4Router values

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (1)

Sort by

eetuRobo 4,545 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Now your flow will only check first item in the list. If it sometimes has two you should go through it with For each loop.
Also the If checks if the List item starts with 'Commerce OR DC4Router' -text. So it checks if the text also has OR in it.
Correct syntax I think would be: %'Commerce' OR 'DC4Router'% but I think it doesn't let you do OR statement with text value.
So I recommend just doing
If starts with Commerce
Else if starts with DC4Router

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
The correct way to do this is using a statement like this:

The syntax in the IF statement looks like this:

What's important here is as follows:

You must define each condition around the OR operand separately. So, on both sides of the operand, I check if %List[0]% does not start with a certain string.

In order to be able to use the OR operand, you must use the special expressions as show below. NotStartsWith() is the expression for checking if a value does not start with another value. There are three parameters for the NotStartsWith() expression:

The target value (%List[0]% in your case)

The value to check for (the strings you are looking for)

A boolean value to indicate whether the check should be case sensitive or not. False indicates case sensitive (i.e. "Ignore case" = False)

You must put %True% as a boolean in the second operand to check if the first operand returns true.

Here's a snippet of the entire code for you to copy and paste into your flow designer to get the actions generated:

IF (NotStartsWith(List[0], 'Commerce', False) OR NotStartsWith(List[0], 'DC4Router', False)) = True THEN EXIT FUNCTION END

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
ayush1tyagi 43 on at

Like (0)

Report
Copy link

Link copied!

Both provided solution are not working the list runs the condition each time whenever it get populated

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @ayush1tyagi

I noted that you have said it is list of rows, so you want to check whether the list starts with specific word , in other words you want to check whether the list first row first column starts with a text , Hope i am right

If that is the case, then try the below expression

Here List[0] represent first row, then List[0][0] represent first column of first row which we want to check whether it starts with specific word or not 🙂

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
ayush1tyagi 43 on at

Like (0)

Report
Copy link

Link copied!

No success still whenever the list gets populated the conditions are satisfied each time

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ayush1tyagi

I did not get what you said Also could you show how the list looks like ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

I don’t think the OR is working right.

nest them

if doesn’t start with commerce

If doesn’t start with dc4 router

‘Do something

End (if)

end (if)

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Nived_Nambiar 's suggestion is a good idea if your list is not really a list, but instead a data table with columns. It's just missing some parameters in the statement.

It could be done like this:

Or, if you reverse this to use StartsWith() then you need to put in %False% in the second operand.

It's a bit hard to understand what it is that you are trying to achieve here, without really seeing some sample screenshots of your flow and your data. It would be great if you could show us what the values of the list look like during runtime.

@MichaelAnnis , it can definitely be done with an OR statement and there is no need to build nested Ifs. It just needs to be done right based on the underlying data.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
ayush1tyagi 43 on at

Like (1)

Report
Copy link

Link copied!

I have found a workaround in my flow for now will circle back to this logic of list if that doesn't work in future

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Feel free to share your workaround and accept it as a solution, so the topic is closed and others can also find it, if they have a similar issue.

Was this reply helpful? Yes No