cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RobinV86 Helper I
Helper I

Created ondrive file not accessible by action

I am creating a flow to upload a excel file to a list everytime it changes. I am using the "List Rows present in a Table"  feature, followed by 'apply to each'.

 

The file is stored on sharepoint. Because the List Rows tool required checking out a file, and flow can't do this, I set it up to first make a copy of this file on my personal onedrive. The script works until here.

 

I then added the "list rows"  tool. In this tool I am trying to locate the excel file (that now already exists there), but the script can't find it. When I browse through onedrive I can see all files except the excel file that has been copied to my onedrive by flow. Why could this be the case?

 

I've also tried manually typing in the file URL, but when I try to select the table in the next dropdown it does not show me the required excel file that just has been created, and I can only select other excel files on my onedrive. 

 

What am I doing wrong? 

(FYI, I already had some issues with the filename in the condition there because of something to do with encoded filenames, hence my variable)

Capture.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Created ondrive file not accessible by action

Hi @RobinV86 ,

 

If the file is stored  in a SharePoint Library, change the Location to SharePoint Site.

The file that can be used here must be a file that has already been created. In addition, after the file is created, we need to close Flow and then re-open Flow to select the file we have created.

Files can only be selected through File Browse. If you want to select the file generated by Create file action, this is not feasible, because this file has not been created, so it cannot be selected.

Please take a try again.

 

Best Regards,

Community Support Team _ Barry
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

1 REPLY 1
Community Support
Community Support

Re: Created ondrive file not accessible by action

Hi @RobinV86 ,

 

If the file is stored  in a SharePoint Library, change the Location to SharePoint Site.

The file that can be used here must be a file that has already been created. In addition, after the file is created, we need to close Flow and then re-open Flow to select the file we have created.

Files can only be selected through File Browse. If you want to select the file generated by Create file action, this is not feasible, because this file has not been created, so it cannot be selected.

Please take a try again.

 

Best Regards,

Community Support Team _ Barry
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 Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (8,326)