Answered

Pull Lookup Value

(0) Share

Report

Posted on by duncant

278

I am attempting to pull data from an Entity create (create a csv report for one of my parameters, which is a lookup value, I would like to display this value in the report, but instead of the value I am given a long string of letters and numbers. How can I pull the value that is display in the entity?

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (1)

JatinSanghvi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@duncant Can you add more details to the question? Which connector and trigger did you select in the Flow? An example of what you expect and instead receive along with a screenshot will help us understand the issue and assist you.

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report
Copy link

Link copied!

I am using CDS as my connector.

If you see in the image below, you will notice that the _crd0c_cruiseid_value gives a long string, instead of the auto-number value setup when I created the entity. I would like to get the ID as well as the name or title of the value.

The csv should be seen as followed:
PassengerName,CruiseID,Age,CruiseTypeID
Andy,0001,16, 4-day
Wilma, 0002, 36, 5-day
Ginger, 0003, 54, 7-day
Jewel, 0004, 45, 4-day

Was this reply helpful? Yes No
JatinSanghvi Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@duncant , what values of 'crd0c_cruiseid' attribute do you see for those entities on the CDS application? I suspect this to be a problem with defining the custom entity/attribute within CDS. You should be able to create a new entity directly on CDS to confirm.
As far as know, the entity attribute that is used as primary key is always a GUID in CDS (I may be wrong). Are you sure that the 'auto-number' property is set on the 'crd0c_cruiseid' attribute and not on some different one?

Was this reply helpful? Yes No
Verified answer

LeeHarris 1,026 on at

Like (0)

Report
Copy link

Link copied!

Hi @duncant

In order to retrieve the values you want from the Cruise entity you will need to fetch them using the ID that you already have access to. You can do this by inserting a new Get Record action (CDS Connector) into your Flow and setting the Item Identifier value to the Dynamic Property that contains the ID. The output of this Get Record action will provide you with the values you require which you will then need to add into your CSV file.

Alternatively, you may be able to expand your initial Query to return the fields required from the related entity. More information on expanding queries can be found here https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/retrieve-related-entities-query

Was this reply helpful? Yes No
duncant 278 on at

Like (0)

Report
Copy link

Link copied!

Could you please go into detail on grabbing the lookup value within the flow?

Was this reply helpful? Yes No
LeeHarris 1,026 on at

Like (0)

Report
Copy link

Link copied!

Hi @duncant

You will need to make use of the Get Record action and request the record from CDS using the Id that you already have. The screenshot below shows a Flow that is fetching a list of Contacts from CDS and then for each one (in the Apply to Each loop) fetching the associated Parent Account using a Get Record action. You can see in the output of the Compose action that the company name from the List Records action is the Guid whereas the Name from the Get Record action is the text value.

Flow setup with List action and Get Record action

Compose action output

Hope this helps.

Was this reply helpful? Yes No