Send an email when a sharepoint list item is modified based on a conditions

[AutomateNewbie]

Hello,

I am teaching myself Power Automate and am stuck on a new flow that I'm building.

I currently have a flow that creates a new Sharepoint list item once a Form is submitted, then it Starts and waits for an approval. Here is the screenshot for that flow:

Once I receive approval, I then process the request and modify blank fields within my sharepoint list. The fields that I modify are Sales Order Processed and ZDEM Order Number as seen in the following screenshot:

I want to create a flow that sends and email when the list is modified and the following conditions are met. If these conditions are not met, do nothing.

On Manual Allocation = Yes

Approval = Approve

Sales Order Processed = Yes (checkmark)

ZDEM Order Number starts with 100

Here is the flow I tried to build, but I kept receiving the following error:

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'contains' expects parameters of matching types: a dictionary and a key (string), an array and a value (object), or a string and a substring. The provided types 'String' and 'Integer' are incompatible

I assume I need to create some strings instead of the text in condition but I don't know how to. Please help!

[ScottShearer]

@AutomateNewbie 

I suspect the issue has to do with what type of SharePoint columns are being used.

I suggest that you proceed as follows:

1. Start with just 1 condition and test the Flow
2. If there are no errors and you get the expected results, add another condition
3. Keep adding conditions until you get an error.
   1. Post a screen shot of the error
   2. Post a screen shot of the condition
   3. Post a screen shot of the SharePoint column definition (list settings/click on column name)

That way, we can identify where the error is coming from which will make your issue much easier to solve.

[Zpemberton]

@AutomateNewbie You are attempting to use a 'contains' with an integer value.  A quick solution to this would be to place quotes around the 100 such as 

[AutomateNewbie]

Hi @Zpemberton , I tried this but that solution is not working. The flow succeeds however, it always comes back as false, so it will not send an email although the condition is met.

[Zpemberton]

Would you be able to provide the values of an item that you know you would want to pass?  Also, one thing to note is that Sharepoint handles yes/no checkboxes or drop downs as true/false, not yes/no.  So for the third condition, you should indicate 'true' instead of 'yes' as your variable to check by.  Not sure if this is the specific issue or not.

[AutomateNewbie]

In the following screenshot, the first row in green should pass and send an email. I'm not sure if it matters but the "On Manual Allocation" Field is a multiple choice field on the original form.

[AutomateNewbie]

Hi @ScottShearer 

Is this what you mean by column definition?

[Zpemberton · Accepted solution]

@AutomateNewbie I did some testing on my end with your situation to see what the culprit might be.  From my findings, it's as simple as the casing on your checks. 😊

* I noticed I mixed the numbers up. on the results 1 should be 2

Created a simple sharepoint list that mimics yours slightly.

[AutomateNewbie]

Thanks that worked! Who knew it could be such a simple fix?!?