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 / Getting an error messa...
Power Automate
Unanswered

Getting an error message on a condition

(0) ShareShare
ReportReport
Posted on by 2

Hi!

I have developed several Flows using conditions.  For some reason, this one doesn't want to work properly.  I've created 2 different flows using the same conditional principles and they function well.  So, I'm hoping someone could help.  

At first I had an issue with the flow creating a row, but not filing in the data.  That was fixed temporarily and now I am getting the error below.  I tried to move things around, put in variables... and nothing is working.  

I appeciate any help or insights.

 

"Unable to process template language expressions for action 'Condition_3' at line '1' and column '17998': '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'.'."

 

This is the FLOW:

Basically, once a form is filled in, the answers fit the conditions, I'd like to add a row to one of 2 tables.  The first will fill if the answer to the department is "Fly-In" and the other will fill if the answer does not meet any of the options. (The form has an "other" option.)

 

caroro_1-1635216145554.png

caroro_2-1635216210611.png

caroro_3-1635216313464.png

caroro_4-1635216452906.png

caroro_0-1635216003711.png

 

(Just for your info, I do not have access to creating items/lists on SharePoint nor can I add Flow to my excel document. I am also a self-taught "Flow"-er, so I may be doing this all wrong.)

Categories:
I have the same question (0)
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @caroro  Please add one compose just above condition 3 and pass Department which you are passing in condition.Run your flow and share output.

    Hardesh15_0-1635250100959.png

    Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

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 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard