In a loop i need to save a xml or excel file and use it after how can i select the good one

Help Forum
,
1

After getting a attachement file ( xml or excel) from a email, i need to save the file and use it after. but the process is not the same if its a xml file or an excel file, how can i select the good one

2

HI,

There are some ways to achieve it. How about using Switch activity as the following?

image
image681×782 22.3 KB

Regards,

3

@Yoichi
How the bot can know that is a xml file ?

4

@Soudios

By using the extension as mentioned by @Yoichi

Cheers

5

@Yoichi @Anil_G

I have this issue : System.IO.Path.GetExtension(CurrentPieceJointe)

The image shows a programming error in a state machine workflow where an implicit conversion from 'IEnumerable' to 'String' is disallowed by Option Strict On, with a highlighted message box displaying the error code BC30512. (Captioned by AI)
The image shows a programming error in a state machine workflow where an implicit conversion from 'IEnumerable' to 'String' is disallowed by Option Strict On, with a highlighted message box displaying the error code BC30512. (Captioned by AI)865×398 22.2 KB

The image shows a programming interface in which a System.IO.Path method is being assigned to a file extension variable, accompanied by some variable definitions at the bottom. (Captioned by AI)
The image shows a programming interface in which a System.IO.Path method is being assigned to a file extension variable, accompanied by some variable definitions at the bottom. (Captioned by AI)1163×626 38 KB

Questions :

The output of save attachment its what i need to put in list of item ?
What is the variable type of strExt ?

6

Hi @Soudios

Please make the variable type of File extension as string also the CurrentPieceJointe type should be string.
The output of save attachment is of type System.Collections.Generic.IEnumerable<System.String>

7

@rashmisingh2695

The variable in list item is the output of save attachment ? or i need to create a new one ?

And What is the variable type of strExt ?

8

strExt is of type string
You need to use the list output of Save attachment activity

9

Like this ? When i chose string for File Extension ( strExt for Yoichi ) i have this issue :

This image shows a UiPath workflow with a highlighted error message indicating a type mismatch between 'IEnumerable(Of String)' and 'String'. (Captioned by AI)
This image shows a UiPath workflow with a highlighted error message indicating a type mismatch between 'IEnumerable(Of String)' and 'String'. (Captioned by AI)1568×538 101 KB

10

The image shows a workflow in UiPath Studio for saving email attachments to a specified folder, iterating through each attachment, and assigning the file extension to a variable. (Captioned by AI)
The image shows a workflow in UiPath Studio for saving email attachments to a specified folder, iterating through each attachment, and assigning the file extension to a variable. (Captioned by AI)1495×610 80.2 KB

image
The image shows a table with three rows, displaying variable names (strPath, strExt, attachment), their types (String, String, IEnumerable<String>), and their respective category (Sequence, Sequence, Main Sequence) with empty fields for entering VB expressions. (Captioned by AI)
The image shows a table with three rows, displaying variable names (strPath, strExt, attachment), their types (String, String, IEnumerable<String>), and their respective category (Sequence, Sequence, Main Sequence) with empty fields for entering VB expressions. (Captioned by AI)946×121 5.04 KB

11

@rashmisingh2695

i can’t see what you put on the propreties FOR Each

This image shows a section of a UiPath workflow with a "For Each" activity iterating over "PieceJointe" items and attempting to get the file extension of each item, which has validation errors indicated by warning and error icons. (Captioned by AI)
This image shows a section of a UiPath workflow with a "For Each" activity iterating over "PieceJointe" items and attempting to get the file extension of each item, which has validation errors indicated by warning and error icons. (Captioned by AI)1321×335 59.9 KB

12

This image shows the properties panel for a "ForEach" activity in UiPath, configured to iterate over a list of strings with properties such as "Item name," "Argument type," "Condition," "Max Iterations," and an output index named "CurrentIndex." (Captioned by AI)
This image shows the properties panel for a "ForEach" activity in UiPath, configured to iterate over a list of strings with properties such as "Item name," "Argument type," "Condition," "Max Iterations," and an output index named "CurrentIndex." (Captioned by AI)472×508 14.2 KB

13

@Anil_G @Yoichi
why its not working for me ?

@rashmisingh2695 can you send me your xaml file plz ?

14

@Soudios

Fileextension varible type should be on type string…please change the same

And inside getextension use currentitem /currentplacejointe

Cheers

15

Please check this xaml and let me know if it works.
GetExtension.xaml (10.6 KB)

16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.