Slice with unique values in a template

[rodlaguapa]

Hi,

Thanks in advance for your help.

I am trying to create a XLSX template with list of unique e-mails of actors that are pending some sort of actvitivy. I have a table named "Monthly_Tasks" and created a slice named "PendingActions" with the following filter: "AND(IsBlank([TSK_Completion-Date]),NOT([PER_ID].[PER_Closed]))", meaning I am filtering every action which completion date is not filled for every period not yet completed.

One of the field in table/slice if the e-mail of the actors. 

I would like to compile a list of unique e-mails of every actions regardless of how many actions each of them are still working with and pass this list to a bot, aiming at running this every morning to so some reminders can be sent to them on a regular basis.

Does anyone have any clue ?

Thanks again,
Rodrigo

[AleksiAlkio]

The easy way to filter it with the slice is something like..
[KeyColumn]=MAXROW("Monthly_Tasks","_ROWNUMBER",[Email]=[_THISROW].[Email])
You can use it directly in your Bot but then using the existing slice.

[rodlaguapa]

@AleksiAlkio , 

It worked, thank you very much.

It took about 10-13 secs to compile a list of 9 emails from a list of about app 150 pending actions. Since I am new to appsheet I wonder if this is normal. The expression I applied is the below:

[Row ID]=MAXROW("Monthly_Tasks","_ROWNUMBER",AND(IsBlank([TSK_Completion-Date]),NOT([PER_ID].[PER_Closed]),[US_ID].[US_E-mail]=[_THISROW].[US_Resp_Email]))

Rodrigo

[AleksiAlkio · Accepted solution]

You're welcome. I would say it's a normal behavior.