Showing results for 
Search instead for 
Did you mean: 
Not applicable

Model Driven Apps - Text Field to Lookup/Record Field



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?

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:


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:



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.
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


Demo-Extravaganza 2020

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


Community Highlights

Check out whats happening in Power Apps


Community User Group Member Badges

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


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)