How to limit user to submit only 1 single entry, which means create 1 and can modified the created item multiple time

[Lingam]

Hi,

I am creating an app for my org, basically i need to limit a user to single entry in share point list and they can use the entry to modify the columns that intended to change, is there any formula that can help on solve this problem?

[eka24]

Assuming you have the UserColumn which contains the username and the column for the creation of record is CreatedColumn, follow:

On the OnSelect of the save or Patch button:

If(!IsBlank(LookUp(Datasource,UserColumn =User().FullName,CreatedColumn)),Notify("Already Exist"),Patch(….))

------------

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.

[v-yutliu-msft · Accepted solution]

Hi @Lingam ,

Do you want to limit one user could only create one item?

Then you could use 'Created By' column to justify, which records who created this item.

I've made a similar test for your reference:

1)in screen1, I have a gallery to view all existing items, an add button to navigate to the screen that is used to create new item.

set the gallery's OnSelect:

Navigate(Editscreen);EditForm(Form1)

//then you will open the edit form to edit the existing record

set the add button's OnSelect:

If(
    IsEmpty(Filter(listname,'Created By'.Email=User().Email)),
//current user has not created one item
    Navigate(Editscreen);NewForm(Form1),
    Notify("you have already created one item!")
)

2)in screen2, insert one edit form for editing or create item

set the edit form's Item:

Gallery1.Selected

Best regards,

[Lingam]

Hi @eka24 ,

I've tried and it seems not working and few additional stuff to share, refer snapshot below for formula:

1. I am using multi screen to navigate, my project is to collect enrollment details whereby user navigate 2 screens to key in details before hit submit button, so i used patch formula to patch all the details into 1 single record

2. I would like to get noticed on the error notice even before user key in data, which means it should not trigger when user try to save but when they login to enroll new item for the 2nd time and error trigered for display mode disabled, this to ensure better user experience

[v-yutliu-msft]

Hi @Lingam ,

Have you tried my solution?
Does this work for you?

Thanks!

Best regards,

[Lingam]

@v-yutliu-msft ,

Sorry for delayed response, indeed this solves and thank you so much 🙏