Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Excel file types

(0) ShareShare
ReportReport
Posted on by
Hi, 
 
I am trying to use the 'Get row' action to link into an excel sheet. The excel sheet in question uses macros and is there for a .XLSM file. 
When looking for the file in the action parameters I cannot find it but the .XLSX in the same folder is visible. 
 
Are there limitations on the file types that can be used with the 'Get row' action block?
  • rzaneti Profile Picture
    rzaneti 3,404 on at
    Excel file types
     
    I just want to confirm if you had a chance to test the solution recommended in my previous message.
     
    If it's working properly and answered your question, please mark it as Accepted Answer, so other users with the same issue can find it easily in the future :)
     
     
    -------------------------------------------------------------------------
  • Suggested answer
    rzaneti Profile Picture
    rzaneti 3,404 on at
    Excel file types
    Hi,
     
    There is no limitation for spreadsheets with macros. Although the .xlsm files are not displayed in the file tree of Excel actions, you can manually enter their name in the "File" input (highlighted below):
     
    The action will run successfully: 
     
    Let me know if it works for you or if you need any additional help!

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/
    https://www.linkedin.com/in/raphael-haus-zaneti/
     
  • SaiRT14 Profile Picture
    SaiRT14 1,931 on at
    Excel file types
     
    Power Automate Desktop supports interacting with macro-enabled workbooks.
    Open the workbook. Extract the required data. Close the workbook.
    This approach is more complex but allows for direct interaction with .XLSM files.
     
    If your workflows frequently depend on .XLSM files, consider automating the process of saving or exporting the data to .XLSX format to maintain compatibility with Power Automate.
     
    if you need more details, pls let me know. thanks

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard