Copy values from a list and make a filter into a report

Help StudioX
, , ,
1

Hello,

Could you help me with a situation in STUDIO X
I need to filter a report (xls) based on a list (the list is in the picture) and the send an email.
I made it… but is with hard data… so I place in activities all data from filters one by one and then to email address. And it this case the list in not important anymore.

I need to read first line from the list and with that value to make a filter in another report sheet, then to send an email to an adrress that is near first line from the list.
Next is to read second line from the list and with that value to make a filter in report sheet then to send an email to an adrress that is near second line from the list.

If you could guide me with the process.

Thank you
list

2

Hi @DorinZ

May I know what are the activities you have used and in which area you are facing the issue? and how you are filtering the data in other report sheet?

3

Hi @DorinZ ,

Steps to achieve this task is -

1 - Read the excel shown in image and put output in dt1.
2 - Read another excel and put output in dt2.
2 - Use foreachrow to iterate each item from dt1.
3 - Use filteractivity to check client exist in dt2 or not.
4 - If exist send email

Everything will be in loop excluding reading excels.

4

@DorinZ - Is it possible to share the sample sheet?