Email data to excel online flow

%3CLINGO-SUB%20id%3D%22lingo-sub-358974%22%20slang%3D%22en-US%22%3EEmail%20data%20to%20excel%20online%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358974%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20currently%20trying%20to%20automate%20some%20reporting%20that%20i%20undertake%2C%20this%20particular%20report%20is%20a%20cisco%20agent%20report%20which%20monitors%20the%20status%20of%20agents%20on%20a%20cisco%20phone%20system.%3C%2FP%3E%3CP%3EI%20am%20not%20able%20to%20currently%20get%20direct%20sql%20access%20so%20i%20have%20to%20pull%20the%20data%20manually%20and%20import%20it%20to%20update%20the%20reports.%3C%2FP%3E%3CP%3Ei%20have%20recently%20found%20that%20you%20can%20email%20the%20data%20out%20in%20either%20%22Inline%20HTML%22%20%22zip%20file%20which%20has%20excel%20file%22%20or%20a%20PDF.%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20use%20any%20of%20them%20formats%20and%20email%20myself%20the%20data%20and%20then%20convert%20or%20use%20that%20data%20in%20a%20excel%20online%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20tried%20various%20different%20ways%20and%20can%20even%20manage%20to%20get%20the%20functionality%20but%20i%20can%20not%20get%20the%20right%20data%20to%20populate%20in%20the%20rows.%3C%2FP%3E%3CP%3EThe%20columns%20in%20the%20report%20are%20as%20follows%3A%3C%2FP%3E%3CP%3EAgent%20Name%2C%20Agent%20ID%2C%20State%20transition%20time%2CAgent%20State%2CReason%20code%2Cduration%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20wondering%20if%20someone%20can%20help%20me%20to%20get%20this%20working%20and%20help%20me%20to%20work%20out%20the%20best%20way%20to%20get%20this%20to%20function%20or%20linking%20me%20to%20someone%20who%20may%20have%20achieved%20this%20previously.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660593%22%20slang%3D%22en-US%22%3ERe%3A%20Email%20data%20to%20excel%20online%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660593%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5149%22%20target%3D%22_blank%22%3E%40Terry%20McCullagh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20i%20tried%20the%20parser%20you%20have%20shown%20but%20its%20not%20free%2C%20i%20managed%20to%20get%20power%20bi%20to%20allow%20me%20to%20work%20with%20zip%20files%20and%20extract%20them%20but%20now%20i%20have%20a%20new%20issue%20of%20that%20the%20format%20of%20the%20excel%20sheet%20is%20not%20supported%20in%20power%20BI%20due%20to%20been%202003%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20try%20get%20some%20inline%20html%20as%20a%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359498%22%20slang%3D%22en-US%22%3ERe%3A%20Email%20data%20to%20excel%20online%20flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359498%22%20slang%3D%22en-US%22%3E%3CP%3ERigas%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESounds%20like%20the%20columns%20aren't%20aligning%20with%20the%20desired%20text...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20some%20options%20for%20converting%20a%20table%20in%20pdf%20into%20excel%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.economicsnetwork.ac.uk%2Ftips%2Fpdf2excel%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EManually%3C%2FA%3E%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.economicsnetwork.ac.uk%2Ftips%2Fpdf2excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.economicsnetwork.ac.uk%2Ftips%2Fpdf2excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocparser.com%2Fblog%2Fmicrosoft-flow-powerapps%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAutomated%3C%2FA%3E%26nbsp%3B-%3CA%20href%3D%22https%3A%2F%2Fdocparser.com%2Fblog%2Fmicrosoft-flow-powerapps%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdocparser.com%2Fblog%2Fmicrosoft-flow-powerapps%2F%3C%2FA%3E%20(not%20free)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20could%20also%20try%20to%20manipulate%20the%20inline%20html%20file%20if%20you%20want%20to%20post%20the%20layout.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETerry%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I am currently trying to automate some reporting that i undertake, this particular report is a cisco agent report which monitors the status of agents on a cisco phone system.

I am not able to currently get direct sql access so i have to pull the data manually and import it to update the reports.

i have recently found that you can email the data out in either "Inline HTML" "zip file which has excel file" or a PDF.

I want to be able to use any of them formats and email myself the data and then convert or use that data in a excel online sheet.

 I have tried various different ways and can even manage to get the functionality but i can not get the right data to populate in the rows.

The columns in the report are as follows:

Agent Name, Agent ID, State transition time,Agent State,Reason code,duration

 

I'm wondering if someone can help me to get this working and help me to work out the best way to get this to function or linking me to someone who may have achieved this previously.

2 Replies

Rigas,

 

Sounds like the columns aren't aligning with the desired text...

 

There are some options for converting a table in pdf into excel 

 

Manuallyhttps://www.economicsnetwork.ac.uk/tips/pdf2excel

 

Automated -https://docparser.com/blog/microsoft-flow-powerapps/ (not free)

 

We could also try to manipulate the inline html file if you want to post the layout.

 

Hope this helps.

 

Terry

 

 

@Terry McCullagh 

Hello i tried the parser you have shown but its not free, i managed to get power bi to allow me to work with zip files and extract them but now i have a new issue of that the format of the excel sheet is not supported in power BI due to been 2003 excel.

 

I will try get some inline html as a example.