Power Platform Community Forum Thread Details

I am working on a Power Automate flow that needs to extract the latest added row from an XLSB file and transfer the data to a SharePoint list and an Excel template.

Since Power Automate does not support XLSB files directly, I am considering two approaches:

Use an Office Script in Excel Online to extract the latest row from the XLSB file.
Convert the XLSB file to XLSX first, then use Power Automate’s List rows in a table action to extract the data.

Which approach is better for extracting data from XLSB – using an Office Script in Excel Online or converting XLSB to XLSX first?
If using an Office Script, how do I ensure the script runs even if no new data is present?
If conversion is the better approach, what is the best method to automate XLSB to XLSX conversion?

Pls Help if there any way to do this literary crying right now why it need to be xlsb format file

Categories:

Building flows

If you have the right licensing, I recommend the following:

Set Up SharePoint Folders
- In a designated SharePoint site, create two folders: one for XLSB files and another for XLSX files.
- Sync this document library to a computer capable of running Power Automate Desktop.
Automate XLSB File Storage
- When an XLSB file is received via email (or a designated inbox), automatically save it to the SharePoint folder for XLSB files.
- Use timestamped filenames to ensure uniqueness.
Trigger Power Automate Desktop for Conversion
- Create a Power Automate cloud flow that triggers when a new file is added to the XLSB folder.
- This flow will launch a Power Automate Desktop flow, which converts the XLSB file to XLSX.
- Save the converted XLSX file to the synced output folder for easy access.

🚀 Automate. Optimize. Innovate. 🚀

Helping businesses streamline workflows and maximize efficiency with Microsoft Power Platform. Let’s transform your processes and unlock new possibilities!

Explore BabyBots.ai