You can’t access, from Power Automate, to the information of different Excel files where no tables are created… or can you? In this post we are going to analyze the problem and see how we can troubleshoot the limitation for all our implementations. … More Consume / Read plain Excel (without table) from Power Automate
If you have worked with Business documents or with ER Excels, you have probably faced the issue of having merged cells that don’t vertically grow dinamically to be adjusted to the content. Did you know that there’s an OOB solution for it? In this post and also in below video, we are going to see it in detail, hence you can avoid making the errors I did when I discovered it and started to implement it in all my ER reports. check it out! … More D365FO Electronic Reporting: Dynamic Height (Auto-fit Height) in Excel rows with wrap text and merged cells
A detailed guide about how to deal with the delicate excel templates for Electronic Reporting. Very useful to understand and start working with the Business documents.
Many times, I’ve received questions about this topic, errors loading the templates and stuff like that… Here you are a good way to start modifying the Business documents Excel templates avoiding the most common mistakes, In this video, using examples like always, we show at least 4 of them and explain a good way of doing it:
1.Not understanding the cells/ranges names (use the NameManager!)
2.Changing stuff without consider the containing ranges (and so losing the existing mappings ): )
3.Change a name outside of the Name Manager
4.Not using labels
In this part, we are going to have 2 very different parts, in the first part we’ll see how to deal with user input data, and in the second one we are going to learn how to work with Excel format in ER, using an exporting example. … More D365FO Electronic Reporting from Scratch part 3: Use of Parameters and Excel Format
Fernitudela.dev 