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'))
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.
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.
Solved! Go to Solution.
Hi @Anonymous,
If the data type for days column is choice column,please choose the "Days Value" equal to string(30) expression as below:
string(30)
And the flow would run successfully as below:
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.
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?
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
Proud to be a Flownaut!
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 image
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
Proud to be a Flownaut!
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?
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
in the left box - Put your expression but remove the @
Thanks, Alan
Proud to be a Flownaut!
@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.
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.
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. So here is the complete Flow after it has run successfuly then I will break it down for you.
Starting with the below as you have
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 1
and(equals(items('Apply_to_each')['date'], '2019'),equals(items('Apply_to_each')['accountName'], 'hihi'))
Branch 2
and(equals(items('Apply_to_each_2')['date'], '2020'),equals(items('Apply_to_each_2')['accountName'], 'hi there'))
Branch 3
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
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(30) expression as below:
string(30)
And the flow would run successfully as below:
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.