Unanswered

Building a Power Automate Flow in my organization

(0) Share

Report

Posted on by Disney_Austin

I am working in an organization where all communication is shared through Teams, and all files can be accessed through SharePoint. The issue I am facing is one portion of the team has to fill out an excel file daily that is updated along the course of 8 hours, and at the end of the 8 hours the table in the excel sheet needs to be extracted and then placed in a OneNote file that is then emailed and distributed to a team. I have spent my entire day trying to build a flow that will do this, but face trouble when pulling the table from Excel and trying to place in OneNote. Any help or direction would be greatly appreciated. I will be monitoring this post frequently and will be better updating this with my current flow to help explain my issue further. Thank you all again for any and all assistance.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@Disney_Austin ,

You should do this in steps

First thing you should try is to put the data from excel and create an HTML Table, then build a page in Onenote and copy contents.

Excel

Flow

Output

Was this reply helpful? Yes No
Disney_Austin 8 on at

Like (0)

Report

Thank you @SudeepGhatakNZ I got to this solution as well, but am unsure how to make this cleaner and better formatted for view in OneNote? Would this require me to know some barebones HTML in order to give the table style?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

Hi @Disney_Austin ,

There are some nuances with using HTML inside OneNote.

Input and output HTML on OneNote pages in the OneNote API - Microsoft Graph | Microsoft Learn

Using inline styles seem to work

Was this reply helpful? Yes No
Disney_Austin 8 on at

Like (0)

Report

Hey Sundeep,

This is my current flow, but I am unable to find a proper solution for the "select" portion of the flow. Any help would be fantastic.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

What is that you are struggling with?

Select lets you pick the individual columns from the previous action and format them if required.

Was this reply helpful? Yes No
Disney_Austin 8 on at

Like (0)

Report

In my flow, I am creating a dynamic flow that will be triggered by placing a "theoretical" file into a specified folder. I can not pick Column 1/2 in the Mapping of the select function because the file isn't hard coded into the flow. In this instance, there is no dynamic content that matches Column 1/2. I hope I explained that enough.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

If the Excel File keeps changing, you cannot use the Select action.

Create HTML Table action supports dynamic columns, so you should be good.

However, this way you won't be able to exclude any System columns that excel might produce.

Was this reply helpful? Yes No