Send mail by read config

[Stef_99 (Stef)]

I have config file (now I use sheet settings, Constants)

I don’t know how to read config sheet email,
If have process error read data from row 2 and send mail
else process success read data from row 2 and send mail.

Please guide me for solve it.

[ashokkarale]

@Stef_99,

Use Read Range activity to read the Email Sheet. This will return a DataTable.

You can read this in InIt State of ReFramework and pass it to SetTransactionState.

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:
Add Try Catch into Process.xaml

Try block:

Catch block

Code:
ReFrameworkWithEmailSheet.zip (951.5 KB)

Thanks,
Ashok :

[noufalahammed]

Since there are multiple columns in this sheet, you can read this in a Datatable variable instead of Config.

Then filter it based on the Type column and use the details from filtered row of the Datatable. Make sure the Type column remains unique to avoid ambiguities.