Condition ignoring Yes/No column

[SPowers22]

Hi All,

I've looked at solutions to similar problems that have been posted here and none of them have worked for my flow. 

I have a data set that includes historical and current data (project name, start date, end date). The current data is complete, however, the historical data is missing end dates. The data set is several hundred entries, so I'm building a flow to automatically fill in the missing end dates with today's date. The flow does this without an issue, however I do not want it to overwrite the entries that already have an accurate end date.

To do this I created a 'Known End Date?' column which is a Yes/No column and then told the flow to only change those entries where Known End Date = No and change the Known End Date to Yes. It doesn't work - the flow overwrites all of the dates, even those where Known End Date = Yes. This means the flow is not considering the 'Known End Date' column at all, or it is changing the entries to Yes before changing the dates.

Any ideas how this can be fixed? I've included screenshots of the data and the flow I have created.

Many ThanksFlowBase DataOverwritten Data

[annajhaveri · Accepted solution]

@SPowers22  in the condition provide the value True, from Dynamic Content -> Expressions

[SPowers22]

@annajhaveri Thanks for this. I'd tried all kinds of combinations of expressions that had been suggested on other threads but in the end the solution was really simple!