Transfering data from one Sharepoint list to another - attachments, updates and multiple choices

Question

Hello,

I'm trying to keep my automation formula very simple. Here is what we are trying to achieve. We have two Sharepoint lists. One list is where users can fill out the form and review their requests and the other list is where administrators can evaluate the requests. I can't go into details of the data that is being transfered but my flow is simple : When an item is created > Get items > Create item > Get attachements > Apply to each ( Get content of the attachment > Add attachement)

What I need and what my simple flow isn't doing right now

1. Not copying multiple choices from USER list to ADMIN list
2. Not updating the USER list and Admin list if the user switches out an attachment or changes something in his form

How would my flow need to look like in order to transfer what my Admin need to evaluate the data from the form in the USER list (which includes multiple choice values, automatic user updates, attachement and updated attachments. A detailed screen grab of how the flow looks in PowerAutomate would definetly help.

Thanks

Answer 1

Hi @Kerlyne Dejean ,

Welcome to Q&A Forum!

Please following steps:

1.Create two lists named "USER" and "ADMIN"

2.Create MS Flow

a.Add "When an item is created" trigger

b.Add "Initialize variable" action

• Name: varChoice
• Type: Array

c.Add "Append to array variable" action

• Name: varChoice

d.Add "Get attachments" action

• Id: ID from "When an item is created"

e.Add "Create item" action

• Multi-Choice: varChoice from "Variables"

f.Add "Get attachment content" action

• Id: ID from "Create item"
• File Identifier: Id from "Get attachments"

g.Add "Add attachment" action

• Id: ID from "Create item"
• File Name: DisplayName from "Get attachments"
• File Content: Attachment Content from "Get attachment content"

The full flow:

3.Test and Save this flow.

Thanks,
Echo Du

=======================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.