Skip to content

Add Record URL as Conditional Formatting opens unexpected record #31

@BrendaDavis

Description

@BrendaDavis

I used PowerQueryBuilder to return records from a custom entity
#"Added Link" = Table.AddColumn(#"Changed Type", "Link", each Dyn365CEBaseURL & "/main.aspx?etn=new_Custom1&pagetype=entityrecord&id=%7b"& [new_Custom1id]&"%7d"),
#"Result" = if List.IsEmpty(ResultsList)
then ResultsTable
else #"Added Link"
in
#"Result"
I checked the data in the record GUID field., extracted the GUID from the URL, compared and there is not an issue.
In my Report I applied conditional formatting to the record name to provide a link from the Link column.
WebLinkConditionalFormatting

Here is the analysis I did on the data; note I have removed the actual link data.
PowerQuery_URL_Issue.xlsx

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions