Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : C83iI7WcOzIv7b4/cUzWVT
Power Platform Community / Forums / Power Automate - Using Flows / File fails to open bec...
Power Automate - Using Flows
Suggested answer

File fails to open because 'file format doesn't match the may not match the extension'

Like (1) ShareShare
ReportReport
Posted on 24 Jul 2024 15:03:57 by ladybird 5
Hello, 

I have no idea why I keep getting this error... Any help is appreciated! 
the concat formula is: 
concat(Concat('Simplified - ', formatDateTime(utcNow(), 'yyyy-MM-dd'), '.xlsx'))


 
Categories:
Business Process Flows
  • lbendlin Profile Picture
    lbendlin 7,697 Super User 2025 Season 1 on 09 Aug 2024 at 23:02:03
    File fails to open because 'file format doesn't match the may not match the extension'
    you seem to be trying to save an array as an Excel file?
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 35,781 Super User 2025 Season 1 on 08 Aug 2024 at 22:45:46
    File fails to open because 'file format doesn't match the may not match the extension'
    Hi
     
    What exactly are you looping on???
     
    Please share a copy of the Error, in a flow Run, that has failed, and include the inputs of the create file.
     
    I still dont understand why you are looping since the Select is on the entire Output of the list rows present in a table.
     
    SHouldn't you just have one single write, with a single set of data from your select?
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans