Flow Condition returns False even when matching SP List Items

[CorcoranK]

Hi,

I ran into a bit of an issue with one of my Flows and cannot seem to work it out. The purpose of the Flow is to get all items from a SharePoint List and run a condition on the Flow against the following SharePoint List columns (below) if all are true go email a user.

1. Study Status (Drop down)
2. Questionnaire Status  (Drop down)
3. Next Questionnaire due date (integer)

However, it always returns false even when the list data appears to match. I have checked that the data types match and spellings are correct. Can anyone help advise me on this and help me understand why it never returns true?

Many thanks

[ekarim2020]

Hi @CorcoranK ,

Place the following compose action before the Condition. Then examine the content of the Compose action after the flow has run.

 

What is the expression you are using in the formatDateTime function?

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[CorcoranK]

Hi,

Thank you for the advise. The Compose action returns the first list item values only.  I have 100 items in the list and the condition is always false even when the condition does match the list items which should make the condition true.

The expression being used for time and date function is: formatDateTime(utcNow(), 'yyyy-MM-dd')

Any help would be much appreciated. 

Many thanks

[ekarim2020]

Hi @CorcoranK ,

Can you examine the content of the Compose actions and find examples where the content of the compose action should match as true, but they do not in the condition.

The compose action should have 4 values. You may need to add some characters to separate one value from another for ease of reading.

Make sure that the text and case matches exactly with what is stored in SharePoint. For example, the following text are different because the cases does not match:

Last Questionaire Completed

Last questionaire completed

Also, the does your date column in SharePoint contain time? Example 2023-10-11T09:00:22? The formatDateTime(utcNow(), 'yyyy-MM-dd') expression does not contain time. If the SharePoint column also includes time then you will need to use the FormatDateTime() function to format the SharePoint date so you can compare it with the expression formatDateTime(utcNow(), 'yyyy-MM-dd').

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[ekarim2020]

I forget to add:

For each of the look up columns, use the Value column in your compose and condition checks

1. Study Status (Drop down)  - use Study Status Value 
2. Questionnaire Status  (Drop down) use Questionnaire Status  Value

Example, study status lookup column will resemble something like this:

"Study Status": {
	"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
	"Id": 1,
	"Value": "On follow-up"
	}

So you will want to select Study Status Value from dynamic data, as this is where the value you want to compare is actually stored.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[CorcoranK]

Hi,

Thanks, but I am already using the value column. Sorry, I should have mentioned this before. Tried recreating Flow but same thing happens - condition is always false no matter what is in the SP List. 

[ekarim2020 · Accepted solution]

Hi @CorcoranK 

(1) Please can you show the runtime outputs of the compose action where the content of the compose action should match as true, but they do not in the condition. Please post screenshots of the outputs from the compose action. Can you also post some sample data you are reading from SharePoint?

(2) Simplify: Start with just one condition and test the flow. Do you the results you are expecting?

Then add the next condition and test the flow again. Do you the results you are expecting?

Keep doing this until you find the condition that is causing the issue.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[CorcoranK]

Hi,

Thanks, I found the issue. Get Items only returns the first 100 items as soon as I updated the Top Count number it worked. Your help has been very much appreciated. As soon as I used Compose to break it down the issue became clear,  Thank you very much!