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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,466)