how to submit text input onselect button without using form

(0) Share

Report

Posted on by AKSHAY AURADKAR B

Hello Experts

I need to submit data from textinput to shareoint list name "sca"

I have date, dropdown value

can you please help to onselect of button create record in sharepoint

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

UdayAdhikari 450 Most Valuable Professional on at

Like (0)

Report

Hi @AkshayAuradkar - not sure I understand your question exactly but let me try to answer based on what I understood.

You want to create an item in SP list "sca" based on a dropdown field with dates.

Patch(sca, Defaults(sca), {Title: "Item Title value", Datefield: ddlDates.Selected.DateValue})

Where:
ddlDates is a dropdown control with Items = Table({DateValue: "1/20/2020"},{DateValue: "2/3/2020"})
sca is a SP lists
Datefield is a text field in SP.

Please include a screen capture of the form and SP list definition if above is not what you are asking.

Thanks

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report
Hi @AkshayAuradkar,

Do you want to update data without using form?

Actually, whether you use form to update has no difference on updating sharepoint list.

The difference is only about the formula that you use to update.

If you use form, you should use SubmitForm() function. If you not use form, you should use patch() function or collect() function to update.

Could you tell me

1)the controls that you use to update? a datepicker and a drop down?

2)formula in the drop down's Items?

3)fields data type in your sharepoint list?

I assume that:

you use a datepicker and a drop down to update and datepicker is used to update a date type field, drop down is used to update a text type field.

If so, you should use formula like this to update:

Patch(sca,Defaults(sca),{fieldname1:datapicker1.SelectedDate,fieldname2:dropdown1.Selected.fieldname}) //fieldname1,fieldname2 are the fields in your list fieldname is the field in the drop down's Items

Best regards,

Was this reply helpful? Yes No
AKSHAY AURADKAR B 18 on at

Like (0)

Report

Thank you for your help

it working now but if I click button twice 2 records are creating can please help in resolving this problem

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report
Hi @AkshayAuradkar ,

The reason why you will create two records if you click the button twice is that:
Every time you click the button, you will trigger this action "patch" once. If you trigger this action one time, you will create a new record. If you trigger this action two times, you will create new records for two times (two new records).

If you only want to create a new record no matter how many times you click the button, I suggest you make the button disabled after you patch one time successfully.

You could set like this:

1)button's OnSelect:

Patch(sca,Defaults(sca),{fieldname1:datapicker1.SelectedDate,fieldname2:dropdown1.Selected.fieldname}); Set(var,true)

2)button's DisplayMode:

If(var,Disabled,DisplayMode.Edit)

Then you will not trigger this button for two times.

Best regards,

Was this reply helpful? Yes No