let's review the syntax:
In the first place,
AddColumns: The syntax for AddColumns is:
AddColumns(SourceTable, "NewColumnName1", Expression1,
"NewColumnName2", Expression2,
"NewColumnName3", Expression3...)
In your code, you are passing column names without quotes (e.g., Permit_Name, 'Permit Name'), which is invalid. The new column names must be strings (in quotes), and the expressions must be valid formulas or references.
In the second place, how we are referencing columns inside AddColumns:
Probably you are mixing column names and values incorrectly. As an example, 'Permit Name' is suppose to be a column name, but you are using it as a value expression. You should use ThisRecord.'Permit Name' or just 'Permit Name' (if it's a column in the source table) as the expression.
In the third place, I suspect there are some inconsistent naming and usage, in my view some columns like PermitType.Value and Status.Value suggest these are choice fields or records, so you need to ensure you access them correctly.
To narrow down the issue, let's try this first:
AddColumns(
Filter(EnvironmentalPermits, FPID = varSelectedFPID),
"Permit_Name", 'Permit Name',
"Permit_Number", 'Permit Number',
"Permit_Type", PermitType.Value,
"Issue_Date", IssueDate,
"Expiration_Date", ExpirationDate,
"Extension_Date", ExtensionDate,
"Status_", Status.Value
)
Please let me know if this helps.
