Category: Patch
Data - How to update a record if it exists, or insert a new record if it doesn't exist
There's sometimes the requirement to create a data entry screen that either updates a record if it exists, or to insert a new record it doesn't exist. This post walks through how we can carry out this task.
Recent Posts
- Email - How to send mail with the Gmail connector
- Teams - The easiest way to add a message to a Microsoft Teams channel
- Controls - How to enter and display Office/Microsoft 365 email addresses with a combo box
- Gallery control - How to set no selected item in a gallery
- Dates - 4 tips to make sure that dates display correctly in UK "dd mm yyyy" format
- Forms - How to select-all / unselect-all checkbox or toggle controls on a form
- Excel vs SharePoint vs Dataverse vs SQL Server - updated 2021
- Troubleshooting - How to use the 'app checker' to fix a broken 'service desk' template app
- Connectors - How to use the Microsoft Teams connector to add messages/meeting invites to Teams
- Dates - Examples of how to calculate dates relative to today
- Performance - Why is LookUp better than First/Filter?
- Troubleshooting - How to recover corrupted screens
- Forms - How to set the data source of a form to a collection
- Forms - The best practice for setting the data item on a form
- Data - How to make a copy of a record
- SharePoint - How to export and import lists and maintain lookup relationships
- Search - How to filter by multiple fields and return all records when no search term is entered
- SharePoint - how to fix list threshold errors when working with very large lists
Blog Author
![]() |
Tim Leung Author, software developer, Power Platform specialist |