web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue with 'Condition'...
Power Automate
Unanswered

Issue with 'Condition' returning false

(0) ShareShare
ReportReport
Posted on by 41

I have tried so many variation and reviewed many many similar issues, but can not seem to get this to work. I have tried if(equals) expressions with no luck (template errors). Please help I have been working on this too long. It is the only issue I have had since working in power automate love the tool. So I am looking to take and action based on a form response. I began by using an item in a list, but moved to creating a yes/no to try to simplify the issue. Below is the flow. I am creating item in a list in SharePoint and when ever YES is selected from question "Is this Reg MFP, " it should trigger an approval, whenever no email with options. I have also tried to change the yes to 'yes' based on other memo on basic versus dynamic. 

 

I have blown this a part and started over many times. I also have the process of updating the SharePoint when item is created or modified working to adjust approval status fine. This is the only item that I can not figure out. Let me know what other info you may need. I have tried this as a stand alone condition of yes, and, or and any other options as well as contains etc. with no success. Thanks.

mwise121_4-1653308856976.png

 

 

mwise121_0-1653308648980.png

mwise121_3-1653308722764.png

 

Here is the body info:

 

 "@odata.etag""\"1\"",
  "ItemInternalId""74",
  "ID"74,
  "Title""Agency 101",
  "SubmissionDate""2022-05-23",
  "IsthisRegMFP_x003f_""Yes",
  "Program""Regular MFP Non-Grant Related",
  "Rescheduleneeded_x003f_"false,
  "ApprovalStatus": {
    "@odata.type""#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
    "Id"0,
    "Value""Pending Approval"
  },
  "ApprovalStatus#Id"0,
  "Isthisanewagency_x003f_""No",
  "DestinationAddress""here st",
  "IsthisaHHFBEvent_x003f_""No",
  "Existingagencyaddress""Family Health Center - 3548 Marie St. Orangeburg",
  "Numberofboxes""2000",
  "DeliveryMethod""Delivery",
  "OData__x0031_stChoiceDeliveryDate""2022-06-01",
  "OData__x0031_stChoiceTime""10 am to 10:30 am",
  "OData__x0032_ndChoiceDeliveryDate""2022-05-19",
  "OData__x0032_ndChoiceTime""11 am to 11:30",
  "ImpactedWarehouse""Midlands Warehouse",
  "County""[\"Chester\"]",
  "Modified""2022-05-23T12:13:11Z",
  "Created""2022-05-23T12:13:11Z",
  "Author": {
    "@odata.type""#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    "Claims""i:0#.f|membership|mwise@harvesthope.org",
    "DisplayName""Misty Wise",
    "Email""MWISE@harvesthope.org",
    
    "Department"null,
    "JobTitle"null
  },
  "Author#Claims""i:0#.f|membership|mwise@harvesthope.org",
  "Editor": {
    "@odata.type""#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    "Claims""i:0#.f|membership|mwise@harvesthope.org",
    "DisplayName""Misty Wise",
    "Email""MWISE@harvesthope.org",
  
    "Department"null,
    "JobTitle"null
  },
  "Editor#Claims""i:0#.f|membership|mwise@harvesthope.org",
  "TaxKeyword": [],
  "TaxKeyword@odata.type""#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
  "TaxKeyword#WssId": [],
  "TaxKeyword#WssId@odata.type""#Collection(Int64)",
  "{Identifier}""Lists%252fMFP%2bDistribution%2bList%252f74_.000",
  "{IsFolder}"false,
  "{Thumbnail}": {
    "Large"null,
    "Medium"null,
    "Small"null
  },
 
  "{Name}""Agency 101",
  "{FilenameWithExtension}""Agency 101",
  "{Path}""Lists/MFP Distribution List/",
  "{FullPath}""Lists/MFP Distribution List/74_.000",
  "{ContentType}": {
    "@odata.type""#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
    "Id""0x0100233072613DA1794FB16F6EE7F3E6705700C31CAF4349531740BA7A1554DB0A3C11",
    "Name""Item"
  },
  "{ContentType}#Id""0x0100233072613DA1794FB16F6EE7F3E6705700C31CAF4349531740BA7A1554DB0A3C11",
  "{HasAttachments}"false,
  "{VersionNumber}""1.0"

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at

    I suspect the problem with the condition statement is that its case sensitive.  Try using Yes on the right side of the condition instead of yes

  • CFernandes Profile Picture
    8,402 Most Valuable Professional on at

    Hey @mwise121 

     

    I assume its an Yes\No Column.

     

    Please try to Type "true" or "false"  into Expression and click "OK".

     

    CFernandes_1-1653309329004.png

     

    For details see - https://docs.microsoft.com/en-us/answers/questions/176896/yes-no-not-working-on-if-condition-using-power-aut.html 

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

     

     

     

  • mwise121 Profile Picture
    41 on at

    Still no go I tried that one before. It ran correctly when option was Yes, but when I ran it again with response No is still chose True.

    mwise121_0-1653309834046.png

    mwise121_1-1653309856469.png

     

    Thanks for the quick response going to try other suggested option next

     

     

  • mwise121 Profile Picture
    41 on at

    @CFernandes To clarify should it be an OR condition like this? I ran it that way and still have issues with condition. Let me know. Thanks.

     

    mwise121_3-1653310143532.png

     

    mwise121_2-1653310119607.png

     

  • CFernandes Profile Picture
    8,402 Most Valuable Professional on at

    Hey @mwise121 

     

    I assume you are validating a single column?

     

    Can you please remove the OR condition for now...  Just use 

     

    <columnname> is equal to true.

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

  • mwise121 Profile Picture
    41 on at

    @CFernandes updated as directed. Still same issue. I appreciate the quick support, I can't make sense of the  problem.

     

     

    mwise121_1-1653310841713.png

     

     

    mwise121_0-1653310816281.png

     

    In the beginning I attempted to set up the condition based on a selection value being true/false from a different field with the same issue. I thought the yes/no would simplify it versus a true value of Regular MFP Non-Grant Related. 

    mwise121_2-1653311021740.png

     

  • mwise121 Profile Picture
    41 on at

    @CFernandes @Pstork1 Any other suggestions to try? Compose is one I have tried but it threw errors. Based on my current process do you know any other options I can run?

  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at

    What do you want it to do if the answer is No?  right now the condition is setup using "OR" so it will evaluate to True if the answer is either Yes or No.  It only goes to false if you test against something like yes or no

  • mwise121 Profile Picture
    41 on at

    @Pstork1  Currently, if the answer is Yes, to "Is this Reg MFP?" it will send for approval. If No, is sends an email with options to schedule delivery. 

  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at

    For that you only need the line that checks it against "Yes".  You don't need the check against "No" since you send the email on the false side of the condition.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard