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

Thank you for that information but I do not understand. As mentioned, I am using 2 separate flows because I could not get the single flow to work. I provided the main actions/steps of the 2 flows recently created, none of the 2 flows include parse json as an individual action.

Please explain in detail what area of the 2 flows you are instructing the formula be added.

Thanks

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