Which template are you using? There are several: XFD, XFF, XFF Matrix, XFSetCell
Assuming you're using one of the XFF templates (which is recommended based on your post), ensure that the Named Range includes all rows and columns. The dimension token row allows you to lock onto one member (e.g. E#:[Houston Heights]) or vary each row (E#).
Thanks Chul. I confirm we're using a XFF matrix template. We have everything configured, and the form is loading. We can load both static values [ ] and different values for the rows.
I'm wondering if there's a way to avoid the template from loading any form template or any entity, to just read what's applicable for the WF Profile, similar to how PLP validates the WF Profile and sets static values in the ImportRegisterFromXLSXFile sub.
There is a readtable range method in the brapi utilities, you could use that and then get the field values and perform a validation. I guess you might have to do this in the event handler to prevent the next step (depending on how you are loading the data).
Thanks! The problem is that BRApi.Utilities.ReadExcelTableRangeContent and BRApi.Utilities.SaveTableRangeContent are only available for type TableRangeContent, and not for FormRangeContent.
