Unanswered

Problem with finalising the NO part of a flow

(0) Share

Report

Posted on by critski

I have the following flow

The Yes part of the condition is working fine. But I can't work out how to write the No condition. Effectively I want the flow to send a message confirming that there is nothing required in the upcmoing time frame set in the "ticks" condition. Do I just run a parellel apply to each that has "required eq 0"? I think this is the solution but it seems messy.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Problem with finalising the NO part of a flow

@critski
Hi there! I'm not certain I understand. If it meets the criteria of your condition, it should go down the 'yes' path. If it doesn't, it should go down the 'no' path. Is that not what you are experiencing?

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
critski 34 on at

Like (0)

Report
Re: Problem with finalising the NO part of a flow

The Yes path is basically confined to the binary field being 1
Toilets_x0020_Required eq 1
and the date criteria between today
ticks(formatDateTime(items('Apply_to_each')?['EventDate'],'yyyy-MM-ddThh:mm:ss'))
and
ticks(formatDateTime(addDays(utcNow(),14),'yyyy-MM-ddThh:mm:ss'))
. If the Binary field does not equal 1 then there is nothing for it to use to evaluate the rest of the condition.

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Problem with finalising the NO part of a flow

I think I get it. Apologies if I'm still missing the mark.
Could you initialize a variable, or use Compose to set something for the two dates, and then use those further down in both your criteria and your "no" path?

Just a thought.

-Ed-

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
critski 34 on at

Like (0)

Report
Re: Problem with finalising the NO part of a flow

I think I need to change the filter query in the "Get Items" to filter on the calendar dates. Then change the condition to be whether the resulting binary field is yes or no. Im not sure what the resulting query would be something like this?
Start_x0020_Time le datetime'addDays(utcNow(),14),'yyyy-MM-ddThh:mm:ss')'
I'm a bit sketchy on how to write the query

Was this reply helpful? Yes No
critski 34 on at

Like (0)

Report

Re: Problem with finalising the NO part of a flow

So I've got the flow down to this.
The flow seems to capture all the jobs within the date ranges set but it doesn't seem to like the condition. Everything comes back as FALSE even when there is a TRUE in there.

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Problem with finalising the NO part of a flow

Check the output of your Get Items to verify that you would have a True condition in each instance.

The other thing I've seen is the value for the condition will sometimes need to be an expression. Meaning that where you have "1" (without quotes), switch the input to "Expression" and then just type in 1. See below. I don't know why this works, but it does.

Ignore the variable name, I just used a random Flow.

Keep us posted.
Ed

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
critski 34 on at

Like (0)

Report

Re: Problem with finalising the NO part of a flow

Ive sorted this issue using the following:
The only bit that is wrong here is that the condition field is a true/false and should be set to 'true' not '1'

Was this reply helpful? Yes No