Unanswered

The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

(0) Share

Report

Posted on by jaina

517

Hello. i have a EmailList column which is a Person/Group data type in SharePoint.. and in my customized form using Power Apps, I set required property to "true" but still some users can proceed with the submission of item... and in the workflow i developed, i created actions Initialize Variable Array, then Append Array EmailList (Person/Group) values and then Join using semi colon (;) separator and the output was in the CC email. Problem is, whenever the EmailList has no value, the workflow will encounter an error?

Can someone help how to handle this? Also, how can I limit the Person/Group email to exclude the SharePoint groups in searchable items?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(2)

Report
Copy link

Link copied!

Hey @jaina

I faced the same problem a week ago. To handle it, while appending I was checking if the current column value is null or not. If it was null, I was passing 'NA' to it. You can pass anything, like null or NA too.
And if it was not null, I was passing the value.

I used an expression:
if(equals(items('Apply_to_each')['field'],null),'NA',items('Apply_to_each')['field'])

You can apply the same method. And use a similar expression that I have used above.

After this you can use filter array action to just filter out the values that have values and remove the ones that are null.

Was this reply helpful? Yes No
chintu49 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I am getting this error message as well (The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.), but I am not sure where or to which step I should apply that expression, could you please help with the screenshot or exactly which action should i add and where should i add? below is my workflow screenshots in detail

Any help is appreciated

Chintu

Was this reply helpful? Yes No
chintu49 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Forgot to attach error message

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

@chintu49

Can you show what you are putting in append to array variable?

Was this reply helpful? Yes No
chintu49 45 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sundeep_Malik

Thank you for your response really apprecaite, here is the screenshot for the append to array variable. I am putting body and then "AccountOwnerEmail" in "Name" field and "Resourceemailaddress" that comes from the dataset table in the "Value" field

Was this reply helpful? Yes No
chintu49 45 on at

Like
a
(0)

Report
Copy link

Link copied!

@Sundeep_Malik can you please help

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @chintu49

Sorry for late reply. I am really depressed these days because I have not found a new job in the last 2 months.

I used the same solution which I gave to @jaina

Here is the error I am getting:

I am just passing check dynamic value:

Then I tried the below expression:

if(equals(items('Apply_to_each')?['Check'],null),'NA',items('Apply_to_each')?['Check'])

Above I am seeing if check has null in it or not. If it has null I am adding NA to the append to variable, you can pass false, or anything else, whatever you want. You can pass single quotes too to add a null value. But directly dont add null in it.

You can also try the below expressions, might work in your case:

if(equals(items('Apply_to_each')?['Check'],''),'NA',items('Apply_to_each')?['Check'])
if(empty(items('Apply_to_each')?['Check']),'NA',items('Apply_to_each')?['Check'])

Just replace items('Apply_to_each')?['Check'] with your dynamic expression.

See now my flow works without any errors:

I hope this helps 🙂

Looking for a New Job. Please Help!!!

Was this reply helpful? Yes No