Answered

Unable to save data to sharepoint and cannot navigate to next page.

(0) Share

Report

Posted on by Durrani

Hi guys, I am having trouble of saving the data to my Sharepoint. Here is the code that I did. Can you guys navigate me which part that I had to change?

Patch('Exhibition Competition',Defaults('Exhibition Competition'),

{Title:'Exhibition Competition',

Tech_Title: TextInput4.Text,

TRL: Dropdown1.Selected.Value,

Leader:TextInput4_1.Text,

Institute: TextInput4_5.Text,

Team:TextInput4_2.Text,

Type_of_IP:TextInput4_3.Text,

IP_status:TextInput4_6.Text,

IP_status:TextInput4_7.Text,

Comm_status:TextInput4_4.Text,

Target_year:TextInput4_8.Text,

Partner: TextInput4_9.Text,

which_comp:Dropdown2.Selected.Value,

Category: TextInput4_11.Text,

other_comp:TextInput4_10.Text

}

);

Navigate('Technology Summary');

Since the forms have multiple pages, is it okay if the data at the page will saved to sharepoint everytime the respondent go to the other slide?

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Durrani ,

It is not possible to work out the error without knowing the field type of each field you are patching to. It appears presently that they are all Text (Single or Multiple Line) columns - is this correct ?
Durrani 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Yes almost all the text columns are text that will be filled by the respondent except two, which I use dropdown where they can choose the given answers
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Durrani ,

What type of fields are these in SharePoint ? If they are Choice columns

Patch( 'Exhibition Competition', Defaults('Exhibition Competition'), { Title: 'Exhibition Competition', Tech_Title: TextInput4.Text, TRL: Dropdown1.Selected, Leader: TextInput4_1.Text, Institute: TextInput4_5.Text, Team: TextInput4_2.Text, Type_of_IP: TextInput4_3.Text, IP_status: TextInput4_6.Text, IP_status: TextInput4_7.Text, Comm_status: TextInput4_4.Text, Target_year: TextInput4_8.Text, Partner: TextInput4_9.Text, which_comp: Dropdown2.Selected, Category: TextInput4_11.Text, other_comp:TextInput4_10.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.

MVP (Business Applications) Visit my blog Practical Power Apps
Durrani 32 on at

Like
a
(0)

Report
Copy link

Link copied!
the line where i want to use multiple choice column is at here. I also attached a photo for your refference
which_comp: Dropdown2.Selected,
TRL: Dropdown1.Selected,
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Durrani ,

Can you please tell me exactly what field types these are in SharePoint and whether your Combo Boxes are single or multiple selection.
Durrani 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the lack of clarity, the two line that I mentioned before I want to use single selection while the rest I intend to do multiple lines of text.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Durrani ,

If the two choice columns are single selection and the combo boxes are also single selection, then the code I provided should work.