web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Created ondrive file n...
Power Automate
Answered

Created ondrive file not accessible by action

(0) ShareShare
ReportReport
Posted on by 45

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

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-bacao-msft Profile Picture
    Microsoft Employee on at

    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,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 308 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 171 Super User 2026 Season 2

#3
Haque Profile Picture

Haque 137 Super User 2026 Season 2

Last 30 days Overall leaderboard