Answered

Combobox value Collect and Patch

(0) Share

Report

Posted on by JDpower

Hello Friends,

I have a requirement to Patch Combox values to a Sharepoint List after accumulating the same in a collection. So Patch Statement I've figured out we can do like

Patch(ProjectCollection, ThisItem, {ProjectItem:inputname.Text,Technology:ComboBox1.SelectedItems});

But, I need collect statement to collect the next set of Project Item (text field) and Technology(Combobox) in Project Collection.

Collect(ProjectCollection,{ProjectItem:"",Technology: ?????? });

But I'm not sure What Technology to setup for Collect and Clear Collect Statement.

Thanks and Regards,

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Eickhel 374 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I'm not really sure I understood your requirement but do you want to Collect the patched items?

If that's what you wanted, the patch method returns the "patched" item, you can Collect the patch method.

Collect( ProjectCollection, Patch(.... ) )
Please let us know it this is what you wanted to accomplish
JDpower 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Eickhel,

No i don't want to collect a patch. What I want is to know is for Project name as i'm taking text value in Patch so in Collect as default i can set double inverted comma " " however what should be set as default if i want to collect combobox1.selecteditems in technology. Will it be a table or a record within the collect statement?

Regards,
JD
Verified answer

Eickhel 374 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Allright, if I understood correctly you could get the selected elements from the Technology combobox like this:

Technology: ForAll(ComboBox1.SelectedItems, { '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: Id, Value: Value })
This way you will get a table of the selected items.

Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-forall