Share
Report
387Hello,
I have a requirement to generate a CSV file which will contain data from multiple source tables and likely require some code logic. I will need to export project data (ProjTable) including the forecast records (ProjForecastEmpl and ProjForecastCost), then within the same CSV file but as separate lines, pull in project category (ProjCategory).
| Type | Value | Description | Related code | Related value |
| Project | PROJ001 | Extraction | Category code | ERF1 |
| Project | PROJ001 | Seeding | Category code | SRF1 |
| Category code | ERF1 | Mobilization | ||
| Category code | SRF1 | Retention |
Ideally, I would like to be able to generate the extract using a custom data entity (if possible) so a Power Automate job could trigger, create, and handle transmission of the file. I would likely need to add logic in code to ensure I send only required category codes.
I could create a batch job to generate/load the data into a temp (or regular) table, but the export of that data to a format that Power Automate would then be an unknown for me. Maybe a data entity would make the most sense here after the data is 'staged'.
Without knowing all the minute details, which one sounds the best options, and what other options have I not considered?
All responses (
Answers (
