Dynamic Excel validation

@AvnImpln you have th we option of table reference. So you might provide a table with the mandatory fields and reference that

And then check for the data types

You could further check for completely empty columns.

Another question would be if all your mandatory columns have to have entries in each row. You could check for a percentage of missings (by total count) and only keep the ones that are 100% complete.

Concerning the import your colleague got one answer for that in this thread:

3 Likes