Get data from excel to sharepoint list then delete the excel file that was read
Hi
Try like per the below flow:
This flow triggers when email arrives in mailbox, reads the excel data & create sharepoint list and then deletes the excel file.
1. after the trigger, use the filter array action to remove the inline attachments
2. use apply to each to loop through the filtered attachments array (output of filter array action)
next steps will be explained under apply to each loop
2.1: use get attachment content to get file content.
2.2 use create file action to create the file using attachment content
2.3: use get tables action to get list of tables from created file
2.4: use list rows present in table to list out all rows in created table.
Expression:
first(outputs('Get_tables')?['body/value'])?['id']
2.5: use apply to each loop again to loop through excel data to create list item
2.6: next after items are created, outside loop, use delete file action to delete the file using its ID parameter.
Hope it helps !
Mark it as solution if it resolves your query !
Thanks & Regards,
Nived N