title: Adding files to Sharepoint online with foldernames and language in columns
body: <p>We have a bunch of files that we wan't to share with our business partners outside our organisation. The files are stored on our server fileshare for now, but for sharing purposes I'd like to move or sync them to Sharepoint Online file library. My files are all neatly arranged in folders for easier serching and since they're in multiple languages they all have prefix of the language en_ or de_ or sk_ etc... Folders are arranged by products, suppliers, documents types etc..</p>
  <p>When moving or syncing the files to share point file library I'd like to add extra columns to each uploaded file - one for language that should somehow be recognised from prefix of filename, others for each subdirectory in which the file stands. Adding this data in columns wold greatly help filtering the data when needed.</p>
  <p>I was looking at Power automate for solutions but I didn't find the right flow that would do what I need. Any ideas?</p>
  <p>And another question. Is there any way to automatically filter language by some property in O365 user profile so when a user visits the Sharepoint webpage only documents in his language, English or German are displayed? I know this is hard to accomplish, but I have to ask :)</p>
  <p>Thank you for any answer that helps me solve the problem....</p>