Exporting data to Excel

[kaike]

This is an example of a "Proposal", and in it, there is the "Radio" column with two stations, but I want to extract their data (which are in the main table) into Excel

I'm developing an application with two tables:

1. The main one is called 'Radios', containing basic information of various radio stations.

2. The second table is called 'Proposals', where there is a column titled 'Issuers'. This column is of type enumlist and references the main table, 'Radios'.

How can I create an action that generates an Excel spreadsheet containing information about each radio station selected in a given proposal?

[AleksiAlkio · Accepted solution]

If you trigger the Bot from the Proposal record, you can write the formula in the Excel template something like <<START:SELECT(Radios[KeyColumn],IN([RadioStation],[_THISROW].[Radios]))>>

If you want to trigger the Bot from the Proposal record, you could add an additional DateTime column to your table and then action button would write new timestamp with the expression NOW().

[kaike]

The final version for my case looked like this example: <<START: SELECT(Rádios[Row ID], IN([Row ID], SPLIT([_THISROW].[Emissoras], " , ")))>><<[Row ID]>><<END>>

[kaike]

Thanks!! 

[AleksiAlkio]

You're welcome!