Move files from Tenant to one drive/ sharepoint- Power Automate

@Ashley Gelderblom
it depends on what you trying to achieve, you may need RE:Queue which is another service you need to buy from Blackbaud.

Can you explain more on what you mean by “move docs from the hosted tenant area”? What docs are you talking about, how are the docs created? Are you hosted on Azure or bb data center (not sure if that's the terminology)

@Ashley Gelderblom
there's 2 ways you can go about this.

• create a flow that trigger on file modified on a sFTP connector trigger
  • you can monitor specific folder for changes
  • when the change happened, you just take the content of the file (that comes from the dynamic content of the trigger) and create a new SharePoint file with it
  • depending on what file you are trying to download, the method is a little different, excel of word (your original post say “docs” but you reply say csvs)
    

• create a flow that trigger on schedule
  • if you set your RE:Queue to export at certain time of day, and you know your export will take 10 minutes, you can create a schedule flow that runs ~15-30 minutes after your RE:Queue scheduled run time, and take all the files in a folder.
  • you will do the same with each file as mentioned above

@Dan Snyder
good stuff.

Your post require the use of Encodian, which is free to some extent, but need to paid if you do anything more than a few actions a day.

There is a free option to use if you also have M365 license for excel (most probably already do).

Basically, it uses a Excel connector action for running a “script” that takes in csv and put the csv data into an excel file. You can read more about it here:

https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv

Basically Office Script is a TypeScript which is a “stricter” version of JavaScript, so not exactly for the low-coder, however, the link above provide you with the code to use, so you should be ok.

@Heather McLean
Not sure if you want to (since this is a “pro-code” option, but “no-code” in the sense that the code is provided to you), but I have heard many that wants to take csv into excel and maybe good for the next PowerAutomate User Group to show?

@Dan Snyder
@Ashley Gelderblom

Here's a post for CSV to Excel:

@Ashley Gelderblom
You can find it here:

@Ashley Gelderblom
Open Hosted Files from RE NXT

click on “Tenant File Share UNC Path”, which you will get this long alpha-numeric string,

The folder path is going to be:

/C:/FTPHome/1b293c******************************1b8$/FTP/REQueueAutomation

FTP and REQueueAutomation is the folder name drilling down from UNC Path.

This is how it is in Azure hosted RE NXT, I know it is different if you are Blackbaud hosted. You will need others (or support's) help if you are Blackbaud hosted.

@Ashley Gelderblom How I was taught to get that information was to set up a connection via FileZilla and from there you will be able to grab the file path that you can paste into that step. Here is a guide to connecting to the hosted files with FileZilla.

Once you are connected, you will navigate to the location/folder where your files land and then you can grab the file path to use in your flow.

@Alex Wong, I just found this thread and this is exactly the problem I want to solve. But will I need to keep after updating my FTP password every 90 days top keep this working?