Subform in Email with Filter
I have been trying unsuccessfully for a long time to add a subform to an email with certain fields filtered out. A coworker and I were able to get his non-data source mapped subform to work appropriately, but not for this one that is mapped to a data source. Below is the different codes I've tried and their outcomes. I've used the field internal names, the SharePoint column names, top header of the subform, bottom header of the subform, etc. I need some help to figure this out. Thanks!
- Table format, extra columns
$XMLREPEATING2HTMLWITHFILTER(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:SAMPLE_x0020_ITEM_x0020_RECORDS~},{Isitemcurrentlyavailable;PackagingNeeded;ItemType;CountryofManufacture;PackagingDescriptionwithCount;VendorSample;USCertifiedCountryofManufacture;SDSNumber;Quantity;GrossWeightNumberBox;GrossWeightUnit;NetWeightNumberBox;NetWeightUnit;FabricMeasurement;FabricUnitofMeasurement;ValuePerItemNumberBox;Currency;TotalItemWeight;FreightCostPerItemNumberBox;TotalItemFreightCost;CommentsRegardingItem;Title;TaskName;DropdownList12})

- Does not work; no table format
$XMLREPEATING2HTMLWITHFILTER(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:SAMPLE_x0020_ITEM_x0020_RECORDS~},{Request ID;ItemAvailable;CountryofOrigin;GrossWeight;TotalWeight;NetWeight;TotalNetWeight;ValueperItem;UnitValueperItem;TotalValue;FreightCostperItem;TotalFreightCost;ContentTypeId;_ModerationComments;File Type;ComplianceAssetId;ID;Flow Modified;ITCStatements-Invoice;Request/ReferenceID;Modified;Created;Author;Editor;_HasCopyDestinations;_CopySource;owshiddenversion;WorkflowVersion;FileRef;Last Modified;Created Date;FSObjType;SortBehavior;FileLeafRef;UniqueId;ProgId;ScopeId;MetaInfo;_Level;_IsCurrentVersion;ItemChildCount;FolderChildCount;Restricted;OriginatorId;NoExecute;ContentVersion;_ComplianceFlags;_ComplianceTag;_ComplianceTagWrittenTime_ComplianceTagUserIdAccessPolicy_VirusStatus_VirusVendorID_VirusInfoAppAuthorAppEditorSMTotalSizeSMLastModifiedDateSMTotalFileStreamSizeSMTotalFileCount_CommentFlags_CommentCount})

- Does not work; no table format
$XMLREPEATING2HTMLWITHFILTER(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:SAMPLE_x0020_ITEM_x0020_RECORDS~},{Request ID;ItemAvailable;CountryofOrigin;GrossWeight;TotalWeight;NetWeight;TotalNetWeight;ValueperItem;UnitValueperItem;TotalValue;FreightCostperItem;TotalFreightCost})

$XMLREPEATING2HTMLWITHFILTER(${/pd:AP/pd:dataSource/pd:SharePoint/pd:SampleRequestRecords/pd:Sample_x0020_Request_x0020_Records/pd:SAMPLE_x0020_ITEM_x0020_RECORDS~},{Isitemcurrentlyavailable;PackagingNeeded;ItemType;CountryofManufacture;PackagingDescriptionwithCount;VendorSample;USCertifiedCountryofManufacture;SDSNumber;Quantity;GrossWeightNumberBox;GrossWeightUnit;NetWeightNumberBox;NetWeightUnit;FabricMeasurement;FabricUnitofMeasurement;ValuePerItemNumberBox;Currency;TotalItemWeight;FreightCostPerItemNumberBox;TotalItemFreightCost;CommentsRegardingItem;Title;TaskName;DropdownList12;Request ID;ItemAvailable;CountryofOrigin;GrossWeight;TotalWeight;NetWeight;TotalNetWeight;ValueperItem;UnitValueperItem;TotalValue;FreightCostperItem;TotalFreightCost })

Please sign in to leave a comment.
Comments
2 comments