PowerAutomate - my flow condition always shows false

[PowerUser19]

Hi there, I am trying to create a flow to update SharePoint item based on the condition. Sharepoint fields used to check

1. Disposal Date - Date less than current date

2. Status - Choice column - Disposed/Not Disposed

For items items with disposal date less than current date and Status equal "Not Disposed", I am trying to update the OverDue Status (Single line of text in SharePoint) as True. But my condition always fails even if the above conditions satisfy. 

I used "Status Value" as well to check the condition.

[PowerUser19]

Here are the screenshots of my trials. Can I please get help to resolve this issue?

[MarconettiMarco]

Hello @PowerUser19 ,

the parameter to be put in the Condition is case sensitive, so please be sure to insert the right state value.

In addition, I suggest to:

- use the formatDateTime expression also for the Disposal Date

- enable the Power Automate setting “experimental features”, so that you can apply the SP filter query in a more friendly way without the need to use the “Condition” control.

BR,

Marco

[v-peijunz-msft]

Hi @PowerUser19,

Could you please show a screenshot of your SharePoint list?

I agree with @MarconettiMarco that the parameter to be put in the Condition is case sensitive.

Does your Status column have "Not Disposed" choice or "NOT Disposed"?

Please check the correct name with case sensitivity in your SharePoint list.

In addition, please also check if there is any space before or after "Not Disposed" in your Compose action.

It would show false if there is any extra space even if the above conditions satisfy.

Based on your description, I have made a simple test for your reference.

1. I have a SharePoint list called Reminder, and there is a Date and time column (Due Date), a Choice column (Status), and a Single line of text column (OverDue Status).

2. Here is my flow:

formatDateTime(utcNow(), 'yyyy-MM-dd')

3. Result Screenshot:

Best regards,

Sylvia

[PowerUser19 · Accepted solution]

Hi @v-peijunz-msft ,

Thank you so much for the example. The text that I have used is exactly same in the SharePointlist. For some reason, the test condition wasn't satisfied. Before you provided the solution, I added both the conditions in the filter query which solved my issue. Thank you so much again for your suggestion and ideas.