You’re offline. This is a read only version of the page.
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
Hope this helps
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.
Hi!
Try with this approach:
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
@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.
Good news!
THere is an action block called 'Get worksheets'
https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#get-worksheets
Hope this helps
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
