How to obtain the "Sheet Id" using the "Sheet name" from Smartsheet with UIPath

Help Studio
,
1

Hi team, I’m trying to obtain the “Sheet Id” (Smartsheet) of a sheet in a specific folder. The objective is to remove the existing file of this folder before import a new one with same name.
I would like to use the “Invoke Smartsheet Operation” (delete action) to remove the old sheet previous a new migration of a csv file with same name on the same folder (daily migration import). One of the parameters to remove the sheet is the “sheet id” but as I am creating the file the day before I just know the “sheet name” (specified during the import).So, which actions in UiPath Studio X permits to obtain the Id knowing only the name?

Thanks in advance

2

@ivan.puig ,

Use List Sheets activity https://docs.uipath.com/activities/other/latest/legacy-integrations/smartsheet-list-sheets

This will return you

  • Sheets - The sheets returned. Enter a Sheet[] variable.

Iterate through Sheet[] with For Each activity. There should be a property of each item for Id and Name

Use If activity to check Name. If match get the Id and use it further.

Thanks,
Ashok :slight_smile:

3

Hi Karale
Thanks for your quick response. I’ll implement your recomendation. My unique concern is related with the “For Each” activity itself. I have seen that on “Body” section we can include other activities, now I have “Write Line” with Text “currentItem.Name” but I cannot find the “currentItem.Id”… any idea to obtain the ID?
Later on I’ll include on the Body the statement “If”, just to check the name of my Sheet with the list of sheets. Is that right?

Thanks again