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?
Solved! Go to 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,
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.
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,
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
Hi @Lingam ,
Have you tried my solution?
Does this work for you?
Thanks!
Best regards,
User | Count |
---|---|
260 | |
109 | |
93 | |
56 | |
41 |