Unanswered

How to append string variables using output from "When an item is Created"(SharePoint)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am automating the process of uploading a OneDrive file to a SharePoint list in the form of an attachment. However, I am unable to append the empty string variables using the output from the "When an item is created"(SharePoint) trigger. The intent is to upload a specific file as an attachment based on the file's name which would match with specific fields of an item on the SharePoint list. I tried creating a blank array and it did save the output from the SharePoint trigger I am unable to make specific conditional comparisons. The specific error I get is the following:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_8' failed: the result of the evaluation of 'foreach' expression '@body('When_an_item_is_created')?['value']' is of type 'Null'. The result must be a valid array.

Any help with this issue would be greatly appreciated. Thanks.

Categories:

General topics

All responses (4)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@TorresA ,

I see an issue with your trigger.

You have a recurrence trigger which starts the flow on a schedule. What that means is that you do not get the context of the item when it is created.

Remove the recurrence trigger, make "When an item is created" as your first trigger, you should be good
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am still having the same issue unfortunately.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@TorresA

Can you post a screen shot of your loop in edit/design view please?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I managed to fix that error. But I am still struggling with comparing multiple variables in a conditional statement like in the following:
All_Var is an array that holds all the variables. Is there a way to call a specific variable an array? Also, the reason I go the error from the previous comment was because I attempted to initialize the variable within two Apply for each loops. Using an array like in the picture was similar to the method I previously used, where I attempted to use a blank array.