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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate Error: ...
Power Automate
Unanswered

Power Automate Error: Invalid Template

(0) ShareShare
ReportReport
Posted on by 6

Hi everyone,

 

I am currently using a Sharepoint list as a database where one of the columns can have one or more emails. I created a Power Automate flow so every time the list is created or updated, it automatically sends an email to the people listed in this column. The emails are separated by " / ". I created the flow using a conditional where if the value contains " / ", it can establish the value and replace the " / " with a ";" and send the email. If not, just send the email to the person listed. It worked fine, but now is showing me this error:

 

InvalidTemplate. Unable to process template language expressions for action 'Revisar_si_hay_más_de_un_responsable_para_el_Subsistema_A' at line '0' and column '0': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

 

The only thing that I changed was the body of the auto generated email, no more. The emails are written as "123@abc.com / 456@def.com / 789@ghi.com , and so on. So I really cannot figure out what is the problem. Attached I post a picture of how the flow is composed with the conditional action and the error that appears.

MarianaM9_0-1652453952336.png

 

MarianaM9_1-1652454018259.png

 

I hope anyone can help me out with the issue.

 

Thanks.

Categories:
I have the same question (0)
  • Henrik_M Profile Picture
    2,021 Super User 2024 Season 1 on at

    What is the column type of the SharePoint list?

  • MarianaM9 Profile Picture
    6 on at

    Hi Henrik_M,

    The column type is a lookup from another list.

  • Henrik_M Profile Picture
    2,021 Super User 2024 Season 1 on at

    Try to use a Get item action, then use the column name value output in your conditional.

  • MarianaM9 Profile Picture
    6 on at

    I already use a "Get Item" action after the trigger as it shows the picture.

    MarianaM9_0-1652482608215.png

     

  • Henrik_M Profile Picture
    2,021 Super User 2024 Season 1 on at

    Is this the column VALUE output from that action?

    Henrik_M_0-1652538266544.png

     

  • MarianaM9 Profile Picture
    6 on at

    Yes

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 922

#2
Valantis Profile Picture

Valantis 837

#3
Haque Profile Picture

Haque 534

Last 30 days Overall leaderboard