Patch Input box to SharePoint

(0) Share

Report

Posted on by SteefQ

Hi everyone!

This is my first project where im trying to build a canvas app, everything's working fine.

But i got one last problem where i need to patch the value in a input field to the sharepoint list.

The scenario:

User types in a time in textfield_input and this value should go into sharepoint column with the name: time.

EDIT:

I just found out that i should use patch to send the value to the sharepoint list.

As i said its a time that they should input in the box eg: 14:00, 15:00; 16:30. This value here should patch to a column named time

My sharepoint list is named: Convert

i got this formula before the patch one, and in property OnSelect SubmitForm(Form2);ResetForm(Form2);ResetForm(Form_time);Navigate(Success);

Patch('Convert', LookUp('Convert'),ID='Time'.selected.id, {'users_entry': Value(TextInput_Time.Text)})

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SteefQ ,

I am not entirely clear here, but if you are wanting to patch to the same record you just submitted on the form, then on the OnSuccess of the Form

Patch( 'Convert', {ID: Self.LastSubmit.ID}, {'users_entry': Value(TextInput_Time.Text)} )

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.

Visit my blog Practical Power Apps
SteefQ 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry English isn't my first language, maybe its better if i attach picture.

I want the value in Time that says 00:00 to go into a SharePoint list(column is named: Time)
The sharepoint list is named "Convert" when i press submit
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SteefQ ,

I am still unclear on this - is this the same list that the form is submitting to ? Also are you patching to a numeric or text field ?
SteefQ 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again,

Its the same form,
i got one Sharepoint list where everything is saved, this one should go to a column named: time wich is a number-format
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@SteefQ ,

If that is the case, go back to the post I did OnSuccess - this will write a number to the Time field in the record you have just submitted with the form.
SteefQ 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, as i said im pretty new ill attach a photo of my app and i dont think thats its inside of a form as i can see?
In wich "content" should i put the formula in? or should i redesign it?
SteefQ 42 on at

Like
a
(0)

Report
Copy link

Link copied!

I found where i should put it, but now it gives me an error
The patch feature has some invalid arguments
the argument type does not match

EDIT:
I solved the error, but it dosnt send anything to the column in SharePoint
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SteefQ ,

Can you please remember to post your code (in Text) that is not working for you and where you are using it.
SteefQ 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi!

Sorry for taking your time.

But its working, i had wrong inputs!