Unanswered

Patching a Collection text value to a drop down record

(0) Share

Report

Posted on by ezjensen

Hoping for some help here everyone. This app was working, but at some point has stopped, and now the code is wrong.

I have a gallery (bottom section) where users can add line items. When the user clicks the green check mark it submits to a Collection successfully (patch code below).

Patch(
	colExpenses, 
		ThisItem, 
			{
				LineDate: lineDate.SelectedDate,
 LineSupplier: lineSupplier.SelectedText.Value, 
				LineItemDesc: lineDescription.Text, 
				LineFunding: lineFunding.SelectedText.Value, 
				Line_Cost: Value(lineCost.Text)
			}
); 

Collect(
	colExpenses,
		{
			LineDate: Today(), 
			LineSupplier: "", 
			LineItemDesc: "", 
			LineFunding: "", 
			Line_Cost: 0,
 MasterID: ""
		}
);

When the user completes all required fields the Submit button is active. The button submits the form (top half), then on the forms OnSuccess property I have the below code to Patch the Collection to the SharePoint List.

//Patch (save) all line item expenses
ForAll(
 colExpenses, 
 If(!IsBlank(LineItemDesc), 
 Patch(
 ItemizedList, 
 Defaults(ItemizedList), 
 {
 DateOfActivity: LineDate,
 //Suppliers: LineSupplier,
 ItemDescription: LineItemDesc,
 Cost: Line_Cost,
 //FundingSources: LineFunding,
 MasterID: formMiscExpense.LastSubmit.ID
 }
 )
));
Refresh(ItemizedList);

And this is what is submitted to the list:

Here is a bit of further info:

Properties:

Gallery's Data Source: colExpenses
Supplier Drop Down
- Name: lineSupplier
- Default: ThisItem.LineSupplier
- Items: Sort(Suppliers.Title,Descending) ("Suppliers" is another list that I lookup from)
Funding Drop Down
- Name: lineFunding
- Default: ThisItem.LineFunding
- Items: colFunding (this is a collection that populates on AppStart from another SharePoint List called 'FundingSources'

I get no errors on the app, but it is not submitting properly, as it used to. So it patches to the Collection great. Its just not patching to the 'ItemizedList' SharePoint list Properly.

Any help is appreciated, and thank you in advance to this great community!

Eric

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ezjensen ,

Could you please share a bit more about your scenario?

Is there something issue with the "Suppliers" column value and "FundingSources" column value?

Could you please share a bit more about "Suppliers" column and "FundingSources" column in your ItemizedList List? Are they Person type column and Choice type column?

If the "Suppliers" column and "FundingSources" column are both Text type column in your ItemizedList List, I think the ForAll formula that you provided is correct. Please also consider modify your formula as below:

ForAll( colExpenses, If( !IsBlank(LineItemDesc), Patch( ItemizedList, Defaults(ItemizedList), { DateOfActivity: colExpenses[@LineDate], //Suppliers: colExpenses[@LineSupplier], ItemDescription: colExpenses[@LineItemDesc], Cost: colExpenses[@Line_Cost], //FundingSources: colExpenses[@LineFunding], MasterID: formMiscExpense.LastSubmit.ID } ) )); Refresh(ItemizedList);

If the "Suppliers" column is a Person type column, and the "FundingSources" column is a Choice type column in your ItemizedList List, I think there is something wrong with your formula. Please consider modify your formula as below:

ForAll( colExpenses, If( !IsBlank(LineItemDesc), Patch( ItemizedList, Defaults(ItemizedList), { DateOfActivity: colExpenses[@LineDate], Suppliers: { Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(), DisplayName = colExpenses[@LineSupplier], Mail)), DisplayName: colExpenses[@LineSupplier], Email: LookUp(Office365Users.SearchUser(), DisplayName = colExpenses[@LineSupplier], Mail), Department: "", JobTitle:"", Picture:"" }, ItemDescription: colExpenses[@LineItemDesc], Cost: colExpenses[@Line_Cost], FundingSources: { Value: colExpenses[@LineFunding] }, MasterID: formMiscExpense.LastSubmit.ID } ) )); Refresh(ItemizedList);

Note: You need to add Office 365 Uses connection in your app.

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
ezjensen 49 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-xida-msft Thank you for the reply.

'Suppliers' is just a list with company names in the Title column
ex. Microsoft, Dell, HP, etc.
'FundingSources' is just a list with places that money can come from.
ex. Source 1, Source 2, Source 3, Etc.
These are both columns in the 'ItemizedList' that lookup values from the respective list

Issue: The Suppliers and Funding sources fields are not being patched from the Collection for some reason. This code lies in the OnSuccess property of the form. The data is Patching correctly from the fields to the Collection, just not from the Collection to the SharePoint list 'ItemizedList'

Based on the field types I think your proposed solution 2 is more the method to approach with since there are no people values.

I tried this solution, with no resolution. I am getting the below error on both the Suppliers and FundingSources lines.
//Patch (save) all line item expenses ForAll( colExpenses, If(!IsBlank(LineItemDesc), Patch( ItemizedList, Defaults(ItemizedList), { DateOfActivity: LineDate, Suppliers: {Value: colExpenses[@LineSupplier]}, ItemDescription: LineItemDesc, Cost: Line_Cost, FundingSources: {Value: colExpenses[@LineFunding]}, MasterID: formMiscExpense.LastSubmit.ID } ) ));

Was this reply helpful? Yes No