Unanswered

'item/ScanningTool' to be a string of maximum length '255' but is of length '296'.

(1) Share

Report

Posted on by SN-29081614-0

Current Error:

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation 'PostItem' requires the property 'item/ScanningTool' to be a string of maximum length '255' but is of length '296'

I’m encountering an issue while automating the import of an Excel CSV file into a SharePoint Site list. I've made some progress, but I keep running into the same problems. Could you please advise?

My goal: is to automate the integration of weekly vulnerability scans from Tenable into our SharePoint site list. If there’s a more effective approach or if I'm missing something, please let me know.

VAR Expression

if(greater(length(variables('Var')),255),take(variables('Var'),255),variables('Var'))
 
Expression
substring(variables('Var'),1,255)

Screenshots provided:

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I could not properly understand what is the relation with the expression you have written - could you explain the query properly - i could see you are facing issue with string length - but could not relate with expression written ?

Was this reply helpful? Yes No
SeanRoque 3 on at

Like (1)

Report

Seems like you're appending the text from the "split()" expression and the "substring()" expression? Can't perfectly tell based on the screenshots.

But if that's the case, then I'm guessing you want to make sure that the those two together is 255 max so you don't get the error.

For example, initialize a different variable with the entire thing:

Scanning Tool:

substring(concat(split(...), variables('Var')), 0, 255)

Note that depending on the contents of what's in the split expression, the final value may not reflect what you want so best to just make sure that the end result is still useful.

If I'm misunderstanding this at all let me know I'll be happy to revisit :)

Was this reply helpful? Yes No