Тёмный

Microsoft Power Automate: How to convert Excel (.xlsx) to .csv files - Full Tutorial 

Anders Jensen
Подписаться 65 тыс.
Просмотров 52 тыс.
50% 1

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

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 86   
Далее