MS Search - External Items - property added/listed twice

[kasperbolarsen]

I have just added the property "customerName" from my external datasource, and it seems like it is added twice, once as customerName and once as resource.properties.customerName

I would expect it to be listed once, and preferably just as customerName

[wobba]

How did you add it? Issues not following the issue template will be closed.

[kasperbolarsen]

Version 4.13.1
Browser Edge

Steps

1. add Results web part to new page
2. select Microsoft Search as source
3. Set Entity type to "External Items"
4. set Content sources to "AzureSqlConnector3"
5. check the values in "Selected fields", none of the fields from the Content source is there
6. Check the schema for the Content source in the Search and Intelligence center
7. copy the Source property name for one of the field, in this case CustomerName
8. add CustomerName to Selected Fields
9. change the layout to Details List
10. select Manage columns
11. open the dropdown for Column value

[wobba]

I assume only the resource version should be kept?

[gretchunkim]

When using the external items, I also see what you are describing above. However, I think it's because I have identified the property information to be pulled (because it is not automatically done so and it's a requirement for external item).

Have you look into debug mode/view to see if it is listed only once there, correct? This is the case for me. I notice only one of the value works, typically the one that I manually typed/identified in External Items property field.

[wobba]

I think it's due to the request name being Foo when you add it, and the returned value being resource.Foo, and the list puts the two together. Should the web parts hide away the resource version?

Not sure how best/easiest to merge the input list you can edit vs the output list used to pick a field as the prop names are different due to how Graph return data.