Using Power Automate for a SharePoint List - Get Items - Filter Query

(0) Share

Report

Posted on by Manny123

158

Hi Team,

I was wondering if you could help.

I have a SharePoint List and a Powerapps which tracks IT issues. The app is working great. However my team want to see weekly or daily workflows on current IT issues status. sent to our manager by email.

So I have started to use Power Automate using the SharePoint list which holds the data.

I have managed to get HTML table working on the email. Currently I have only setup as a manual process.

However the data on the email shows ALL IT issues logged. I ONLY want to see where the status is In Progress.

I have tried to use the advanced options in "Get Item" using the Filter Query but each time I enter the column name the workflow fails.

I am using: Status eq 'In Progress'

I am not sure what I am doing wrong. The Status column in my SharePoint and Powerapps is a Choice menu. I have tried to also:

Status Value eq 'In Progress'. But again the flow fails.

I was wondering if there is a way to show in an email ONLY tickets with status In progress?

Any help much appreciated.

Thanks.

Categories:

Building Power Apps

power automate fl...

Flter Query.png

I have the same question (0)

All responses (4)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @Manny123

Your code/syntax is fine.
ColumnName eq 'StringValue'

In this example, Filtering the status called New and works. I downloaded and validated it as well.

Can you please validate the column name? Sometimes Status is a display name but the actual name might be different.

Go to the list settings
Click the column
View the actual name in the address bar

Thanks,
Stalin - Learn To Illuminate

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
Verified answer

Manny123 158 on at

Like (0)

Report

Hi Stalin,

Thats Brilliant! Thanks for that. It works! I was using a different name. I assumed it was called "Status" but on the URL the column is called "QueryStatus".
Is there a way to show the date field to show the correct format? I want to show the "Date Due" column in DD/MM/YYYY format (if possible).
Currently showing in the format attached. I think its showing time within a time zone.

Screenshot 2021-1...

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Yes, time shows with UTC. I assume you are displaying it in the Data table. We can convert the format.
Text(ThisItem.'Date Due',"dd/mm/yyyy")

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @Manny123

Glad to know the issue has been fixed. If you don't mind, please accept as a solution that the post I posted/responded so that it helps to find the right answer quickly.

Thank you again.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No