Ran workflow - sheet remains blank, data not pulled from most recent attachment
I am trying to create a workflow that will merge data/adds rows when a new file is attached but every time I run the workflow, the sheet remains blank. After I attached the file, I deleted the data to ensure the workflow was working properly. See the steps I followed below. I have tried both options listed for 'source field mapping' - 'run on' & '2/18/23'. Any help is appreciated.
Answers
-
Have you set everything as not mapped? If there are no columns mapped, then nothing will be pulled over.
-
@Paul Newcome I noticed if I upload as a csv - the sheet columns automatically map. The source field names match the sheet column names. With an excel file, I only have the option to map to 'run on' and '2023-18-02' and not the sheet column names. I want to upload as an excel sheet to keep some of the formatting. Do you know why the sheet column names (right) are not populating in the source field (left) with an excel sheet?
-
I've not run into that issue before. When you set it as an xlsx source, are you changing any of the source settings such as the checkbox to indicate there are column headers in the source or anythign?
