Hey,
I am relatively new, but am stumped. I have a dataflow that retrieves data from an excel file and inputs it into a dataverse table. Unfortunately, not all of the data columns are being imported.
The dataverse table has columns that are populated from another table in dropdown style (Mr, Mrs, Miss).
Is there any way to have the table recognize the inputs from excel and populate them accordingly?