Split Statement

(0) Share

Report

Posted on by d31

Hello,

I am trying to update teh Sharepoint items after getting the output from Excel item but getting this error

{
    "Req": "168076",
    "PMno": 90159,
    "StartDate": 45551,
    "ExtendedDate": 45500,
    "Movetohire": 45501,
    "Division": "Chief Operating Officer 710377",
    "OL4": "SrVP and Chief Nursing Officer 711045",
    "OL5": "Nursing 600421",
    "OL6": "Nursing Resource Pool 600535",
    "OL7": "",
    "L8Name": "",

This is the Excel output and below is the split statement which worked Before but now throwing an error

split(split(string(body('FilterExcelItem')),',')[0],':')[1]

Now i am getting this error

Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'split' expects two parameters: the string to split as the first parameter, the separator as the second parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#split for usage details.'.

All responses (3)

Answers (0)

d31 8 on at

Like (0)

Report

Split Statement

Excel i am reading from the Inbox email they receive and then running excel to convert into table then comparing columns with sharepoint if duplicates need to replace columns.
d31 8 on at

Like (0)

Report

Split Statement

I am comparing Excel and Sharepoint then if they are duplicates i shd update them with Excel values in sharepoint to avoid wrong column info and check for other values like department then split them too
ScottShearer 25,223 Most Valuable Professional on at

Like (0)

Report

Split Statement

How are you getting the data from Excel? I am trying to figure out why you can't reference a column from Dynamic properties.

What column in Excel are you trying to reference - there is an easier way to do your Split using the column name.

Can you post a screen shot of your Flow?

Scott