How to Store Files to Respective Folders.

(0) Share

Report

Posted on by nejhade

Hi Guys,

I am new to Power automate and I have this problem statement where

I have 6 country files which needs to be stored in sharepoint doc lib through flow which is getting triggered from App. but the catch is I have folder structure of these 6 Countries in sharepoint site and these 6 files go to respective folders.

For Ex:

Countries - Malaysia;Oman;Pakistan;Philippines;Switzerland;US - Deer Park

Country Abbriviation - Malaysia;Oman;Pakistan;PSPC;SBI;Deer Park

(County and country abbrivition above stored in sequence)

Country Abbriviation - File name contains these keywords then it should got to that country folder.

This can be easily achievable if I hard code these values in flow.

but going forward in future there might be more countries and I need to change the flow everytime.

So I stored these country and country abbriviationn in sql table and read those values applied split and stored values in variable.

but now I am stuck here how to apply each file compare its Abb and sent that file to exact country folder.

For Every file I have to compare its name with country abbrivition. if name contains Abb then it should go to respective country folder.

Any solution, Way of approach to this problem would be appriactied.

which datatype variable should be used how to do it.

Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
I'd probably set up a SharePoint List that could provide the mapping between Abbreviation and Country. You can then add to the list as you add more countries. This way you'd never have to update the Flow each time.

My list would look something like this:
For this example, I've setup a folder that contains the files that need to be moved (Country Files) and the destination Country folders.
For the actual Flow there are a few ways you could do it. I'd probably do the following:
Get all the items from the Countries List
Get all the files (properties only) from the Country Files folder
Loop through each of the items in the Countries List and for each one:
Filter the files to get only ones where the Name contains the country abbreviation
For each of the files that matched:
Move the file to the corresponding Country folder
See full flow below. I'll then go into details of each action.

Get items and Get files (properties only) just retrieve all the items and files (assuming you only have files in the source location - no folders):
Apply to each country loops over all the items in the Countries List.
It then uses Filter Array to filter the files using Name contains Abbreviation.
Name uses:
item()?['{Name}']
Abbreviation uses:
items('Apply_to_each_country')?['Abbreviation']
This will result in an array of files that match the current abbreviation.
Finally, it loops through each of the files that matched the abbreviation and moves each file using Move file.
File to Move uses:
items('Apply_to_each_file')?['{FullPath}']
Destination Folder uses:
concat('Shared Documents/Countries/', items('Apply_to_each_country')?['Title'])
This joins the base library/folder structure and the corresponding Country folder. You'd just need to provide your base library/folder structure.

Was this reply helpful? Yes No
nejhade 80 on at

Like (0)

Report
Copy link

Link copied!

Hi @grantjenkins

Thank you for the Great Help.
List Idea really worked here.
I have modified above solution and made to store files in respective folders.
Thanks alot.
Keep doing great work.

Was this reply helpful? Yes No