Dataverse table->Flow->Powerapps collection, how process lookup fields?

(0) Share

Report

Posted on by HansHeintz

704

Hoi,

I have a flow that creates a collection from a dataverse table for powerapps.

The response JSON body scheme is under here. The field cra27_contracttype is a lookup field so on that field no data is exported. I would be happy to export the value of the name field of the related table or even the guid that refers to the record as a string. Can this be done?

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "cra27_docanummer": {
 "type": "integer"
 },
 "cra27_datumkeurverkoopmedisch": {
 "type": "string"
 },
 "cra27_datumkeurverkoopgedrag": {
 "type": "string"
 },
 "cra27_userkeurverkoopgedrag": {
 "type": "string"
 },
 "cra27_userkeurverkoopmedisch": {
 "type": "string"
 },
 "cra27_contracttype": {
 "type": "string"
 },
 "cra27_blokkeerwebsite": {
 "type": "string"
 },
 "cra27_laatstelocatie": {
 "type": "string"
 }
 }
 }
}

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @HansHeintz

Yes, you can reference / pull this information form dataverse.

If you look into the outputs of list rows action, there will be fields that have the guid, and the text value.

which can be referenced and sent to power apps

Was this reply helpful? Yes No
HansHeintz 704 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I will look into how looking into the outputs works, not so much experience with flows yet.

Was this reply helpful? Yes No