File attached to List Item > Create file in folder from Attachment > When file updated > Update List Item

[bwright]

Hello everyone,

I have been tasked with automating an external questionnaire submission process.  The list item contains various details about a request and essentially serves as a form.  The external questionnaire is attached to this item when it is created.

What I need to do is have the questionnaire completed by a user and then reviewed by a supervisor before the questionnaire is sent back out to the external submitter.  Throughout this process, I need to update a "Status" column in the list item to reflect where we are in the process of completing the questionnaire.  My thinking was to have a folder for each step of the process.  Once step is complete, the user moves the file to the next folder.  Once file is in a folder, trigger an update to the list item "Status" column.

I have worked out how to create the file from the attachment.  I cannot figure out how to get the created file to relate back to the list item that it originated from.  Is there anyway for me to associate the file with the list item so that the status can be updated?

[jordan-mccowan]

Hello, 

I believe this can be possible, but I would like to confirm a few points first.
-Are you using SharePoint lists or document libraries, or both for this process?
-Are you trying to do this process in a single Flow or multiple flows?

Please let me know as this will help with determining if it is possible.

Thanks,

Regards,

Jordan

-------

Community Support Team - Jordan McCowan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: https://docs.microsoft.com/en-us/power-platform/admin/get-help-support

[bwright]

Hi Jordan!

Thanks for responding.  I was able to build a couple of flows that achieved what I wanted by incorporating planner tasks.

When list item is created, it creates a task for a user to review the form.  When this user completes their task, it gets the attachments from the item and creates a file in a folder and updates the "status" column of the item.  I created different folders to move the file to based on where the questionnaire is in the process.  All is working well!

I will try to post the flows I used to achieve this soon!

Thanks again for replying.