cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
staffdill
Level: Power Up

Create local CSV file from sharepoint item made

Hello,

     I am trying to have a power app that creates an entry in sharepoint. When that entry is made to the sharepoint list I want it to create a CSV file and then store that file locally on my machine. Everything seems to work fine until the create file portion. I have the on premise gateway running, and am not sure how to get the file to create itself. Here is what I have, any help would be greatly appreciated: 

{
"status": 400,
"message": "The requested action could not be completed. Check your request parameters to make sure the path 'c:/users/dbutler/documents//New Hire - Dylan.csv' exists on your file system.\r\nclientRequestId: 9e4ebb95-9be1-4102-a824-46318bb87453",
"source": "filesystem-eus2.azconn-eus2-01.p.azurewebsites.net"
}
 
 

capture2.PNGCapture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create local CSV file from sharepoint item made

Hi @staffdill ,

 

Could you please share a screenshot of the configuration of the "Create file" action of File System connector?

I'm afraid that you haven't create a correct connection to the File System connector, please refer to link below to crreate the connection to File System:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Problem-connecting-to-File-System-in-Flow/td-...

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Create local CSV file from sharepoint item made

not had experience with this connector myself, but instead of using the gateway on what i assume is a desktop/laptop (you could get lots of failures if your computer goes to sleep etc). Why not use onedrive? You can use onedrive client to sync the files to your PC and no gateway is needed and the flow will not fail or need any setup if you need to reinstall the computer or if its turned off etc.

staffdill
Level: Power Up

Re: Create local CSV file from sharepoint item made

I am eventually going to use it on a domain controller that is running all the time, I wanted to test getting everything on my laptop first. 

The idea is to have the CSV get picked up by a task scheduler script once its sent from the flow to the folder on the DC and turned into a active directory account. 

I have had success getting the file to create into one drive, im not sure how that would work with the script if its sitting in one drive though. 

Super User
Super User

Re: Create local CSV file from sharepoint item made

Ah i understand.

 

If you did install OneDrive on the DC then it would not run when the user is not logged in so the files would not be there. You could get the task scheduler script to connect and download from onedrive directly though if you get stuck with the current plan. I suspect you can connect to it the same way as sharepoint and download the files needed

Community Support Team
Community Support Team

Re: Create local CSV file from sharepoint item made

Hi @staffdill ,

 

Could you please share a screenshot of the configuration of the "Create file" action of File System connector?

I'm afraid that you haven't create a correct connection to the File System connector, please refer to link below to crreate the connection to File System:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Problem-connecting-to-File-System-in-Flow/td-...

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,343)