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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Problems in creating c...
Power Apps
Answered

Problems in creating collect

(1) ShareShare
ReportReport
Posted on by lai_lai 57
Hello!!!
 
I'm trying to create some collects in here, but is not working, and I don't know anymore what to do..
 
When I click the button, the collect kind create, but it doesn't
 
Here I'm creating a test collection:
 
 
 
Here we can see the collection was created, but any data was inserted:
 
 
And when I click in the name of the collection, we can see the base was created, but any data was allowed to be in the collect. The message says: There is not support to avaliete this king of data: 
 
When I searched for, it says that the type of data was not supported in the database, but I don't understand. I'm using dataverse as database, and I'm pretty sure the sintax is correct. I also tried to create a collect that is in the documentation, and didn't work.
 
I'm from Brasil, and the sintax in here we use ; and not , 
 
Can someone help me?
is there more information I can provide so you can help me?
Categories:
Building Power Apps
Microsoft Dataverse with Power Apps
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 69,556 Most Valuable Professional on at
    You are trying to add the whole Dataverse table to the collection. I think the error is happening because you have some columns that aren't supported as part of the collection. Try using a ShowColumns() function around the table and only add the columns from the table that you want in the collection. 

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     
  • Suggested answer
    11manish Profile Picture
    11manish 3,337 on at
    you can try below :
     
    Simplify the collection first
     
    Test with basic data:
     
    Collect(MyCollection; {Name: "Test"; Age: 30})
     
    If this works → issue is with your original data structure.
     
    The issue is most likely unsupported or complex data types
  • Suggested answer
    Haque Profile Picture
    Haque 3,653 on at
    Hi @lai ali,
     
    can you pleae try this: ClearCollect(teste;tbAtingide) ?
  • Suggested answer
    lai_lai Profile Picture
    lai_lai 57 on at
    Hey guys!!!
     
    Pstork1
    I tried and this happens:

    The new_confirmacaolideranca is a boolean question.. 
     
     
    11manish
    I tried and the collection appers, but it is now showing in the variablesdd
     
    Haqque
     
    The same massage appears as the first time:
     
  • BCBuizer Profile Picture
    BCBuizer 22,833 Super User 2026 Season 1 on at
     
    The "error" that you are seeing is merely a limitation of Power Apps studio when previewing complex column types such as Choice or LookUp. It just means it can't show you the value, not that the collection is not working.
     
    To confirm, use the below formula on the text property of textcontrol and it should show the value of the new_confirmacaolideranca column for the first record in the collection, assuming it is a Choice type column:
     
    First(<CollectionName>).<ColumnName>
    Here you have to replace <CollectionName> with the name of the collection and <ColumnName> with the name of the column to show. Using the example you posted in response to @Pstork1 it would look something like:
     
    First(colsSelecionadas).new_confirmacaolideranca
     
     
    If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.
     
  • Suggested answer
    lai_lai Profile Picture
    lai_lai 57 on at
    hey guys!
     
    it's a boolean column
  • BCBuizer Profile Picture
    BCBuizer 22,833 Super User 2026 Season 1 on at
     
    In Dataverse a Boolean column is a Choice type, so my previous answer reply should work to show the value and confirm that the error you are seeing is not because the collection did not create properly.
     
     
    If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.
  • lai_lai Profile Picture
    lai_lai 57 on at
    The answer is "Sim" (true)
    and the label is showing this:
     
     
    After this, I need to collect all the records that confirmacaolideranca = "Sim", but is not working...
     
    Al this because I need to filter some datas..
     
     
    the collect wasn't created in the left side, and just some informations came.. And the filter is not working correctly, because some data with another answer came together.. 
     
    Isn't showing in the left side because the type of data?
  • BCBuizer Profile Picture
    BCBuizer 22,833 Super User 2026 Season 1 on at
     
    In case you want your collection to only contain records where CodigNF is true, you need to add a Filter() function to the formula that creates the collection:
     
    ClearCollect(
    colsSelecionadas;
    Filter(
        tbAtingide;
        ConfirmacaoLideranca
    )
)
     
    The since the second argument of the Filter() function takes a boolean type, you can simply pass the name of the boolean column as above. Also, I replaced the Collect() function with ClearCollect(). ClearCollect() will empty the collection before collecting again, so record that don't meet the filter criteria will not be present in the collection.
     
    More information about the use of the Filter() function can be found here: Filter, Search, and LookUp functions - Power Platform | Microsoft Learn
     
    More information about the user of the (Clear)Collect() functions can be found here: Collect, Clear, and ClearCollect functions - Power Platform | Microsoft Learn
     
    As a side note, it should be noted that just because the result is not as you want it to be, it does not mean that "it is not working". Please be clear in what you want the outcome to be, what you have tried, and where you are running into issues.
     
     
    If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.
  • lai_lai Profile Picture
    lai_lai 57 on at
    Hey man, thanks for the support!
     
    See:
    In this case, there is the error msg in the column new_confirmacaolideranca)
    And the collection was created, but showing only 3 lines, and this is not the real cenario in the database.. we have more lines with 'true'
     
     
    I'm using dataverse table
     
    You said that there is some king of error when reading choice columns, what kind of error?

     
  • Ram Prakash Duraisamy Profile Picture
    Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at
     
    I Suggest, not to use Collect data directly from PowerApps. Try getting data from Power Automate and use it, because if is is more than 2K Records system won't show the same. (Else Make sure to use pagination for the same ) based on Created on Date or Sort by Some Unique field
     
    ClearCollect(colAllData, 'YourFlowName'.Run())
     
     
    Please mark as answer if my suggestion helps.
    Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991
     
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 424

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
11manish Profile Picture

11manish 290

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans