Lookup field

(0) Share

Report

Posted on by Menik

Will we see support to bind to lookup fields before GA?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Hemant Gaur Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

We are actively evaluating supporting lookups for 3rd party developers, at this point decision for GA inclusion is not locked. Please do share inputs on scenarios you are targeting which will help us prioritize. Are you trying to create a lookup control or configure one of the input values to lookup?

Was this reply helpful? Yes No
Menik 14 on at

Like (0)

Report
Copy link

Link copied!

I'm currently thinking about a read-only control where I would need the value of a lookup in order to retrieve some details.

Was this reply helpful? Yes No
Verified answer

Hemant Gaur Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Got it, thanks for info. Here are some options I can think of
1. You can try using the text field and clientAPI to set the value on this field and consume it to unblock development and user scenario.
2. Using webAPI to fetch the lookup value from within the control is another good option.
3. If the lookup is to be entered by the user , there is an API exposed in typing to launch lookup experience from within the control .

Was this reply helpful? Yes No
Hemant Gaur Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

And to optimize on the WebAPI value you can cache the data locally on browser using the setControState API so that it is available for control initialization for the next int() in the same session.

Was this reply helpful? Yes No
Menik 14 on at

Like (0)

Report
Copy link

Link copied!

Hi HermantG, Thanks for the suggestions. I was also thinking about option 1 as workaround. Option 2 won't suit the scenario since you won't be able to react to changes in the lookup value. Am I correct? Would be great to be able to bind to an Lookup field. It's the only commonly used field type that's missing support 🙂

Was this reply helpful? Yes No
Hemant Gaur Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

If you remove lookup field from form and use the lookup framework API for value update , you can capture the updated value and control can react to it. This approach however has limitations from client side PBL and validation for lookup in question. Please review and go with approach which suits your need.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@HemantG For option 1, could you be more specific? What is clientAPI? Do we have access to the page context? How can we set the value on the lookup field?

Thanks,

Was this reply helpful? Yes No
Hemant Gaur Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

For clientAPI check out the recording from my last business app summit -

Custom controls and advanced client side business logic for model-driven Microsoft PowerApps

For lookup set Value API please refer to docs here.

Also see - How to Get and Set a Lookup Field Using JavaScript in Dynamics 365

WebAPI can also be used to retrive and set the lookup value.

Was this reply helpful? Yes No
Hemant Gaur Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

chech this recording from MBAS summit last year for client API - https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-111126

Documenatation for the setValue - https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/clientapi/reference/attributes/setvalue

Was this reply helpful? Yes No
hansgfixed 37 on at

Like (0)

Report
Copy link

Link copied!

If I understand this issue correctly there is atm no way to bind a lookup field to a property declared in the manifest? I just encountered this issue and still thinking about a non-hackish way to solve this. Is there a better way than having a hidden field which triggers a workflow when data has been changed and copies it to the lookup field? I'm building an autocomplete and have to retrieve the lookup country id linked to the received iso code.

Update: Creating a duplicate field and adding an addOnChange method in the client-side form did the trick.

Was this reply helpful? Yes No