You’re offline. This is a read only version of the page.
20
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.
Solved the problem. I started over from scratch. Essentially the file path was not referencing correctly and as I was using test files and repeat values it was causing conflicts with file name etc. Also there were issues with the IDs i was using. The lesson for me here is to check and check again and break each section into parts and test iteratively. This make it a lot easier to find any problem as they emerge one iteration at a time. Anyway here is a portion of the updated working flow. The entire flow is yet to be updated but it is a copy and paste job 😜
Share
Report
All responses (
Answers (
