Download excel from email attachment and select sensitivity label to the downloaded excel file through studio x. (either through vba invoke code or normal automation)

Help StudioX
,
1

Hi, My organization has setup an sensitivity label in excel. I need to download the excel file from email attachment and need to input data to that excel file. For that to happen, first I need to select the label once it gets downloaded. I am looking for any invoke code solution or any workflow if present please. The pic below shows the sensitivity label that I need to select

image
image1437×88 3.69 KB

image
image780×253 3.58 KB

2

@RamboRocky,

Use this approach.

  1. Develop a workflow to open the downloaded file path. Don’t add any other logic here.
  2. In a separate workflow, add Parallel activity.
    Add Invoke Workflow File activity into Parallel to invoke the step 1 workflow and make sure you are checking the property Isolated (If this check box is selected, the invoked workflow runs in a separate Windows process. This helps us to handle other popups on excel)
    Add logic to select the sensitivity label from the popup in Parallel.

This should be enough for you to handle this scenario.

Thanks,
Ashok :slight_smile:

3

@ashokkarale hi thanks for your response. I am a bit confused here. Could you provide me an example if possible please?

4

@RamboRocky,

Hope this will help!

image

Thanks,
Ashok :slight_smile:

5

Hi Ashok,

Sorry for confusion but I am looking for that popup handling logic? The pop only comes up if you select label on the excel file
Click on this

image
image1126×46 1.78 KB

and this comes up
image

And I have 4 downloaded excel file from the email… that all needs to have label selected to General

6

Ohh! If the popup not blocking the code execution, then you can use UI interaction like Click activity for this.

My understanding was it’s blocking the execution.

Thanks,
Ashok :slight_smile: