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

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
v-bacao-msft
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
ChristianAbata
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
v-bacao-msft
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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (43,106)