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 ?
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])),",")))
thanks
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |