Display file links from specific Forms questions into separate categorical Sharepoint list columns

[NPA_User]

Hello, I am not very versed in Power Automate flow operations, so please excuse my ignorance.  I’ve created a Forms questionnaire with 15 File Upload questions (in addition to other questions).  Currently, I’ve been able to create a flow which populates a single Sharepoint List multiline enhanced rich text column with a link to each of the 15 files (although, I believe the row height of the column is limited to 5 rows due to HTML constraints, so it is missing 10 of the files).  For more reasons than one, I would like to display the file links from specific questions into three categorical columns (actually eight, but three for example purposes of this forum).  I think I’ve managed to do that using the flow, below, but now the columns display a bunch of junk rather than the file links that were displayed in my original flow.

Here is what used to display when I created a single Initialize Variable to display the links in a single column:

Here is what I’d like to display by creating three Initialize Variables to display the links into three columns:

Here is what actually displays now:

(Current output from Column A, with junk in green text): 

[[{"name":"1_[REDACTED]16.docx","link":"https:// [REDACTED]my.sharepoint.com/[REDACTED]/_layouts/15/Doc.aspx?sourcedoc[REDACTED]&file=1_[REDACTED]":null,"size":11979,"referenceId":"[REDACTED]","driveId":"[REDACTED]","status":1,"uploadSessionUrl":null}],[{"name":"2_[REDACTED].docx","link":"https:// [REDACTED]my.sharepoint.com/[REDACTED]/_layouts/15/Doc.aspx?sourcedoc[REDACTED]&file=2_[REDACTED].docx&action=default&mobileredirect=true","id":"[REDACTED]","type":null,"size":11987,"referenceId":"[REDACTED]","driveId":"[REDACTED]","status":1,"uploadSessionUrl":null}]]<b>Doc 1: </b><a href="Column A Doc 1 File URL">Download file</a><br><b>Doc 2: </b><a href="Column A Doc 2 File URL">Download file</a><br>

And here is my flow:

(The Name field, above, should actually say, "varFileUploadsColumnA" if I had used the correct screenshot)

Can you please walk me through how to correct my flow in order to display the intended file links by column?  Thank you in advance for any help you can provide.

[Nived_Nambiar]

Hi @NPA_User 

If i am right,

You have a form with having with questions with each questions of having 15 file uploads questions.

Now when the form is submitted, you want the bot to add the each 15 questions file upload to the new sharepoint column?

[NPA_User]

Hi Nived,

Thanks for your response.  Yes, I have one form with 15 file upload questions.  Each question is related to one of three topics.  I would like to have three List columns that reflect the three topics, and group the links for each file into their related columns so that when you look at each column, you can see which files have been uploaded for that topic.  I hope that helps clarify things.  I'll also add that the file upload questions are optional, not required.  But I'll add that condition after I get the current flow to work.

Thanks,

NPA_User

[Nived_Nambiar]

Hi @NPA_User 

Got it, so for 3 question we need to add 3 column data with each data having file links (5 files each)

So one question, does the number of questions remains same or will it change ?

[NPA_User]

Hi @Nived_Nambiar,

Yes, I think that description is correct.  The mapping from question to column is fixed, so the number of questions should remain the same.  For example, the files from questions 1-5 would always map to Column A; the files from questions 6-10 would always map to Column B; and the files from questions 11-15 would always map to Column C.

Thanks,

NPA_User

[NPA_User]

Hello, I am still looking for a solution on how to resolve my issue if anybody is able to help.  Thanks in advance.