Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Dataflow Error

Like (0) ShareShare
ReportReport
Posted on 23 Jan 2024 20:32:33 by 147

Hi all,

 

I have a staging data flow that pulls data from our Salesforce org and creates a mirrored table in Dataverse. When I publish and try to refresh the table, I get the following error message:

 

Error Code: Mashup Exception Expression Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: We cannot convert a value of type Record to type Text. Details: Reason = Expression.Error;Value = [city = "Annapolis", country = null, geocodeAccuracy = null, latitude = null, longitude = null, postalCode = "21401", state = "MD", street = "100 West Street"];Microsoft.Data.Mashup.Error.Context = System (Request ID: a4df5e49-f969-48c3-887b-7212dc408577).

 

All of the records should be coming through as Text from Salesforce, so I am unsure of the "We cannot convert a value of type Record to type Text.", and I also attempted to remove all null values, and nothing changed. Thanks in advance for any help!

  • Verified answer
    EMKody Profile Picture
    147 on 23 Jan 2024 at 21:14:16
    Re: Dataflow Error

    I was able to fix this by removing the relationship columns that were coming over from Salesforce! 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 32

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 19 Super User 2025 Season 1

#3
WarrenBelz Profile Picture

WarrenBelz 18 Most Valuable Professional

Overall leaderboard
Loading started
Loading started