I have what I feel is a pretty simply flow using a DoUntil that just doesn't want to trigger. I just want it to wait until a single line text column contain data and then send an email.
After an approval has been made, it sends an email and updates the item status column. No problem there. Then i just want it to wait until the column "Employee Name" gets modified before sending a different email. So i use the @not(Empty(TriggerBody()?['Employee_x0020_Name'])) to wait for the column to not be empty before sending an email. Well, it never notices that the column has data in it. I've waited 20 minutes and my delay6 is only 1 min.
I have tried geting the ID of the Update item 8 as well as the when an item is created. Any ideas or is DoUntil still in Beta?
see my flow here
UPDATE 3/27: So to give this a temp solution, i simply put a default character in the Employee Name column that we will just need to remember to remove when populating that field with a real name. Now my DoUntil is just looking at that column and checking to see if 'does not contain' that character (I used a percent sign % because that's not going to be part of a person's name) and then when it does get populated it will run just fine and send me my darn email! haha
see flow here
Hello @jcollins.
I don't think Do Until is in Beta but it might be easier to help if you post some images of your flow (although I cannot do that in this forum). Or a bit more detail about your flow structure.
Perhaps check the output of the 'Get file properties' action (or whatever action/s you are using) because I've found recently that this action does not output custom columns that are emtpy unless they are person/group columns. I have an open question on this forum (and the techcommunity forum) about it. My workaround is to ensure that all columns have a default value. Only then are the custom columns returned in the output. Which then enables me to use the columns in flow conditions. I don't know yet if this is expected behaviour or a bug.
Hope that helps.
Ian.
I'm no expert but I think your Do Until is looking at the wrong output. TriggerBody will never change as this represents the column when the fow was triggered. And not the column that has been changed since the flow was triggered. Instead the Do Until should be looking at the column output by the 'Get item 6' action.
Perhaps try something like this in the Do Until condition:
@not(empty(body('Get item 6')['Employee_x0020_Name']))
Ian.
Just an additional note that the code in my previous post will probably generate an InvalidTemplate error unless the 'Employee_x0020_Name' column is populated.
I've just discovered that I have to use the coalesce function in my Do Until condition to avoid the problem with columns that are not populated when the flow is triggered. For example:
@and(not(empty(body('Get_file_properties')?['Approver'])),not(equals(coalesce(body('Get_file_properties')?['InvoiceAmountExclGST'], '0'), '0')),not(equals(coalesce(body('Get_file_properties')?['InvoiceDate'], '19000101'), '19000101')),not(equals(coalesce(body('Get_file_properties')?['InvoiceFrom'], 'Nobody'), 'Nobody')),not(equals(coalesce(body('Get_file_properties')?['InvoiceNumber'], '0'), '0')
Thanks for your reply! , Just get this now: The template validation failed: 'The action(s) 'Get item 6' referenced by 'inputs' in action 'Do_until' are not defined in the template.'
Simply put, i just want to send an email when a text field gets populated. LOL! I am laughing because this tool is sooo powerful but yet seemingly so difficult to figure out something so seemingly easy.
Not sure if your update on original post came before or after your reply to my post but I thought I'd post this anyhow in case its useful.
Here is a pic of my working do until flow with blank/empty columns:
And as before this is the condition in the Do Until:
@and(not(empty(body('Get_file_properties')?['Approver'])),not(equals(coalesce(body('Get_file_properties')?['InvoiceAmountExclGST'], '0'), '0')),not(equals(coalesce(body('Get_file_properties')?['InvoiceDate'], '19000101'), '19000101')),not(equals(coalesce(body('Get_file_properties')?['InvoiceFrom'], 'Nobody'), 'Nobody')),not(equals(coalesce(body('Get_file_properties')?['InvoiceNumber'], '0'), '0')))
And I'm no longer assigning default values to the columns because of the coalesce function. Although I'm working with a library and not a list (as you appear to be), I would have thought the logic essentially the same.
In terms of your flow, I'm not sure why the delay step is necessary except to reduce processing I suppose. Without the delay step, the loop will just keep getting the properties until the column/s get populated.
To help further it would be useful to see a pic of your full flow with each step expanded.
Partly for my own satisfaction, I thought I'd do the following. If it helps thats great. Otherwise, I think I've exhausted my limited knowledge.
I created a list and added a single line text column called 'Employee Name':
The 'Employee Name' column is not required and does not have a default value. I then created the following flow:
I added a new item but didn't populate the 'Employee Name' column. Then watched the flow running for a couple of minutes:
Before editing the item and entering a name in the 'Employee Name' column. Which caused the flow to complete:
Image of successfully completed flow
And send me a notification:
And a few things I meant to add:
1. The ID used in the 'Get Item' step is the ID of the trigger item.
2. Ensure that the Do Until Count limit is empty/blank
3. I seem to recall from reading/webinar that it is important to add the 'Get item' step before defining the Do Until condition because the condition is dependant on the output of the 'Get item' step. But I could be wrong here.
In addition, you will see that Do Until step looped 284 times before i populated the Employee Name field. If I look through the 'Get item' output for each loop, the 'Employee Name' column is NOT in the output until loop number 284. Which is why it is necessary to either:
1. Assign default values to the column/s OR
2. Use the coalesce function in the condition/s if there are empty fields
The exception to this appears to be person/group columns where they appear in the output even when they are empty.
I also wondered why you are using a text column for the employee name instead of a person/group column but I'm sure you have a good reason for this.
I hope this has helped.
Hi @ jcollins,
You should use the "Employee Name"dynamic content of "Get item" action instead of the "Employee Name" dynamic content of the trigger in the expression of "Do until".
I have made a test on my side, the screenshot of my flow as below:
The expression in the Do until as below:
@not(empty(body('Get_item')?['Employee_x0020_Name']))
The flow would run successfully as below:
Regards,
Alice Zhang
Thanks @v-yuazh-msft.
not(empty ... works for me too in my test list and flow. Just tried it. Which suggests that I don't need to use coalesce when working with a list.
But not(empty doesn't work when I use it with a library (unless the column is a person/group type). I'd like someone to try and explain that to me sometime but probably one of those things I just have to remember ...
Dear Community Members, We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd. During this period, members will not be able to Kudo, Comment, or Reply to any posts. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!
We are excited to announce the Summer of Solutions Challenge! This challenge is kicking off on Monday, June 17th and will run for (4) weeks. The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities. Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”) - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024 Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods. You must enter into each weekly Entry Period separately. How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different. Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers. At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing. Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner. A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random. Individuals will be contacted before the announcement with the opportunity to claim or deny the prize. Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners. Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event. ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE** Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24 17 @Anil_g 7 @ManishSolanki 13 @eetuRobo 5 @David_MA 10 @VishnuReddy1997 5 @SpongYe 9JhonatanOB19932 (tie) @Nived_Nambiar 8 @maltie 2 (tie) @PA-Noob 2 (tie) @LukeMcG 2 (tie) @tgut03 2 (tie) Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate @Deenuji 12@ManishSolanki 19 @Anil_g 10 @NathanAlvares24 17 @VishnuReddy1997 6 @Expiscornovus 10 @Tjan 5 @Nived_Nambiar 10 @eetuRobo 3 @SudeepGhatakNZ 8 Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22 Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2 Anil_g2 SharonS2
On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners. The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights. Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.
We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for. We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer. Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together. Here's to new beginnings and endless possibilities! If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport. To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages