Unanswered

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

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (2)

Report
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,

Was this reply helpful? Yes No
Lingam 20 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (1)

Report

Hi @Lingam ,

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

Thanks!

Best regards,

Was this reply helpful? Yes No
Lingam 20 on at

Like (0)

Report

@v-yutliu-msft ,

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

Was this reply helpful? Yes No