Allow Duplicates on one button and not in another button

[santukondapally]

In My Form i have a column value which is comming from another screen say for example(#MYTEXT123)

Now in the second screen form i have a column with type number name as (SSCNUMBER) and a 2 buttons (Add more,Save).

On Click of a button (add more ) i want user to enter(SSCNUMBER) Duplicate values in to the Sharepointlist for the column (#MYTEXT123) ,However if user clicks on 'save' button SSCNUMBER should not allow duplicate values in the list for (#YTEXT123).

Can we do it in powerapps like this??

[v-qiaqi-msft · Accepted solution]

Hi @santukondapally,

Could you please tell me that

1. '#MYTEXT123', SSCNUMBER and #YTEXT123 are in the same SP list?('#YTEXT123' is a mistake writing?)
2. do you want to copy the value in the SSCNUMBER to the '#MYTEXT123' if click the add more button?
3. how you configure your form, used to edit the existing record or create a new record?

Based on the issue that you mentioned, do you want to patch different value based on the button?

Not sure about your scenario, I just assume that you use the form to edit the existing record and click add more button to copy the value to '#MYTEXT123' column,otherwise not duplicate.

Set the add more button OnSelect:

Patch(
     SPList,
     BrowseGallery1.Selected,// Here you could replace with the Item formula you set for the form
     {'#MYTEXT123':SSCNUMBERTextInput.Text}
)

Set the save button OnSelect:

Patch(
     SPList,
     BrowseGallery1.Selected,// Here you could replace with the Item formula you set for the form
     {'#MYTEXT123':#MYTEXT123TextInput.Text}
)​

Regards,

Qi