cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dan47
Helper V
Helper V

Filter Multiple List Values for Action

Hi There

 

We got a Shrepoint List with a lot of entries.

 

How do I run a flow to get changes and then filter for two list item values in order to determine which action to add afterwards.

 

My Flow:

Dan47_0-1638805840178.png

At the moment I get this error:

 

The expression "(Completedeq 'Completed') and ({"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":47,"Value":"Archiv"}eq 'Holzbau3')" is not valid. Creating query failed.

Thanks for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Dan47 

 

Couple of things to check here.

 

1. Above you mentioned (Completedeq 'Completed') Make sure there is a space before the eq

2.  Watch my tutorial Power Automate - How To Filter SharePoint Lookup Column - YouTube



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

7 REPLIES 7
abm
Super User
Super User

Hi @Dan47 

 

Couple of things to check here.

 

1. Above you mentioned (Completedeq 'Completed') Make sure there is a space before the eq

2.  Watch my tutorial Power Automate - How To Filter SharePoint Lookup Column - YouTube



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Dan47
Helper V
Helper V

Hi @abm 

Seems like it worked.

The values are right now. 

I will proceed with building my flow and get back to you if there is any issue with the filter.

 

Hi @Dan47 

 

Thanks for the update. Could you please mark it as solution accepted as it helps others when they looking for solutions.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Dan47
Helper V
Helper V

Hi @abm 

Somehow my flow gets mixed up with the column value and the column name.

I built this flow and I get this error:

Column 'Creating' does not exist. It may have been deleted by another user.

Dan47_1-1638886744417.png

 

Dan47_0-1638886673988.png

 

 

That could be someone renamed the existing column. Go to the settings of the list. Click the column Creating. Check the URL and at the end of the url it will show you the original schema name of the column name.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Dan47
Helper V
Helper V

Hi @abm 

 

Thats the point: The column is called "Status" and the value is "creating".

 

The flow got this mixed up.

Dan47
Helper V
Helper V

I found out what was the Problem: I used dynamic values:

If I write it out it workes fine:

Dan47_0-1639053875671.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,613)