This video tutorial shows, how to convert Excel (.xlsx) table data to .csv files in Microsoft Power Automate.
You could also watch:
🔵 Microsoft Power Automate Tutorial for Beginners - • Microsoft Power Automa...
🔵 Microsoft Power Automate Use Cases - • Microsoft Power Automa...
0:15 Our Excel Sheet is stored in OneDrive
We store our data in an Excel sheet in OneDrive. The solution also works, if the sheet is store in e.g. SharePoint.
0:46 Create a new Power Automate Flow
We create an instant flow and manually trigger it.
1:45 Get tables
We get the Excel table with our data.
2:22 List rows present in a table
List all the rows with data, so we can work with them in the next Power Automate steps.
2:53 Create CSV table
We create a CSV table with our data columns. We could chose to take all columns from or .xlsx file or specify which one, we want to use.
3:51 Apply to each
To get all the data we chose an Apply to each, where we iterate through each of our tables.
4:18 Create file
Create our .csv file in OneDrive. Again we can create it in e.g. SharePoint, if we wanted.
📚 Best Power Automate Book - geni.us/cKCS
Connect with me:
🔔 Subscribe - www.youtube.com...
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - andersjensen.o...
#microsoft #powerautomate #excel
18 сен 2024