Answered

Form to Sharepoint List Null Values

(0) Share

Report

Posted on by Tony_P0463

Hello,

I am pretty new to Automate but find it extremely useful. I have managed to build a pretty good flow from forms to SharePoint via MS docs and some good YouTube videos. I truly would appreciate any help or any reference materials to read.

"The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array."

Issue:

In my form, I have branching so at times, I may not receive any answers for certain questions and that is ok because they were not needed to be answered. In some of my multiple choice, multi selection questions, Flow is expecting values and throws an error saying it expects an array and not a null value. How do i write an IF statement to handle that so no errors are thrown when something that is ok happens. In other words, null values may be ok at times.

Thank you again and look forward to your replies.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Tony_P0463

Please using condition action as below as below:
If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
Tony_P0463 6 on at

Like (0)

Report

Thanks for the suggestion MG, though i think I may not be doing something right.
I added the condition as an action right before it does the json parsing, but it still errored out.
That being said, I have two boxes "If Yes" and "If No", not sure if I had to do something with those two.

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Tony_P0463

Please move your step parse step to the yes

Was this reply helpful? Yes No
Tony_P0463 6 on at

Like (0)

Report

Thank you Mira!

Was this reply helpful? Yes No
mprindiville 2 on at

Like (0)

Report

Hi,
Were you able to resolve this issue. I've added the condition to the flow but still get the Error
The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.

Any idea or thought to allow the array not to trigger if the question is null?

Was this reply helpful? Yes No