cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lingam
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
eka24
Super User
Super User

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
Community Support
Community Support

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lingam
Frequent Visitor

Hi @eka24 ,

 

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

Lingam_0-1600247149411.png

 

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

Hi @Lingam ,

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

 

Thanks!

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yutliu-msft ,

 

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

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,752)