Answered

SharePoint Get Items filter not working with Choice field

(0) Share

Report

Posted on by lcasey233

Hello,

I have a really simple get items action that is trying to filter based on a choice field. However I am always getting an error. Is there a different syntax?

BSA_x0020_Contract_x0020_Number/Value eq '@{triggerOutputs()?['body/BSA_x0020_Contract_x0020_Number/Value']}'

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

bradleyhorton 187 on at

Like (0)

Report

Hi @Larry_Casey I might be wrong here, but I don't think you need the /value. I've certainly never used it when filtering on choice columns from SharePoint. I think it's looking for a column heading specifically.

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report

Hello,

But if I don't include the value, then nothing at all gets returned. Even though I have 3 records with that exact number.

Was this reply helpful? Yes No
bradleyhorton 187 on at

Like (0)

Report

@Larry_Casey ahh okay. I just tried to re-create and it returned the 3 items for me. Does it have the same issue if you type the Contract number into the filter than than use dynamic content?

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report

I just found out that Power Automate Odata Filters do not support SharePoint Choice Fields so I cant get this to work. The Contract Numbers are all in lookup fields which wont work with an Odata filter in Get Items.

Was this reply helpful? Yes No
lcasey233 85 on at

Like (0)

Report

The Contract Numbers should be in a Lookup Field. Your List has them as just a text field.

Was this reply helpful? Yes No
Verified answer

bradleyhorton 187 on at

Like (1)

Report

@Larry_Casey was just having a read as was interested and this (message 7) seems to suggest you can ODATA filter on Lookup columns, you just need to point at the lookup column too. It might not help, but thought it was worth mentioning.

https://powerusers.microsoft.com/t5/Building-Flows/ODATA-Filter-queries-on-LookUp-columns-from-a-SP-List/td-p/84882

Was this reply helpful? Yes No
lcasey233 85 on at

Like (1)

Report

Hello I did see that earlier and couldnt get it to work, but it is working now using:
BSA_x0020_Contract_x0020_Number/Title

I had to use the actual field name + add the backslash and enter the actual field name that the lookup column uses.

I am going to accept your post as a solution as you did point out the exact issue I was having. Thanks So Much!!!

Was this reply helpful? Yes No
bradleyhorton 187 on at

Like (0)

Report

Glad you got it sorted, @Larry_Casey

Was this reply helpful? Yes No