hey
I'm new to power automate and see quite the potential in our organisation to use this service. First for small service but maybe later for more complex processes.
At the moment i try to automate the automatic read out of excel values. I receive different types of excel from different customers and my goal would be to build a short flow for each of this excels and save the values in a excel list/sharepoint list for further use.
My problems is that i did not find a propper function to get the values. Means this data are not formated as tabels within excel. i try to give you an example of the data i would receive:
| Header | | | |
| | | | |
| Month | Year | irrelevant row | relevant row |
| January | 2020 | 12 | 123 |
| February | 2020 | 23 | 234 |
| March | 2020 | 34 | 345 |
| .... | ... | | |
