News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Report pulling in myst...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

Report pulling in mystery data lines

(0) Share

Report

Report

Posted on by L Damant

5

I created a new administrative report to pull out all the users and the related teams they were in.

This means several user names are duplicated depending on how many teams they belong to - on 4 of my 63 rows it pulls in data that does not exist in the records at all.

The incorrect data row is perfectly normal in all respects (showing the user details) but with a long alphanumeric string where the team lookup should be instead of a team name. The rest of the data is complete and accurate - these data rows are extras.

I really can't see why its pulling in this data for only 4 users and how to stop it. Any ideas?

All responses Img

All responses (2)

Answers Img

Answers (0)

L Damant 5 on at

Like (0)

Report

RE: Report pulling in mystery data lines

No you're right they do connect to a team of that name and when I checked there's a bunch of teams in the list with a guid instead of at team name. I'll go away and investigate further. Thanks - I'll close this now.
LuHao 40,872 on at

Like (0)

Report

RE: Report pulling in mystery data lines

Hi partner,

I tested in my environmnet and did not encounter this problem.

This long alphanumeric string is actually the GUID of the team.

The team name column should have a link.

Could you click on the GUID team names to see what teams will open? Is these teams normal?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans