ITLec / PowerQueryBuilder

13 stars 5 forks source link

Unique Identifier field name issue in link URL #23

Open FlossBI opened 5 years ago

FlossBI commented 5 years ago

When using some tables it generates an error in the Link field after ticking Add Record URL. It doesn't recognise the GUID name. It's looking for the logical name of the entity with id on the end. So, when using the activity pointer table it will seek activitypointerid - the GUIDs in this table are from activityid. Appointment is the same. It seeks appointmentid when these are in activityid. Where the GUID field matches the name of the logical entity name i.e. account and accountid it works.