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

Get Items Filter not working

Hello good day!.

 

A few months back I created an item here as I was having issues with the get items filters, thanks good someone replays back very soon with the solution and I went able to resolve the problem. No more issues with the item in the future and used to work perfectly in all the flows that I created since then, until today. Let me explain the scenario. I have a SharePoint list and one excel file. The idea is compare both items and if one record in the excel file is not present in the SharePoint list, then I create a new record. In the other hand if exist then I do the updates. For comparison I use one numeric (also try with the email) field, however when I try to used to used the filter of the get items field seems that is not working; however I'm not getting any error just return an empty record when is clear that the item exist in the list. Below an example on how I setup the filter and what returns. 

 

crirojsab_0-1668788792139.png

 

crirojsab_1-1668788872248.png

 

May I know what I'm doing wrong? Tried all the different options and always return empty data for all the records, even when the record exist in the SharePoint list and has their counter part in the excel file. 

 

Regards.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

Is there are record in the list where the ID is 10030064?  That's the only other reason I can see for it to return no records.



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

View solution in original post

6 REPLIES 6
Pstork1
Dual Super User
Dual Super User

If its a numeric field then you shouldn't have the single quotes around it.  Also you should list the field name first and the field value your checking second.



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

Hi @Pstork1 

 

Thanks a lot for the quick replay. I ran to do the changes that you suggested but I'm still  having the same issue. Get Items is returning pure blanks, and when download the outputs I get this at the end 

"body":{"value":[]}}

Below the screen shoots. 

 

crirojsab_0-1668791529052.png

 

Regards

 

run it once without the filter query.  See what Career_x0020_Settings_x0020_ID is equal to. that will tell you if you are trying to match the right value.



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

Hi @Pstork1 

Did what you suggest and pass the results in a Compose to check the data and yes this is the correct field. Attach one extraction of the output:

{
"@odata.etag": "\"6\"",
"ItemInternalId": "2",
"ID": 2,
"Career_x0020_Settings_x0020_ID": 150036,
"Business_x0020_Title": "Senior Account Manager - L3",
"Email": "xxxxx@xxxx",
"Most_x0020_Recent_x0020_Hire_x00": "2019-01-07",
"Status": "Completed",
"Completion_x0020_Date": "2022-08-03",
"Comments": "Record Updated by  - Completed",
"Modified": "2022-11-16T21:53:13Z",
"Created": "2022-11-15T22:33:08Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|xxxxx@xxxxt",
"DisplayName": "crirojas",
"Email": "xxxxx@xxxx",
"Picture": "",
"Department": "Technology",
"JobTitle": "Senior Project Manager"
},

 

Regards, 

 

Pstork1
Dual Super User
Dual Super User

Is there are record in the list where the ID is 10030064?  That's the only other reason I can see for it to return no records.



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

Hi @Pstork1 

Thanks for the hint. Spend the last few hours checking the records in both items. The excel file and the list against the results in the Apply to Each and yes found inconsistencies in the files, and also find records where the filter works. So I believe we found the problem. Thanks for the help!!

 

Warm Regards

Cristian

 

Helpful resources

Top Solution Authors
Top Kudoed Authors
Users online (4,088)