Answered

Attachments that go from FORMS to SHAREPOINT

(0) Share

Report

Posted on by BB818U

Hello, I am looking to have any attachment that is added in FORMS to move over to SharePoint, I already have the form set and the flow was working and works at times but sometimes it fails. Not sure what the issue is can someone please advise, thank you.

Error message

The execution of template action 'Apply_to_each_attachment' failed: the result of the evaluation of 'foreach' expression '@json(outputs('Get_response_details')?['body/r155b0f7dbb6746efbed08000575884de'])' is of type 'Null'. The result must be a valid array.

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @BB818U

When no attachment is uploaded by a user, the flow fails.

Pls add check for null value using if() function as the input to loop action (Apply to each). Here is the sample:

if(empty(outputs('Get_response_details')?['body/rca65ac01b82f4df5ad0da612eae33528']),[],json(outputs('Get_response_details')?['body/rca65ac01b82f4df5ad0da612eae33528']))

pls replace id with actual field id in the above expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report
Copy link

Link copied!

Hello how and where do I enter your solution? What steps do I take.

Thank you

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @BB818U

In "Apply to each attachment" action, pls replace the json() function with the below expression as its input:

if(empty(outputs('Get_response_details')?['body/rca65ac01b82f4df5ad0da612eae33528']),[],json(outputs('Get_response_details')?['body/rca65ac01b82f4df5ad0da612eae33528']))

But you need to replace the field ID with the actual one in the above expression as it is just a sample.

Pls retest the flow after replacing the expression in the "Apply to each attachment" action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report
Copy link

Link copied!

I'm getting "THE EXPRESSION IS INVALID" I used your example and updated the field ID, made sure there were no spaces ect.

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report
Copy link

Link copied!

I'm getting "THE EXPRESSION IS INVALID" I used your example and updated the field ID, made sure there were no spaces ect.

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Pls share the output of get response action from the failed flow instance. I am interested in knowing the values for attachment field in form. You can share the JSON with sample data.

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report
Copy link

Link copied!

if(empty(outputs('Get_response_details')?['body/r155b0f7dbb6746efbed08000575884de']),[],json(outputs('Get_response_details')?['body/r155b0f7dbb6746efbed08000575884de']))

This is what I have I tried to type each but its not working or pasting

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!
Please use the below expression:

if(empty(outputs('Get_response_details')?['body/r155b0f7dbb6746efbed08000575884de']),json('[]'),json(outputs('Get_response_details')?['body/r155b0f7dbb6746efbed08000575884de']))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
BB818U on at

Like (0)

Report
Copy link

Link copied!

What am I doing wrong here?

Was this reply helpful? Yes No