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

Filter Query - SharePoint Get items

This is similar to other posts in here, but none of the advice seems to work in this case.

 

The flow is triggered on receipt of an email, sent from the Azure portal.  It strips out the email address and the application name the user is applying to use. 

in a nutshell: 

The get items is to check AppName against a sharepoint list.

If it exists - email back with a response why that app is denied

If it doesn't exist - email back a response requesting more info.

Flow1.jpg

 

 

If i use the object in the Filter - it returns an error: 
flow2.png

 

If I hard code the Filter Query:  Title eq 'actual application name'

 

Nothing happens. 

flow3.jpg

the condition isn't triggering.....

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

 

Hi @grantreid ,

 

Please run Get items action without configuring Filter Query to get the actual name of the column.

And you could configure the condition outside Apply to each as follows:

18.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Super User II
Super User II

please @grantreid  use quotes like this

date.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

yep, using quotes as; Title eq 'actual application name'

That's when I hard code the app name...    

 

the actual desired method is using the output from the previous steps, but that gives me the errors as shown in my original post.

 

 

please see if in your list configuration you have the correct column name

see.PNG

 

and please don't use white spaces



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Community Support
Community Support

 

Hi @grantreid ,

 

Please run Get items action without configuring Filter Query to get the actual name of the column.

And you could configure the condition outside Apply to each as follows:

18.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

yeah, not solved..  Was dragged on to something else, so didn't have a chance to reply.

Removed the filter as suggested, the output of the flow is has :

 

{
  "@odata.nextLink": "
  "value": [
    {
      "@odata.etag": "\"1\"",
      "ItemInternalId": "1",
      "ID": 1,
      "Title": "FirstAppName",
      "Risk_x0020_Rating": {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
        "Id": 0,
        "Value": "Low"
      },
      "Risk_x0020_Rating#Id": 0,
      "Status": {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
        "Id": -1,
        "Value": "Not started"
      },
      "Status#Id": -1,
      "Application_x0020_ID": "6da7da9b-a02f-4ac4-bee6-81ac1d6c76e9",
      "Modified": "2020-03-31T01:35:15Z",
      "Created": "2020-03-31T01:35:15Z",

 

So "Title"  is the actual name on the column?

In the flow itself, if I put:

 
 

I get and error: "Column 'Blah app name' does not exist. It may have been deleted by another user."

 

If i put quotations around "Title", that obviously fails as well.
The $filter expression ""Title" eq Blah app name'" is not valid. Creating query failed.

 

and the condition below already has the expression, it's not even getting that far before failing....

 

There are over 1000 items in this sharepoint list. I only want to check if the string AppName exists in a single column or not. 

 

Hi @grantreid ,

 

Please add a single quote outside Outputs. Maybe you could use substringof() to filter items.

Please check this article:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (38,401)