cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Model Driven Apps - Text Field to Lookup/Record Field

Hello,

 

I want to create a record in which I have a text entry field that will turn into a record or a lookup field after I save. This is for a user-friendly app in which users can type in a product ID into a product record, and then the product ID would become a record without having to navigate away from the page to create a product ID. I want to do this so that I can have a link to click back and forth between the Product and the Product ID.

 

Is this possible with MS Flow or business process flows?

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Model Driven Apps - Text Field to Lookup/Record Field

Hi @Anonymous ,

Do you want to use a text to update lookup field?

You could try this formula:

Patch(entityname,item,{fieldname:LookUp(relatedentity,ProductID=Text...)})

You could use Lookup function to find the related record based on your text.

Here's a blog about how to update complex data type of CDS for your reference:

https://powerapps.microsoft.com/cs-cz/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/

 

 

Best regards, 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: Model Driven Apps - Text Field to Lookup/Record Field

Hello, thank you for the response.

 

Is there a way to use the formula you provided in a model driven app? I am not using canvas apps. Each created lookup field from text will be unique so i will never use the same product ID or lookup and select a product ID.

 

An inputted text will populate a lookup field and then the lookup field will be saved under a lookup entity. 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,338)