Power Automate condition not working as expected
I am trying to replicate the following condition set below. This would be easy in SQL, however my condition task doesn't seem to be working as expected (or my understanding is not correct.)
If statuscode not equal to 1 AND entityname NOT IN (GlobalOptionsetMetadata,
StateMetadata, StatusMetadata, TargetMetadata, OptionsetMetadata)
OR
div(sub(ticks(utcNow()), ticks(triggerOutputs()?['body/modifiedon'])), 600000000) < 30 AND (entityname IN (bankaccounttrans, dimensionattributevaluecombination etc. AND entityname NOT IN GlobalOptionsetMetadata, StateMetadata etc.)
however am getting emails from the not equal to tables at the bottom, where I would expect these to be excluded. What is the best way of handling these type of conditions?
Solution
I think this is going to do what I want. Testing is working so far. Please confirm if you agree.
(body/statuscode is not equal to 1
AND
createArray('GlobalOptionsetMetadata', 'StateMetadata', 'StatusMetadata', 'TargetMetadata', 'OptionsetMetadata') does not contain body/entityname)
OR
(div(sub(ticks(utcNow()), ticks(triggerOutputs()?['body/modifiedon'])), 600000000) < 30 AND createArray('bankaccounttable', 'bankaccounttrans', 'dimensionattributevaluecombination', 'dimensionattributevaluegroupcombination', 'dimensionattributelevelvalue', 'generaljournalaccountentry', 'ledgerjournaltrans','vendtrans') contains body/entityname)
- Power Automate - Filter array on string value
- Integration with excel in powerautomate
- Failed to validate the signature of the actionable message card Power Automate
- How to write fetchXml to get distinct data in dataverse connector
- Power Automate flow in an existing Sharepoint Online list - will it copy and be usable when a new Sharepoint list is created from existing list?
- How to get a object key in a JSON in Microsoft Flow
- PowerAutomate - replace nth occurrence of character
- Power App pulling data from Power Automate Flow
- Set string variable to dynamic list column value gives error: Input parameter of operation Set Variable contains invalid expression. PowerAutomate
- How do I filter an array of strings using substrings within another array as the filtering criteria in Power Automate?
- Implementing Autodesk APS in Microsoft Power Automate Custom Connector
- Get email with Message-Id using Power Automate
- Add OAuth authentication for HTTP request triggers
- Power Automate condition not working as expected
- How to get the columns from a Microsoft list row into an array of strings
- Check if today is the last monday of the current month in power automate
- How to insert a new row to excel file when a subfolder is created on sharepoint using power automate?
- Can a Custom Connector work with a client_credentials grant flow?
- Advanced conditions in power automate
- Power automate datetime comparison seems wrong in just one instance
- How to Use Dynamic Environment Variables in Power Automate Trigger for SharePoint File Creation?
- Need assistance with Xpath expression to count non-null values after a delimiter
- Join the outcomes of multiple FilterArray Power Automate actions without using ApplytoEach
- Error: AADSTS900144 - Missing 'grant_type' Parameter in Request Body
- How to Add Comments to SharePoint List Items Using Power Automate?
- Add Days but Exclude Weekends from Calculation
- Power Automate keeps adding an "Apply to Each" and has nested my "Send an Email" action so far down that I'm only getting errors
- How to get all messages post by person in team channels using power apps in teams
- Power Automate Send an HTTP request to SharePoint returns BadGateway error when creating a Lookup field
- Selecting all array indices with certain objects each for creating a CSV Table in Power Automate