Unanswered

Patching a collection to a table

(0) Share

Report

Posted on by raindance

Greetings,

I am attempting to patch a collection to a table because I need to add multiple values from a combo box to my table. This guide I am following shows me how to, but with a SP list. I have tried my best to follow along, but have ran into some issues. The following code is the code I have tried:

ForAll(
	ComboBox1.SelectedItems,
	Collect(
		colCoatingsToPatch,
		{
			Coating: ThisRecord.Coating
		}
	)
);

Patch(
	RollerData,
	Defaults(RollerData),
	{
		coatingMultiple: colCoatingsToPatch
	}
);

where Coating is a text data type and coatingMultiple is a Lookup. I have also tried changing Coating to coatingMultiple in the Collect function which doesn't work. coatingMultiple in the Patch function expects a Record, but is given a Table.

Any help is appreciated, thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @raindance

Looks like you are trying to patch multi Lookup. Please try this.

Patch( RollerData, Defaults(RollerData), { coatingMultiple: ForAll( ComboBox1.SelectedItems, { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: Id, Value: Value } ) } );

Was this reply helpful? Yes No
raindance 15 on at

Like (0)

Report
Copy link

Link copied!

hi @StalinPonnusamy ,

Unfortunately, that didn't work. It says it's an error. I should've mentioned this, but the data source is a Table, not sure if that changes anything.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @raindance

By looking at the error, you are using Dataverse (new_CoatingMultiple). Is it correct?

Was this reply helpful? Yes No
raindance 15 on at

Like (0)

Report
Copy link

Link copied!

Hello @StalinPonnusamy ,

That is correct, I am using Dataverse. I don't think I am able to switch to SharePoint lists, even though it seems that everyone is using it and have no issues with it.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

No problem. Let me work on this and update you.

Was this reply helpful? Yes No
raindance 15 on at

Like (0)

Report
Copy link

Link copied!

hey @StalinPonnusamy any update on the solution?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @raindance

In this example, the Account has only one Primary contact. So Patch command will be
Patch( Accounts, LookUp( Accounts, Account = BrowseGallery1.Selected.Account ), { 'Account Name': DataCardValue4.Text, 'Primary Contact': LookUp( Contacts, Contact = DataCardValue7.Selected.Contact ) } )

But Account may have more than one contact, in this case, we need to create contacts with Account lookup
ForAll( Combobox1.SelectedItems, Patch( Contacts, Defaults(Contacts), { 'Company Name': BrowseGallery1.Selected } ) )

Was this reply helpful? Yes No
raindance 15 on at

Like (0)

Report
Copy link

Link copied!
Hi there @StalinPonnusamy ,

Sorry, I don't fully understand your example. I'm also pretty new to powerapps so bear with me please.
I have basically replaced your example with my variable names, so it looks like this:
ForAll( ComboBox1.SelectedItems, Patch( RollerData, Defaults(RollerData), { Name: DataCardValue3.Text, coatingMultiple: Gallery1.Selected } ) );
This works, but creates 3 copies of the record where 2 of them are blank. I also don't know how to display the final result. Did I miss a step, or was I supposed to use the first example?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @raindance

Need to utilize Combobox to get value. Based on your Combobox, need to select a value like Source.ColumName. So that it adds the selected data from Combobox

ForAll( ComboBox1.SelectedItems As Source, Patch( RollerData, Defaults(RollerData), { Name: Source.Name, coatingMultiple: Gallery1.Selected } ) );

In this example, Combobox displays the last name, so getting Lastname from combo like Source.Lastname
ForAll( DataCardValue7_1.SelectedItems As Source, Patch( Contacts, Defaults(Contacts), { 'Last Name': Source.'Last Name', 'Company Name': BrowseGallery1.Selected } ) )

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @raindance

Please let us know if anything needs on your post. We can help with this.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No