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 Apps / "Cannot use this recor...
Power Apps
Answered

"Cannot use this record. It may contain colliding fields of incompatible types."

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello, 

 

  • I'm building a telemetry "drop-in" that collects Username/email/lat/long/etc. 
  • This drop-in is in the form of a Gallery. 
  • The Gallery's items are created using what I call, Mehdi's Method of creating a collection

 

Here is the OnVisible code: 

Set(
 telemetry,
 Table(
 {header: "User Info"},
 {item: User().FullName},
 {item: Office365Users.UserProfile(User().Email).MailNickname},
 {item: Office365Users.UserProfile(User().Email).JobTitle},
 {item: Office365Users.UserProfile(User().Email).Mail},
 {header: "User Location Info"},
 {item: varLat},
 {item: varLong},
 {item: varAlt},
 {header: "User Manager"},
 {item: Office365Users.Manager(User().Email).DisplayName},
 {item: Office365Users.Manager(User().Email).Mail}
 )
)

Then the Text Property of the single label in the telemetry Gallery reads: 

If(
 IsBlank(ThisItem.header),
 ThisItem.item,
 ThisItem.header
)

The var's Lat/Long/Alt are all instantiated OnStart using Set(varLat, Location.Latitude), etc. 

 

For some reason, vars Lat/Long/Alt are giving me the error: "Cannot use this record. It may contain colliding fields of incompatible types."

 

While this is an amazing error so profess ( 🙂 ), what does it mean? 

 

Thank you

Categories:
I have the same question (0)
  • LanceDelano Profile Picture
    on at

    @lesaltzm Can you help here?

  • Verified answer
    timl Profile Picture
    37,283 Super User 2026 Season 2 on at

    Hi @ericonline

     

    I think the issue here is that the properties that you retrieve from the Office365Users data source are text, whereas your long/lat/alt values are numeric. It's this mismatch in data types that causes the 'colliding fields of incompatible types'.  Perhaps you can solve this problem by converting the long/lat/alt values to text like so?

     

    Set(
     telemetry,
     Table(
     {header: "User Info"},
     {item: User().FullName},
     {item: Office365Users.UserProfile(User().Email).MailNickname},
     {item: Office365Users.UserProfile(User().Email).JobTitle},
     {item: Office365Users.UserProfile(User().Email).Mail},
     {header: "User Location Info"},
     {item: Text(varLat)},
     {item: Text(varLong)},
     {item: Text(varAlt)},
     {header: "User Manager"},
     {item: Office365Users.Manager(User().Email).DisplayName},
     {item: Office365Users.Manager(User().Email).Mail}
     )
    )

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    "We got a winnnaaaa" ding ding ding!

     

    Nice @timl! You nailed it. It works great. 

     

    Thank you!

  • timl Profile Picture
    37,283 Super User 2026 Season 2 on at

    Thanks @ericonline, I'm glad this solved your problem.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard