Get Items in powerautomate, filter the choice column

(1) Share

Report

Posted on by CU27091523-0

On or before 02 September 2024, I am able to use Status eq 'Draft' to filter the sharepoint list in the Get Items

however, without any changes, this filter is no longer working anymore and return nothing to me.

the Status is a choice column, is there a changes on the filter way?

my data is something like this

"@odata.etag": "\"147\"",
"ItemInternalId": "85",
"ID": 85,
"Title": "Try123",
"Payee": "Eyrhch",
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 3,
"Value": "Draft"
},
"Status#Id": 3,
"Currency": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "HKD"
},
"Currency#Id": 0,
"PR_x002d_Code": 1,
"Exemption": false,
"AccountNo_x002e_1": "111111-111",
"AccountNo_x002e_1Amount": 120,
"AccountNo_x002e_2Amount": 0,
"TotalAmount": 120,

Categories:

Building flows

2024-09-27 233302...

I have the same question (0)

All responses (3)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

It's hard to offer any recommendations without seeing your full flow and the logic behind it. If you are using the new designer, toggle it off and click each action to expand it. Upload a screenshot of your flow in edit mode.

If you have more than 100 items in your SP list, you will need to toggle on pagination and set a threshold. The Get Items action returns 100 items per call by default, if you want more items returned per call you'll need to toggle on pagination and set a threshold. The threshold max is 5000.

In the meantime, you might be interested in these YT Tutorials:

How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.

First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.

IN THIS VIDEO:
✅ How to send multiple list items in a single email with a Power Automate Flow
✅ How to create a dynamic date range
✅ How to use the Convert Time Zone action
✅ How to use a Filter Query in the Get Items action
✅ How to count number of items in an array
✅ How to use the Select action to extract a users display name and email address
✅ How to create a unique list of email addresses
✅ How to use the Create HTML Table action
✅ How to customize the HTML Table with CSS styles
✅ How to use the Send an email (V2) action
✅ How to use the Append to String Variable action
✅ How to create a custom list of items for an email
✅ How to use the Send an email (V2) action
✅ How to display singular or plural text based on the number of items returned

----

5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:
✅ How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
✅ How to troubleshoot a skipped Apply to Each action
✅ How to troubleshoot a Filter Query
✅ How to use a SharePoint yes/no column in a Filter Query
✅ How to use Compose actions to troubleshoot a Power Automate flow
✅ How to troubleshoot multiple emails being sent
✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

Was this reply helpful? Yes No
CU27091523-0 4 on at

Like (0)

Report

my set up is quite simple, since the result come out nothing, so I am in the debugging progress and added the termination command.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

What's the output of the expression here? Can you upload a screenshot of this action expanded in your last flow run?

Was this reply helpful? Yes No