Using a loop to build multiple tables as needed and pushing them into a list. Then concatenating all tables from the list for the return statement. Here is my working code, hope it helps!
Again, thanks to @NorthSouthGIS for inspiring the solution that worked for me.
// Establish a connection to the ArcGIS Portal
var portal_con = Portal('https://gis.domain.com/portal');
// Retrieve a feature set by Portal item ID and select relevant fields
var fs = FeatureSetByPortalItem(portal_con, '9d41bd4a518947a28ac549d48f1a6539', 0,
['LEASE_NUMBER', 'COMPANY_NAME', 'ASGN_PCT', 'ALQT_ID', 'DESCRIPTION', 'AREA_BLOCK']);
// Active feature lease number for defining the filter
var lease = $feature.Lease;
// Define the query string to filter records based on the active lease
var lease_filter = 'LEASE_NUMBER = @lease';
// Filter the feature set using the lease filter
var records = Filter(fs, lease_filter);
// Initialize an empty list to store unique ALQT_IDs and a dictionary for descriptions
var alqs = []; // List to hold retrieved ALQT_IDs
var descs = {}; // Dictionary to map ALQT_ID to legal descriptions
// Loop through the filtered records to populate ALQT_IDs and their descriptions
for (var record in records) {
// Construct a description based on the record's DESCRIPTION and AREA_BLOCK
var desc = '';
if (IsEmpty(record.DESCRIPTION)) {
desc = 'All of lease ' + lease + ' within block ' + record.AREA_BLOCK;
} else {
desc = record.DESCRIPTION + ' of block ' + record.AREA_BLOCK;
}
// Store the description in the dictionary, keyed by ALQT_ID
descs[record.ALQT_ID] = desc;
// Add the ALQT_ID to the list
Push(alqs, record.ALQT_ID);
}
// Remove duplicate ALQT_IDs to ensure uniqueness
var alqs = Distinct(alqs);
// Initialize an empty list to hold the generated HTML tables
var tables = [];
// Check if there are any ALQT_IDs to process
if (!IsEmpty(alqs)) {
// Loop through the distinct ALQT_IDs
for (var alq in alqs) {
var curr_alq = alqs[alq]; // Current ALQT_ID being processed
var alq_filter = 'ALQT_ID = @curr_alq'; // Query string for filtering by ALQT_ID
var alq_records = Filter(records, alq_filter); // Filter records by the current ALQT_ID
// Fields to be included in the output table
var data_fields = ['COMPANY_NAME', 'ASGN_PCT'];
// Initialize an empty list to store the HTML rows for the current table
var rows = [];
// Loop through the filtered records for the current ALQT_ID
for (var alq_record in alq_records) {
var row_data = []; // Initialize a list to hold the data cells for the current row
// Loop through the data fields to build each cell
for (var field in data_fields) {
Push(row_data, '<td style="border: 1px solid #ddd;padding: 8px;">' + alq_record[data_fields[field]] + '</td>');
}
// Combine the cells into an HTML row and add it to the rows list
var row = '<tr style="border: 1px solid #ddd;padding: 8px;">' + concatenate(row_data) + '</tr>';
Push(rows, row);
}
// Define the header fields for the table
var header_fields = ['Company', 'Interest'];
var headers = []; // Initialize a list to hold the header cells
// Loop through the header fields and create styled header cells
for (var header_field in header_fields) {
var field = header_fields[header_field];
Push(headers, '<th style="color:black; border: 1px solid #A9A9A9;padding: 8px;background-color: #eee;">' + field + '</th>');
}
// Combine the header cells into an HTML header row
var headerRow = '<tr style="border: 1px solid #A9A9A9;padding: 8px;">' + concatenate(headers) + '</tr>';
// Construct the full HTML table, including the description and rows
var table = '<h7><b>' + descs[curr_alq] + '</b></h7>' +
'<table style="font-family: arial, sans-serif;border-collapse: collapse;text-align: left;">' +
headerRow + concatenate(rows) + '</table></div>';
// Add the table to the list of tables
Push(tables, table);
}
// Combine all tables into a single output string, separated by line breaks
var output_text = '<h3>Record Title Ownership</h3>' + concatenate(tables, "<br>");
// Return the output text as the result
return { type: 'text', text: output_text };
}
