I have a flow which takes an excel file when the file is dropped in a folder.
I need to get the data from the columns into a sharepoint list but I cant seem to map the data in my apply to each loop.
I needed a filter array after the list rows present because there are empty rows that need dealing with.
When it comes to creating items in the loop (for each row of excel data) there is no way to map the excel columns to the sharepoint columns.
I tried a parse json after the filter array but that doesnt work.
I tried adding code like
item()?['WORK TYPE'] into the appropriate fields but it doesnt work.
Maybe its the schema i was using for the parse json but i tried all sorts of options using AI to help.
