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