cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oficina
New Member

Error in power automate

Hi

I`m not experienced in sharepoint nor power automation, but i`m trying to implement a IT helpdesk ticketing system in sharepoint by enabling users to issue a ticket from the IT site in sharepoint, allowing the IT helpdesk to receive an email with the request and the requesting user receives an email notifying that his/her ticket is being attended to....

Already have a form which should serve as the ticket and a list where the request will be presented, both with corresponding fields  Now while testing it:

 

1st step - when new response is submitted

2nd step - apply to all              

- response id              

- get response detail               

- create item              

- send email with options (to IT)              

- send email with options (to user)

 

And i keep getting this error :

 

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerOutputs()?['body/resourceData/responseId']' is of type 'Integer'. The result must be a valid array.

 

All fields are populate with the information corresponding to each field, what am i missing here??

 

Thank you.

5 REPLIES 5
muralidharan
Resolver I
Resolver I

Hi @oficina ,

Apply to each expects a collection or an array variable, whereas you're passing responseId, so it is getting failed.

It would be great, if you're share the flow screenshot and take a look at https://docs.microsoft.com/en-us/power-automate/apply-to-each .

 

Thanks,

Murali.

Please refer this post. if  you're using Forms to collect the initial data.

https://powerusers.microsoft.com/t5/Building-Flows/Updating-Item-within-SharePoint-List-using-a-From...

Hi and thanks for replying,

as I stated i`m not really that familiar with the process, i was trying to create and take as much advantage as I can from 365 features, since this company works a lot with requests which are basically only done by email...In my opinion not very effective, thus i was only following the "instructions" on this link  https://concurrency.com/blog/february-2019/create-a-simple-ticketing-system-in-sharepoint-onl  but it seems i`m missing something.

 

Here are some screen shots of my development so far though in portuguese but i`m guessing it won`t be a problem:

vendap1.jpgvendap2.jpg

Thank you.

Hi @oficina ,

You no need to use the Apply to each  and directly you should be able to read the Form response.

 

muralidharan_0-1620156692708.jpeg

 

Please refer the below link and I took the screenshot from there only. 

https://powerusers.microsoft.com/t5/Building-Flows/Updating-Item-within-SharePoint-List-using-a-From...

 

Thanks,

Murali.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (29,443)