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.'.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
d31 8 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
d31 8 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No