web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Converting a Excel fil...
Power Automate
Unanswered

Converting a Excel file with dynamic range to json/dataverse

(0) ShareShare
ReportReport
Posted on by 65

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:

Mart302_0-1716886346189.png

Mart302_2-1716886407003.png

 

Mart302_1-1716886390685.png

 

I hope someone has the solution to convert the excel with formulas (for example, one formula is =I2*(1-J2) or =K8*(1+L8))

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 308

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 226 Most Valuable Professional

Last 30 days Overall leaderboard