Good afternoon,

I have to populate an excel template (that is standardized and can't be altered) via Plumsail's connector

What I have so far is JSON input from Powerapps, of all the changes I'd like to populate the excel template with. I'm able to populate the template so far, with changes (elements in JSON input), however, I'm only able to populate the values with the repeated elements. I presume this is because I haven't mapped out based on a condition. The JSON input has 129 objects, with 129 unique component numbers and it's corresponding data.

In the excel spreadsheet, there is a matrix that I have to populate these values with. Across 4 common columns, there are 11 "systems", which contain 'x' number of 'components' for a total of '129' unique rows of data. Each component has a unique number (e.g. 1.01, 1.02, 3.01, 6.10, etc.)

I'm looking for a solution where I can map/lookup out these elements (based on if it's a specific component#) and put it in a Compose (formatted as an array - as this is Plumsail's requirement). In the attached spreadsheet, you'll see that I've formatted the values to equate to the compose array names.

I'd appreciate any feedback. If you need more detail, please let me know!

Cheers,

Anthony

BSRM - Template - Community Version.xlsx (38.8 KB)