Hello all,
I am currently creating a cloud flow that reads an excel on onedrive and imports it into dataverse. However I am encountering the following problem:
When I import an excel where there are only static values the flow works completely. The moment I import an excel file in which values are defined on the basis of formulas, the flow no longer works.
I used the following formulas and components to convert the static excel file:
I hope someone has the solution to convert the excel with formulas (for example, one formula is =I2*(1-J2) or =K8*(1+L8))