I'm struggling with the Do Until action, and hoping someone can give me some guidance.
My goal is to wait until an "Assigned To" field is populated in a SharePoint list, and then send an email. It seems this should be relatively straight-forward, but my flow is not waiting for the field to be populated. I configured the flow to wait until the Assigned to Email contains the "@" character (I've tried a couple other variations, and also on a text field, and none behave as expected). Below is the configuration of the Do Until step:
Any tips on what I'm doing wrong?
Thanks in advance.
This is probably no help, but maybe someone with Microsoft will see it. In SharePoint designer, if it was a text field you could set it to "Is not empty". That doesn't seem to be the option in Flow though. Maybe that option can be added?
I haven't had to use a "do until" field yet so can't be any help, sorry. Will be following because I know I will need this in the future.
I appreciate that suggestion - that's actually what I've already done. However, I'm trying to learn Flow and would like to build as much as I can with Flow rather than Designer. If I figure find a solution outside of this thread I'll be sure to post an update for you.
Could you please take a try to switch the Do until condition in Advanced mode, then modify the formula as below?
Not( Empty(TriggerBody()?['Assigned_x0020_To']?['Email']) )
Please modify the field ( example:
) with the one showing under the Advanced mode of your Do Until condition.
Apologies for the delayed response. I tried your solution, but it does not accept the expression as a valid template language expression. Here is my expression:
Not( Empty(TriggerBody()?['AssignedTo']?['Email']) )
The specific error is: "The template validation failed: 'The property 'expression' 'Not( Empty(TriggerBody()?['AssignedTo']?['Email']) )' of template action 'Do_until' at line '1' and column '1379' is not a valid template language expression.'."
Did I miss something here?
I've tried a similar approach, the following WDL expression has been accepted by Flow when saving it. Please note I am
evaluating a first level column, so does not exactly match with the scenario you want to implement
If you manage to save you flow without errors, please note I've executed my example flow by adding a new item to the list, leaving "Decision" column empty, but it seems it is populated inside the trigger as null, so the Do-Until condition is matched the very first time Flow evaluates it (not what I was looking for)
If you face the same problem, I guess coalesce function may help (https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language) since it helps you to replace Null by whatever convinient string
Hope this helps more than my first answer
I'm also having problems with this... It was much easier with SP Designer and the 'Wait' and 'Is Not Empty' options. There should really be a more straightforward way in Flow to do this. I'd rather not build things in SPDesigner anymore as it's clear that MS is moving away from that as a tool. Can anyone help resolve this?
edit to include a screenshot of my flow. I think we're trying to do a similar thing here. Thoughts?
My issue was similar in that I was waiting for a specific requirement to be met before I then continued the Flow.
If you click Change Limits in your Do until, you will see 2 options: Count and Timeout. I set Count to 5000 and Timeout to P30D (30 days as per https://en.wikipedia.org/wiki/ISO_8601) .
I also used null in the expression, rather than "" or other text. See image below
On an unrelated tangent, I then used 2 variables to set a "Delay until" action at 5 minute intervals - a "DelayUntil" and "DelayUntilPrev". The initial value for "DelayUntil" was set at 5 minutes from NOW and "DelayUntilPrev" is set to be the same as "DelayUntil".
For each 'loop' through Do Until, I set "DelayUntil" to be "DelayUntilPrev" + 5 minutes. "DelayUntilPrev" is then set to the new "DelayUntil" value.
The formula for "DelayUntil" in the loop is below:
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!