Get the Lookup Value in the Embedded Canvas App

(0) Share

Report

Posted on by Poweruser1101

Hi All,

I have an embedded canvas app on the Model driven crm form.

I want to get the data of a related entity using LookUp formula and set it into a variable

Below are the entities i am using -

AgriStocks is the main entity on which the embedded canvas app is created.

Financial Informations is the related entity to Agristock. Financial Informations is a lookup on the AgriStock entity

i have tried the below formula in the onvisible property of the FormScreen and tried to display the value in a variable.

But it does not display anything in the label. Label is always blank.

Onvisible property of formScreen

Set(FinancialInfoRecord,LookUp('Financial Informations','Financial Information (ice_financialinformationid)'=[@ModelDrivenFormIntegration].Item.'Financial Information'.'Financial Information (ice_financialinformationid)'))

Text property of Label

FinancialInfoRecord.Name

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Poweruser1101 ,

[@ModelDrivenFormIntegration].Item.'Financial Information'.'Financial Information (ice_financialinformationid)' is empty.
You could not directly use this formula to obtain data in the 'Financial Information' table.

You ccould try to get the data of the child table from the parent table.
Please try this way to get the data of the child table:

1\ Add a label control 'Label1' and set its Text property to:
LookUp('Agri Stocks','Agri Stock' = [@ModelDrivenFormIntegration].Item.'Agri Stock').'Financial Information'.'Financial Information (ice_financialinformationid)' // 'Agri Stock' is a Unique Identifier column .

2\ Set the Visible property of the label control to:
false

3\ Add a button control and set its onselect property to:
Set(FinancialInfoRecord,LookUp('Financial Informations','Financial Information (ice_financialinformationid)'=Label1.Text))

At this time, the value of the variable is the record of the child table.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Poweruser1101 86 on at

Like (0)

Report
Copy link

Link copied!

Hey thank you. It works!

Was this reply helpful? Yes No