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 / Is there any way to ch...
Power Automate
Answered

Is there any way to check if provided worksheet name is exists or not in excel?

(0) ShareShare
ReportReport
Posted on by 38
Hi, I have sharepoint doc library, where excel is uploaded. I wanted to check if particular worksheet is exists or not in the file. Thanks in advance !
Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Good news!

    THere is an action block called 'Get worksheets'

    https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#get-worksheets

    Hope this helps

  • PratikD21 Profile Picture
    38 on at

    @efialttes I have tried, but not able to validate. The requirement is like these users will upload an excel file to SP Doc Library which contains multiple spreadsheets. And, we have a Configuration List where the Spreadsheet  name is stored as one of the item.

     

    Now, i am able to get SP List Item with value but not able compare with Get worksheets connectos repsponse.

     

    Any example/flow diagram for comparison would be helpful.

     

    Thanks.

  • efialttes Profile Picture
    14,756 on at

    Hi!

    Try with this approach:

    Flow_worksheets.png

    So you can see 'Get worksheets' output is an array whose elements are objects, each objects represents one workshhet, one of its attributes is 'name'.

    Hope this helps

  • PratikD21 Profile Picture
    38 on at

    Hi,

     

    Thank you for your response. I am newbie to this technology and not aware how to find/compare string value in the response.

     

    Could you please help me in this.

     

    Thanks.

  • Verified answer
    efialttes Profile Picture
    14,756 on at

    Eh voila! Just replace 'myTargetWorksheetName' with the one you are looking for.

    I am assuming in an Excel doc, two worksheets cannot share the same name, so if length is not 1, then it means target worksheet is not defined inside

     

    Flow_WorksheetExists.png

    Hope this helps

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard