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 / Errors in Split function
Power Automate
Unanswered

Errors in Split function

(0) ShareShare
ReportReport
Posted on by

I keep getting an error with this 

split(item()?['Tools'],';')
 
The error I get is this.
Unable to process template language expressions in action 'Select_Tools' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'.
 
I can't understand it
Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,874 Most Valuable Professional on at

    Hi @vas1969,

     

    Null error normally means that the Tools field of the current item is empty. If this is the case the split function will result in this type of error.

     

    This is either caused by the Tools field value actually being empty or that the reference in the expression you used to that field is incorrect (It can be nested within another field for example).

     

    Have you double checked if the Tools field of the current item is empty?

  • RobotRising Profile Picture
    402 on at

    Hi Vas,

     

    That error means the value you are trying to split is blank. 

     

    The dynamic content for "tools" is empty so the split function has nothing to split. 

     

    You can use a filter action to filter out blanks or alternatively use a condition to check if the field is blank before splitting it. 

     

    You could also start at the trigger and only get items where tools is not blank or at data entry make sure that the field is required so that tools field is never blank (fill it with a default value as well)

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 957

#2
Valantis Profile Picture

Valantis 847

#3
Haque Profile Picture

Haque 609

Last 30 days Overall leaderboard