cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerUser19
Helper III
Helper III

PowerAutomate - my flow condition always shows false

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
PowerUser19
Helper III
Helper III

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.

View solution in original post

4 REPLIES 4
PowerUser19
Helper III
Helper III

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

PowerUser19_0-1660479688489.png

PowerUser19_1-1660479705482.png

 

PowerUser19_2-1660479730654.png

PowerUser19_3-1660479822222.png

 

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
Microsoft
Microsoft

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.

vpeijunzmsft_0-1660635417542.png

 

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).

vpeijunzmsft_1-1660635417562.png

2. Here is my flow:

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

vpeijunzmsft_2-1660635417566.png

vpeijunzmsft_3-1660635417569.png

vpeijunzmsft_4-1660635417572.png

3. Result Screenshot:

vpeijunzmsft_5-1660635417574.png

 

Best regards,

Sylvia

PowerUser19
Helper III
Helper III

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.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,640)