Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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

#1
WarrenBelz Profile Picture

WarrenBelz 146,765 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Liquid error: parsing "/?redirectedFrom=https://community.powerplatform.com/t5/Power-Platform-and-Dynamics-365'%22/(/Select-record-from-grid-retrieve-Identifier-in-Power-automate/m-p/2494831" - Not enough )'s.
Loading started