Product in the Common Data Source
this has a lookup field titled Brand of which i have used the expand query to get two fields from the look up table as shown in the images however i cannot seem to pull the data into the create csv header it is not givving them me as options
Does anybody have any ideas? There doesn't seem to be anydocumentation anywhere for this scenario.
You have a few options. You can output your records to HTML or a SharePoint List, and then export to a CSV. This blog post, outlines both of those steps. Also, here are some example templates:
SharePoint List is what I recommend, as it has a robust connector that affords you the ability to access and manipulate the data in nearly endless ways.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @waywardm ,
Do you want to insert the two fields in Lookup table into CSV table?
Perhaps you could try the following methods to achieve the requirements.
For example, TestIDs entity has a Lookup field--AccountName from Account entity. When configuring CSV table, we need to insert the two fields contained in Account entity into the table.
Hope it helps.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.