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??
Solved! Go to Solution.
Hi @santukondapally,
Could you please tell me that
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
Hi @santukondapally,
Could you please tell me that
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