Unanswered

COLLECT Function

(0) Share

Report

Posted on by NL-02020433-0

Hi there,

I am trying to build an app to act as a Conflict of Interest register for my organisation.

I have set up a sharepoint list and set some fields to 'Person or Group', I have then created a form in Power Apps. I am now trying to create a function whereas once you haved entered the data into the Power App it adds it to the various fields in the Sharepoint list. I have been trying to use the COLLECT function to do this, but it keeps returning the error below:

I have written the formula below just as part of the example of what I am doing:

Collect(InterestRegister,{Name:Name1.text})

InterestRegister - Sharepoint List

Name - Sharepoint List Column

Name1 - Power Apps form field

The column in the Sharepoint List is formatted to 'Person or Group'.

Can anyone help how to fix this?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

iAm_ManCat 18,228 Most Valuable Professional on at

Like (0)

Report

Hi,

If you've set up a form, why are you using Collect?

You should be able to use SubmitForm() to submit all datacards and fields listed in the form,

Cheers,

Was this reply helpful? Yes No
Verified answer

Ravi-Prajapati 416 Super User 2025 Season 2 on at

Like (0)

Report

To store the data in Sharepoint list either user SubmitForm(formname) or Patch function.

Patch( List, Defaults(List), {column1: column1.Text, EmployeeColumn: {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|abc@companyname.com",
Department: "",
DisplayName: "User Name",
Email: "abc@companyname.com",
JobTitle: "",
Picture: ""
}})

Was this reply helpful? Yes No