Power Platform Community Forum Thread Details

Hello all!

Here is a screenshot of my initial landing screen, where the user types in a 5-digit location # to search for (I save their user input text as a variable called "locNum")

Here is a screenshot of my EditForm:

And lastly here is a screenshot of my SharePoint List:

Before filling out the EditForm, the SP List had 3 items: 04603, 00502, and 03413 ... Notice how in the original landing screen, the user typed in '00502'. And when I clicked the Submit button of my EditForm (using SubmitForm() function), it created that 4th item in the SP List that doesn't have a title.

My question: If 00502 already exists in the SharePoint list && the user types in 00502 in the initial landing screen (therefore creating a match), how do I patch (or update) info from Edit Form to that existing SharePoint list record? And if the user types in a 5-digit number in the landing screen that doesn't exist in the SharePoint list, create a new item registering their 5-digit number as the title of that new record?

I've tried this code but no luck so far... Thank you! 🙂