I've read this thread before i post https://powerusers.microsoft.com/t5/Building-Power-Apps/Prevent-a-patch-if-record-already-exists/m-p...
I have a Sharepoint list with a colum Name "Nom et prénom"
On my apps i add this
And finally on the sumit icon, i add this syntax
I don't why i have this warning.
Is because my column "Nom et prénom" is a person column ?
Thanks for your help
Solved! Go to Solution.
The warning is there because CountRows is not a delegable function. But if you are sure that the filter will return less than 500 rows, which in this case you are, then you can ignore the warning.
Revise the portion:
'Nom et prénom'.Value=nonPernom.Text
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
@Pstork1 Thank you but since i add the if condition, i can't submit my forms.
I modify to this ..but nothings change 😞
If(CountRows(Filter('Test QCM';'Nom et Prénom'.DisplayName=NomPrenom.text))>0; Notify("Enregistrement existant";NotificationType.Error);; Patch( 'Test QCM'; Defaults('Test QCM'); EditForm1.Updates; EditForm2.Updates );; Navigate(Success;ScreenTransition.Fade)
Hi @ALP1 ,
If the NomPrenom is a Textinputbox to input Name, the Text property should begin with a capital letter.
Please modify NomPrenom.text to NomPrenom.Text.
Hope this helps.
No it's not a inputtext box it's a person or group.
But i' ve found a tricky way, i check this on my sharepoint list
But this is not a sustainable solution because if the user wants to change his answer late then he can not do so.
Let me come back to you and make my need a little more clear.
When a user edits and changes their saved data, it will create a new record in the SharePoint list.
How can I avoid this?
In this example, the test user has just changed their information to update it.
Instead of changing its initial record, this created a second record
If you are using a form in Power Apps why are you using Patch() instead of SubmitForm()?
In fact, I have a form that is on 2 pages in the app and I need to use patch in order to be able to record the information contained in screen 1 and screen 2. The syntax works very well
I didn't test the exact syntax, but you want something similar to this.
The IF checks to see if a Record with the same Title already exists. The title field is normally an index, but use any field that will be unique for a give record. If the Title doesn't exist (IsBlank) then patch the datasource using the defaults. That will create a new record. Otherwise Patch the datasource using a Lookup to update the existing record.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.