Get Items Filter not working

[crirojsab]

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. 

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.

[Pstork1]

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.

[crirojsab]

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. 

Regards

[Pstork1]

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.

[crirojsab]

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 · Accepted solution]

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.

[crirojsab]

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