I've built something similar, to get data treated in a PBI Semantic Model and insert into an Excel file to use as a "View" for some internal customer. Great work!
Thanks for sharing your ideas, Damien! I love your videos, and I always try to apply the knowledge in my daily life I hope you keep making videos; they are very inspiring.
I agree that you can get the content from the trigger but there are limitations in the docs which can cause the files to be incomplete and appear corrupt. An interesting topic. Here’s the piece: Setting Include Attachments to Yes causes the connector to wait for all attachments to be downloaded. When many emails with attachments arrive around the same time, the connector can timeout while downloading these attachments. learn.microsoft.com/en-us/connectors/office365/#common-errors
@@DamoBird365 good to know! I recall reading something about using first() to remove the apply to each loop. My email based flows are triggered on customized emails from the source system that will only have one attachment. Perhaps in this scenario I'm okay to use fewer actions? (Trying to use Roche's maxim in my automations in that I control/reduce variability at the source as much as possible in my situation.)
I love it. I am definitely all for simplifying. I have a video demo'ing apply to each and using first. ruclips.net/video/d99Rr5djcME/видео.html It's just sometimes hard to pack all of the details into a single video but hopefully you still found something useful in this.
I've built something similar, to get data treated in a PBI Semantic Model and insert into an Excel file to use as a "View" for some internal customer. Great work!
Thanks Damo for this, looking forward to more office script videos!
Let me know what you are thinking of, would love to build something meaningful.
Well Done Damian.
@@temidayolonge4566 cheers 😍
Thanks for sharing your ideas, Damien!
I love your videos, and I always try to apply the knowledge in my daily life
I hope you keep making videos; they are very inspiring.
Thank you Tiago 😍
Do you need the get file content action? Isn't the info in the trigger? (Going from memory so I can be way off!)
I agree that you can get the content from the trigger but there are limitations in the docs which can cause the files to be incomplete and appear corrupt. An interesting topic.
Here’s the piece: Setting Include Attachments to Yes causes the connector to wait for all attachments to be downloaded. When many emails with attachments arrive around the same time, the connector can timeout while downloading these attachments. learn.microsoft.com/en-us/connectors/office365/#common-errors
@@DamoBird365 good to know!
I recall reading something about using first() to remove the apply to each loop.
My email based flows are triggered on customized emails from the source system that will only have one attachment.
Perhaps in this scenario I'm okay to use fewer actions?
(Trying to use Roche's maxim in my automations in that I control/reduce variability at the source as much as possible in my situation.)
I love it. I am definitely all for simplifying. I have a video demo'ing apply to each and using first. ruclips.net/video/d99Rr5djcME/видео.html It's just sometimes hard to pack all of the details into a single video but hopefully you still found something useful in this.
@@DamoBird365 always! Inspiration at the least. And the comments are generally gold too!
My only problem is that it does not work on the excel app.
What doesn’t work? Can you tell me more? Do you get an error? Is this a product limitation you’re referring to?