Patch to SharePoint List from choice selection which references a list

(0) Share

Report

Posted on by rob4681

Hello all,

Please help me with this issue.

I have the patch below which compiles.

Patch(RCAData, Defaults(RCAData),
 { 
 BatchID:DataCardValue16_1.Text,
	 WaferID:DataCardValue28_1.Text,
 TrackInTime:Now(),
	 RCARecipe:DataCardValue14.Selected,
	 RCAEquipment:DataCardValue27.Selected,
	 TrackInComments:DataCardValue4.Text,
 Assignment:DataCardValue3.Selected.Value,
 TrackInOperator: OperatorDropDown_1.Selected.Operator
 }
 );
Patch(BatchTrack, LookUp(BatchTrack, 'Batch ID'=DataCardValue16_1.Text && 'Wafer ID'=DataCardValue28_1.Text),
 {
 State: {Value: "TrackOut"},
 OpCode: 11 
 }
);
ResetForm(Form1);
Navigate(BrowseScreen1)

It works but I have one issue, some of the data doesn't arrive at the SharePoint list destination. An example of the code for this data fault is:

TrackInOperator: OperatorDropDown_1.Selected.Operator

This is a drop down which references a SharePoint list for the choices, the list for the choices is named 'Operator' and the dropdown box is named 'OperatorDropDown_1'. The target in the SharePoint list named 'RCAData' is 'TrackInOperator'. It's important I can access the operator list in many different app screens and patch the selected data to different SharePoint lists.

Can someone tell me if my code makes sense and how to get it to work.

Thanks all.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Anchov 1,986 on at

Like (0)

Report

In you SharePoint list, RCAData, what is the data type of the TrackInOperator column? Is this a choice column, lookup column or a Single line of text field?

Was this reply helpful? Yes No
rob4681 on at

Like (0)

Report

Hi Anchov,
A single line of text. It wouldn't compile otherwise.
Thanks

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report

Ok, what is the Items property for your OperatorDropDown_1 drop down?

Was this reply helpful? Yes No
rob4681 on at

Like (0)

Report

Operator then column operator in value which points to the list

Was this reply helpful? Yes No
Verified answer

Anchov 1,986 on at

Like (0)

Report
It would be beneficial if you could share your formula. Regarding the dropdown control, I generally find success by setting the "Items" property to a single-column table or list. For instance:

SharePointListName.Operator

Then with your patch statement update to:

Patch(RCAData, Defaults(RCAData), { BatchID:DataCardValue16_1.Text, WaferID:DataCardValue28_1.Text, TrackInTime:Now(), RCARecipe:DataCardValue14.Selected, RCAEquipment:DataCardValue27.Selected, TrackInComments:DataCardValue4.Text, Assignment:DataCardValue3.Selected.Value, TrackInOperator: OperatorDropDown_1.Selected } );

If you need to access multiple columns from a dropdown choice, you might find better success using a ComboBox control.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
HI @rob4681,

Do you mean that you populate the OperatorDropDown_1 with operator list which is a totally different list from RCAData that you want to patch data to?

I have something confused, that I hope you could help me to figure it out, which is that you set the OperatorDropDown_1 with Operator.operator ,right?

And, surely operator is a text column in Operator list, right?

Operator then column operator in value which points to the list

If the above is correct, I think you formula is correct, the data should be saved successfully to TrackInOperator in RCAData, unless TrackInOperator is a LookUp type column.

Was this reply helpful? Yes No
rob4681 on at

Like (1)

Report

I will accept this as solution as I found it useful to check my code. Turns out my code was ok. I deleted the button and created a new one after resetting PowerApps then pasted the code in. It worked! Thanks for your help.

Was this reply helpful? Yes No