Issue with ODATA Filter in Get Items

[TFranchina]

Hello,

In a flow, I need to Get items from a Sharepoint List and apply a FILTER ODATA to identify the single item in this list matching the variable value extracted from a pdf via AI builder.

I use the syntax: Lot# (Name of the column in SP List) eq COAExtLot# (name of the variable containing the value extracted from AI builder).

When testing the flow i get the following error, while i confirmed the values are identical on both side : 00033033

I suspect this is linked with a formatting error. I suspect the eq operation does not recognize both elements as identical due to string/number/text format.

Any idea for solution will be highly appreciated.

Thanks in advance

Thomas

[Pstork1 · Accepted solution]

Take a look at the settings for the Lot# column.  Normally special characters aren't allowed, so I suspect the actual name of the column is Lot followed by an encoded representation of the #. You should be able to see the internal column name in the URL of the column settings if its SharePoint.

[TFranchina]

Hi Pstork1,

Thanks for the insight. I was not aware SP columns were not processing symbols so easily. 

I removed the # in the column name and everything works 👍

Best