You’re offline. This is a read only version of the page.
Announcements
Hello!
Here is a screenshot of my application's initial landing screen, where the user types in a unique, 5-digit location # to search for (I save their user input text as a variable called "locNum") a location.
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 existing 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 (with no filled in attributes/column values) and the user types in '00502' in the initial landing screen (a match), how do I patch (or update) info from Edit Form to that existing SharePoint list record? And alternatively, 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!
Hi @jharville ,
Structure would be something like this
Share
Report
All responses (
Answers (
153,061
With(
{
wID:
LookUp(
SPListName,
Title = YourLocationTextBox.Text
).ID
},
Patch(
SPListName,
If(
wID > 0,
{ID:wID},
Defaults(SPListName)
),
{YourPatchedFieldsHere}
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
