cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to combine two flows into one in below usecase

Hi,

 

I have a simple flow setup that checks if todays date is 120 days from expiration date, along with that also checks if Days column is set to 30 or not in sharepoint list. Below is the flow screenshot.

 

Here is the condition: @AND(equals(items('Apply_to_each')?['ContractExpirationDate'],
formatDateTime(addDays(utcNow(), 120), 'yyyy-MM-dd')),
contains(items('Apply_to_each')?['Days'], '30'))  

Capture.PNG

Now I have an exact same flow and condition for second flow is as below:

@AND(equals(items('Apply_to_each')?['ContractExpirationDate'],
formatDateTime(addDays(utcNow(), 60), 'yyyy-MM-dd')),
contains(items('Apply_to_each')?['Days'], '30'))

 

So basically I have two separate flows that checks if Days column is set to 30 and then checks the date logic, if both are true then sends an email out. Notificaton 1 goes out 120 days prior(flow 1), notification 2 60 days prior(flow 2). I would like to combine these two flows into one but with the new condition layout of flow, advanced mode is gone so its kind of confusing. I tried to configure additional condition control in NO case of first condition and had issues with new Condition control rolled out from Microsoft.

Capture.PNG

 

Can someone provide me guidance/help on this so that I can just have one flow, please share screenshots, would like to see how the New condition control will be used without advanced mode leveraging my formula. Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous,

 

If the data type for days column is choice column,please choose the "Days Value" equal to string(30expression as below:

string(30)

Capture.PNG

 

And the flow would run successfully as below:

Capture.PNG

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

10 REPLIES 10
AlanPs1
Resident Rockstar
Resident Rockstar

Please check here or here for a solution.

"Enter your expression on the left side of the row. Then, select Equals to and enter true."

 

So what used to be:

 

Has now become:

If helpful, please mark with thumbs up.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Anonymous
Not applicable

Thanks Alan, but that does not help constructing my solution. I tried below but the flow fails, it says 'no actions failed, no dependent actions executed'. Coule you help me with a solution here?

 

Capture.JPG

AlanPs1
Resident Rockstar
Resident Rockstar

Hi @Anonymous

 

You had said "So basically I have two separate flows that checks if Days column is set to 30 and then checks the date logic, if both are true then sends an email out. Notificaton 1 goes out 120 days prior(flow 1), notification 2 60 days prior(flow 2). I would like to combine these two flows into one but with the new condition layout of flow, advanced mode is gone so its kind of confusing. I tried to configure additional condition control in NO case of first condition and had issues with new Condition control rolled out from Microsoft."

 

If your "Condition 2" was configured in the way I have suggested (It will make it like condition 1) then doesn't that meet the requirements of what you are asking?

 

Based on your last reply "I tried below but the flow fails, it says 'no actions failed, no dependent actions executed"

 

I can try and look at that with more information but maybe an idea would be for you to implement both  the conditions in the same way and see if there is any change ... after the whole "new condition format" scenario has been addressed I will be sure to assist with your overall Flow.

 

Do you get what I am asking here?

 

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


AlanPs1
Resident Rockstar
Resident Rockstar

So just to be clear ...

 

Condition 2 to be the following if you want it to be the same

 

AND(equals(items('Apply_to_each')?['ContractExpirationDate'],
formatDateTime(addDays(utcNow(), 60), 'yyyy-MM-dd')),
contains(items('Apply_to_each')?['Days'], '30'))

equal to 

$true (expression) to match the below imageCapture-038.png

or, much link @faustocapellanj's post you will find here try put each expression in a single row and make equal to true.

 

Worth a go?

 

If you found this helpful please mark as thumbs up.

If this is the solution, please mark as the solution.

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Anonymous
Not applicable

Thanks Alan. What is the purpose of using the not empty? I mean i am not really storing any item info in Array, so not following the create html table if array not empty condition. Do I have to use it anyway? 

AlanPs1
Resident Rockstar
Resident Rockstar

The not empty is an example from another Flow, If you follow the trail you will see it links to one of my blog posts/tutorials that uses that.

You will not use that expresion, you will use your own expression but implement it in the same fashion that I have. Does that make sense?

Use the following image as a guide but use your own logic

Capture-038.png

in the left box - Put your expression but remove the @

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Anonymous
Not applicable

@AlanPs1 I had to change my formula to make it work in the new condition control. The formula that I was using in advanced mode does not work.

Capture.PNG

The flow works fine but I am seeing an issue. You can see second condition where days is selected as data card,  if the data type for days column is number then it works well but I had issues when using choice column as data type for Days column. I tried Days equal to 30, Days Value equal to 30, tried contains instead of equals but it does not work. Any ideas?

 

P.S: Noticing one more behavior, my choice column choices are as follows: 30,60,90 and flow does not read that. Once I change it to test30,test60,test90, it then works. I Used Days value equals to for this testing.

 

AlanPs1
Resident Rockstar
Resident Rockstar

Hi @Anonymous

Based on what it looks like you are trying to achieve I have taken a diferent approach and please have a look at this as a solution for you.

I will utilise the above technique of setting an expression equal to true and will also demo how to use a parrallel branch as I think this more suits your needs.

I have a Sharepoint list that looks like the below and I am running conditions on 2 columns (date & accountName) to demonstrate the potential power and customisation of this approach. Capture-066.pngSo here is the complete Flow after it has run successfuly then I will break it down for you.Capture-065.png

 Starting with the below as you haveCapture-067.png

 And then adding a parallel branch, in my example I am using 3 branches to cater for the years in my list, 2019, 2020, 2021 much like your 30, 60, 90.

 

Branch 1Capture-068.png

 

and(equals(items('Apply_to_each')['date'], '2019'),equals(items('Apply_to_each')['accountName'], 'hihi'))

 

Branch 2Capture-069.png

 

and(equals(items('Apply_to_each_2')['date'], '2020'),equals(items('Apply_to_each_2')['accountName'], 'hi there'))

 

Branch 3Capture-070.png

 

and(equals(items('Apply_to_each_3')['date'], '2021'),equals(items('Apply_to_each_3')['accountName'], 'yoldi yo'))

 

Summary

I see you are using some sort of date comparison, you can change the expressions above to suit your own. My Branches and the conditions/Apply to each actions within each branch means that from the 10 entries in my list (above), 3 emails are generated. 

Email 1 - Matches '2019' & 'hihi'

Email 2 - Matches '2020' & 'hi there'

Email 3 - Matches 2021 & 'yoldi yo'

So every day (or however often you set your recurrence) this Flow will send emails to alert there are matches to each branches chriteria.

 

If you, the reader has found this post helpful, please help the community by clicking thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Hi @Anonymous,

 

If the data type for days column is choice column,please choose the "Days Value" equal to string(30expression as below:

string(30)

Capture.PNG

 

And the flow would run successfully as below:

Capture.PNG

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

@v-yuazh-msft thanks, that is exactly what I was looking for.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,260)