Skip to main content

Notifications

Power Automate - Building Flows
Answered

Read data from excel file without table

Posted on by 502
Hi

What is the best solution to read data from excel file with out table.

I have made a flow copying an excel file everyday at midnight, from our customers sharepoint to our own sharepoint  (Deleting old file), filename
always the same.

Customer dont want us to make any changes in the sheet (No table and filtered).

I have tried to "Create table", but not possible with filtered excel file, and even if I remove filter manually, i get
the failure "Over lapping table".

I dont have access to Premium license

Regards

Tony
 
  • Verified answer
    Thansson Profile Picture
    Thansson 502 on at
    Read data from excel file without table
    Hi
     
     
    Solved by using excel script
     
     
    Regards
     
    Tony
     
     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard