Hello.
I'm a newbie in all-things 'Flow'. I've tried getting to grips with a couple of tutorials, but can't find one that suits my needs... I'm unsure whether this is because nobody else is trying to do what I am doing, or whether it is because Office 365 simply isn't capable of doing what I'd like to do.
Nevertheless, I turn to the Power Users Community for assistance.
I work in the bus industry. It's a large company with over 600 vehicles based at around 8 different sites. Each morning, a member of the Engineering Team at each site fills in an Excel Spreadsheet which is shared from my own OneDrive account, indicating the vehicles which are unfit for service that day, why, and when each vehicle is expected to return to service.
The spreadsheet is the same file every day, but it is just updated each day with the content for that day.
At the moment, a member of the administration staff in our Head Office exports each sheet in the Excel Workbook out and saves the 10(ish) sheet workbook out as a combined PDF. Once this is done, a copy of the PDF is e-mailed out to a set distribution list, each morning, at around 09:30am.
What I'm looking to do in Flow is automate this process. I've read bits and pieces which seem to suggest something like this is possible, but I'm really not sure how to piece it all together.
So:
- for a selected file [navigate to file in my OneDrive]
- at time 09:30am
- save Excel Workbook as a PDF
- then send an e-mail to [list of people]
- attach a copy of the PDF which has just been saved.
Thanks in advance!
Thank you sooooo much! That is exactly what I'm looking for.
It is perfect. Thanks
How can this be accomplished with sharepoint files?
Can Flow convert each worksheet within a workbook to individual PDF's?
I am having the same issue as well regarding converted pdf defaulting to landscape orientation and not fitting data into one page. Was there a resolution to this.
Does the conversion process to pdf considers all the page setup related instructions setup in excel? Additionally, is there a way to pass parameters to pdf conversion to manipulate pdf rendering
I am receiving Convert File flow error . Status error code is 406
Hi
Have a similair problem, Iam working with excel sheets in sharepoint and want to have a flow started when I set it to publish status.
So FLOW should be like this : Excel-status-publish-create PDF - Send PDF
Kind regards Lars
Was this a hint towards how to resolve the issue with the PDF defaulting to landscape orientation? I've been looking everywhere for that solution as if I could find a way to make that stop and print portrait, I resolve a HUGE issue with a document conversation issue that dramatically impacts the office (but still not so much of a hassle that I can justify buying a 3rd-party PDF solution)
Details please!
Hello,
I am having this same issue. Can someone please address?
Thanks
Can you clarify how you change the layout orientation of your Excel table content to portrait?
WarrenBelz
146,771
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional