How to auto separate MS Lists uploads into separate Sharepoint folders using Power Automate?

Dear Lissa,

Thanks for your updates.

Adding attachments to the site list isn't related to the naming file part in the flow. So you can just add the formula in Compose after you extract the names of the form attachments in the folder in OneDrive for Business or SharePoint Online after the Parse JSON action.

Welcome to share any updates at your convenience.

Thank you for your time and effort.

Sincerely

Cliff | Microsoft Community Moderator

Hi,

The MS Form attachments are being added to a SharePoint List so the MS Form data can be reviewed and managed collaboratively. Yes, I'm using the Add Attachment action within an Apply to Each action to place the attachments to the SharePoint List.

So you're saying removing the name and number may not even be possible and the formula you advised on may be the only possibility. Alright, you've given me the formula. Where exactly am I supposed to place the formula? What action should it be applied to (assuming Apply to Each) and where in the flow I've recently noted should the action and formula be added? Please explain.

Thanks

Dear Lissa,

Thanks for your updates.

I don't know why the form attachments will be added to a site list in your environment. Generally, the form attachments will be automatically saved in OneDrive for Business or a site library in SharePoint Online. Do you use the Add attachment action to add the attachments to a site list?

However, about the name change, it is by default and you can't change it. The only feasible way is to use the formula I mentioned above to extract the name part like the following and let the flow create new files in another folder.

substring(items('Apply_to_each_6')?['name'],0,indexOf(items('Apply_to_each_6')?['name'],'_'))

substring(items('Apply_to_each_6')?['name'] , indexOf(items('Apply_to_each_6')?['name'],'.'), sub(length(items('Apply_to_each_6')?['name']),indexOf(items('Apply_to_each_6')?['name'],'.')))

Welcome to share any updates at your convenience.

Thank you for your time and effort.

Sincerely

Cliff | Microsoft Community Moderator

Thank you for this information. It has certainly resolved my issue with the toggle button.

Regarding the flow, I am running out of time for this project and am not having success with getting this to work in a single flow. As I'm pressed for time, I've created two flows (with the help of a few video tutorials). The first flow takes the data and attachments from the MS Form and adds them to the SharePoint List. The second flow takes the attachments that were added to the SharePoint List and adds those attachments to a Document Library.

I understand this isn't ideal but I need to complete this task immediately. The one problem I'm having is the file name. I need my name and the number to be removed and the attachment to maintain the file name as it is when uploaded. I believe this name change is happening in the first flow. What can I do in flow to prevent the name change so the file name remains the same when added to the SharePoint List?

Here are the two flows:

Thanks

Dear Lissa,

Thanks for your updates and I can now see the screenshots.

You need to add @ in the advanced filter array formula.

I see that you are in the new flow UI. If you prefer the classic flow UI, you can manually change the flow URL which is like https://make.powerautomate.com/environments/Default-\*\*\*/flows/\*\*\*?v3=true to https://make.powerautomate.com/environments/Default-\*\*\*/flows/\*\*\*?v3=false. You can return to the classic UI and then add the @ symbol in the formula to see the result.

The last step in the screenshots is Create file (SharePoint Online) which means that it creates the same files got from the OneDrive for Business folder in a folder in a site in SharePoint Online.

As you use the Get file content (OneDrive for Business) action, you should use the personal form and get the files from the Apps folder like https://contoso-my.sharepoint.com/personal/username\_contoso\_onmicrosoft\_com/Documents/Apps/Microsoft Forms/form name/Question in OneDrive for Business. You can go to OneDrive for Business for confirmation.

If you are using a group form, it will be saved in the folder in SharePoint Online.

In the screenshots, there seems to be no action adding the files as attachments in a list in SharePoint Online. If you do that, you need to add the Add attachment action as follows.

Could you provide the screenshots about the flow result at your side about "The data and attachments from the MS Form are being added to the MS List by the automation." for our reference?

Note: Remove any private information before uploading the screenshots.

Welcome to share any updates at your convenience.

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator