Hi All, I am trying to add a list of files t...

(Lucas Cuypers) #1

Hi All,

I am trying to add a list of files to an email workflow. the difficult part is that the info is coming from three tables.

I was thinking to add this formula in the attachment setup.

Table setup:

Table: Form_Detail: Timestamp (key) Email setup: Enum

Table: Email Setup

Topic (key)

Attachment (enumlist)

Table: Documents

Unique Document name (key)

File

First i want to get out of Setup all the documents (list) that have to be added when a certain email setup is selected in table Form_detail => Email setup

Select(Email setup[Manual PDF’s to be added in attachment],[Topic]=[_THISROW].[Email Setup])

Then i was thinking of using this list of key values to make a new list of Files. in this latest part i am stuck as i am comparing with the select formula a name with a list.

select (Documents[File],[Unique Document name]=select(Email setup[Manual PDF’s to be added in attachment],[Topic]=[_THISROW].[Email Setup]))

any ideas / help ?

(Bellave Jayaram) #2

Try this formula: SELECT (Documents[File],IN([Unique Document name], SPLIT(ANY(select(Email setup[Manual PDF’s to be added in attachment],[Topic]=[_THISROW].[Email Setup])),",")))

(Lucas Cuypers) #3

thanks