Lookup Form Record

[dc0901]

I am submitting data via a form from one screen in my app and then trying to retrieve the data in a display form on another screen within the same app. When I type in a number that I created, I am able to pull the associated project name to that number. But what I actually want to do is pull all the data from the form so that it displays and I can't seem to make this work. Here is what I have that is working but how do I apply this same formula to the whole form?

The number referenced in the attached screenshot is a generated internal number and not the SharePoint ID number. This is what I used to pull in the project name associated with the ISSR number. 

LookUp(ccCatalog, ISSRNumber in DVPPISSRNumber.Text ).Title

[gabibalaban]

Hi @dc0901 ,

My thoughts, 

Set the OnChange property of the TextInput (where you type the ISSR| Number) to smthg like:

UpdateContext({desiredRecord:LookUp(ccCatalog,ISSRNumber = DVPPISSRNumber.Text});
ResetForm(YourForm);
EditForm(YourForm)

Also set Item property of YourForm to:

desiredRecord

And at last to be sure that your form is shown when the screen is visible, insert in OnVisible property of the screen:

NewForm(YourForm)

Hope it helps !

[dc0901]

I am receiving a delegation warning because of SharePoint but otherwise it works perfectly. Thank you for your help!