web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Using Collection as Da...
Power Apps
Unanswered

Using Collection as Data source in Form

(0) ShareShare
ReportReport
Posted on by 108

Hi,

 

I have created a collection which contains 2  to 3 text fields and the rest are look up in my SP list. 

 

Example:
Name: Jacky   //text field
Age: 28    //text field
Company: ABC.com    //look field

 

so, first thing i want to ask, can i use a created collection as my data source (on edit form) save it to my SP list?
If yes, then how to map look up fields with collection data? because after creating collection  i am trying to map look up field to my collection value and it says "Expected a record value".

 

2nd thing i want to ask,  when creating a collection it saves values as simple text even if its a look up value. For example:

ClearCollect(mySPList, {Name: DataCardValue10.Text, Age: DataCardValue12.Text, Company: DataCardValue15.Selected.Value}) 
 so when i am patching my values back yo SP list, again it says "Expected a record value" on Company field.

 

Simply what i want is, Use created  collection  in my edit form or do it other way like not using form and patch it y SP list

 

Thanks.

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Hi @Jackson_Dhorty 

    The short answer is no, you can't use a collection as the datasource of a form.  It has to be an actual datasource like an Excel table, a SharePoint list, a SQL table, etc. 

  • Jackson_Dhorty Profile Picture
    108 on at

    What if i don use form and want to save values to my SharePoint list?

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Jackson_Dhorty 

    I suggest that you use the SharePoint list as the DataSource for the form.  Then you can save it.  You don't need a collection for what you want to do.

  • Jackson_Dhorty Profile Picture
    108 on at

    I also wondering how to patch a simple text in look up column?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard