Power Platform Community Forum Thread Details

Adding files to to an already created item in a SharePoint list as well as SharePoint Library from a Microsoft form

Hi there,

I just want to say in advance thank you to anyone who is able to help. I have done my best to provide as much info as I can but let me know if you need more. Also, I have searched and searched for this solution but have not found one thus why I am posting this. Apologies if I have not seen a post answering the issue.

Anyway, here it goes...

Flow Purpose

Flow 1 - Submission of form 2 commences offboarding procedure, creates record on SharePoint list, Uploads file in Form to SharePoint Library and cross-references with item in SharePoint list

Flow 2 - Submission of form 2 updates SharePoint list item with files, Uploads files in Form 2 to SharePoint Library and cross-references with item in SharePoint list (Problematic Flow)

Flow 1 & 2 are linked through a unique access number "ABCD1234"

Overview

So I have a list in SharePoint. Items are created when Form 1 is submitted based on certain conditions. This form has an attachment that is also added to the list item and then uploaded to a Sharepoint library. The item and library file are related through ID. This is working great! I have adapted from this video How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email by Reza Dorrani. However, I have a secondary flow that is causing me some grief.

I have another form, lets call it "Form 2". This form has 4 file upload questions. I would like these uploaded files to be added to the corresponding items in the aforementioned list. This will also have some logic paired with it as in the original item there are columns that need to be updated for each file via choice column "Uploaded, Pending".

The item linking the two forms is called a FAN this is a unique ID for a user.

At the moment I am just trying to get one file to "attach" to the correct item and add the attachment to the library with the "ID"

I have tried to mimic the original flow but change from "create item" to "update item" but to no avail. Currently, when I test the flow it just hangs and does not run through. I am clearly not understanding how to achieve this.

I should say that I have been able to update the appropriate list columns to "Uploaded". It is the attaching of the files to the list item and SharePoint library I am struggling with.

Below is an overview of the 2 different flows. I have also attached a zip file with more screenshots of Flow 2 i.e. the more problematic one.

Flow 1.png