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: Form_Detail: Timestamp (key) Email setup: Enum
Table: Email Setup
Unique Document name (key)
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 ?