Skip to main content

Notifications

Community site session details

Community site session details

Session Id : e5i5Y7DFsAAG4t4G29n4Ei
Power Automate - Building Flows
Answered

Unable to see "edit in advance mode " under flow conditions

Like (1) ShareShare
ReportReport
Posted on 6 Feb 2019 16:58:25 by 14

as mentioned in the title, do not have the option to edit conditions in advance mode in my microsoft flows builder. 

 

illustration.PNG

does it have anything to do with permissions access? or is there an updated way to access the advance mode ? 

  • Spirytus Profile Picture
    17 on 22 Jan 2020 at 20:37:13
    Re: Unable to see "edit in advance mode " under flow conditions

    This:

    @equals(formatDateTime(item()?['Nextauditdue'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 14), 'MM/dd/yyyy'))  

     Is exactly this:

    trythis.png

     I just broke your @equals( ... )  into two expressions:

    • formatDateTime(item()?['Nextauditdue'], 'MM/dd/yyyy')
    • formatDateTime(addDays(utcNow(), 14), 'MM/dd/yyyy')

    Pasted each expression in the left / right argument fields of the condition action, and finally selected (the default) "is equal to" comparison option.

     

    Looking closer at your code though; you're comparing some static date from your SharePoint list ( item()?['Nextauditdue'] ) to today + 14days ( addDays(utcNow(), 14) )... Why ?

     

    If all you want to do is send an e-mail after 11 months of some date, why don't you use the "Delay until" action?

     

    try_delay.png

     

    If you want to make it recurrent, nest the "delay" action inside a "Do until" loop? Often times there are multiple solutions to a problem, maybe I'm missing something... Anyway good luck to you.

  • justinc6013 Profile Picture
    4 on 22 Jan 2020 at 19:50:38
    Re: Unable to see "edit in advance mode " under flow conditions

    I've tried but I need the one side to have my desired date which comes from SharePoint.

     

    Example of what I'm looking for:  Send an email to *** after 11 months from the subscribed date.

     

    I can not at all see how to do this with the Condition

  • Spirytus Profile Picture
    17 on 22 Jan 2020 at 16:53:58
    Re: Unable to see "edit in advance mode " under flow conditions

    Have you tried this?

     

    trythis.png

  • justinc6013 Profile Picture
    4 on 22 Jan 2020 at 16:01:39
    Re: Unable to see "edit in advance mode " under flow conditions

    How can I do this code without edit conditions? Trying to send a remind email after 14 days.

     

    @equals(formatDateTime(item()?['Nextauditdue'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 14), 'MM/dd/yyyy'))

     

  • Caitlin_Knox1 Profile Picture
    46 on 09 Nov 2019 at 00:56:26
    Re: Unable to see "edit in advance mode " under flow conditions

    I am REALLY hoping someone can help me out.

    What started this journey to advanced conditions is that I was running into a problem where Flow was telling me that it was unable to process template language expressions (https://powerusers.microsoft.com/t5/I-Found-A-Bug/Unable-to-process-template-language-expressions-in-Custom/td-p/142950 )

    All I'm really trying to do is use the value of a cell (Excel table) in my condition logic. It worked once when I wrapped my value in ' ' but for some reason didn't work for the other threshold I added in the no branch. Thus, I pivoted to Advanced edit. 

    This is what I have so far, but the error message I get back here is a generic 'Invalid Response'

     

    The syntax I'm (trying) to use are the following

    less(float( body('Get_a_Row')?['output'] ),3)

    less(float( body('Get_a_Row')?['output'] ),6)

    greater(float( body('Get_a_Row')?['output'] ),6)

     

    I linked the aforementioned screenshots of the error message & then the structure of my flow. Trying to use the output of 'Get Rows' for the condition

    screenshots 

  • AtifMir Profile Picture
    7 on 06 Aug 2019 at 14:10:11
    Re: Unable to see "edit in advance mode " under flow conditions

    Brilliant, your solution fixed my issue straight away. 

  • v-yamao-msft Profile Picture
    on 08 Feb 2019 at 03:51:06
    Re: Unable to see "edit in advance mode " under flow conditions

     

     

  • Verified answer
    v-yamao-msft Profile Picture
    on 08 Feb 2019 at 03:27:42
    Re: Unable to see "edit in advance mode " under flow conditions

    Hi @kale99,

     

    Previously, we could select Edit in advanced mode then then enter the expressions in a text box. Now, there is no longer an Edit in advanced mode, instead if you want a very complex expression you can use the regular dynamic content expression builder to enter your expression on the left side of the row, then select Equals to and enter true in the right side.

    1.PNG

    The following blog on Advanced condition builder for your reference:

    https://flow.microsoft.com/en-us/blog/build-more-powerful-conditions-in-flows-and-more/

     

    Best regards,

    Mabel

     

  • AlanPs1 Profile Picture
    2,471 on 07 Feb 2019 at 16:52:30
    Re: Unable to see "edit in advance mode " under flow conditions

    Exactly @SCTdan

     

    I created this forum post and a blog on the matter as there is lot's of content out there utilising an expression for the condition.

    If trying to implement these since yesterday's changes confusion arises. It took someone implementing one of my processes to draw it to my attention so thought best share the work around.

     

    The more people who become aware of this the better really

     

    Smiley Happy

     

     

  • SCTdan Profile Picture
    604 on 07 Feb 2019 at 16:49:31
    Re: Unable to see "edit in advance mode " under flow conditions

    That makes sense.  Instead of true/false being returned by the function itself in the old advanced editor, you're just explictly stating it now.  The same functions you could use in the old advanced editor just go into the value field in the new editor.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started