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 / Collection with specif...
Power Apps
Unanswered

Collection with specific numbers

(0) ShareShare
ReportReport
Posted on by 145

Hello,

 

i need create this collection

Flashback_0-1706099241166.png

Could anybody help me please?

 

Thanks

BR

Jakub

Categories:
I have the same question (0)
  • mmbr1606 Profile Picture
    14,629 Super User 2026 Season 1 on at

    hey @Flashback 

     

    asuming u are using an excel file this would be the most easiest way to create the collection:

     

    ClearCollect(MyExcelCollection, ExcelTableName);

     

    please be aware that you would need to rename to ur needs

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • OdinDelToro Profile Picture
    407 on at

    Hello @Flashback,

     

    You can also use the following approach:

    ClearCollect(
     colSpecificNumbers,
     Table(
     {
     ColumnA: 1,
     ColumnB: 1
     },
     {
     ColumnA: 1,
     ColumnB: 2
     },
     {
     ColumnA: 1,
     ColumnB: 3
     },
     {
     ColumnA: 1,
     ColumnB: 4
     },
     {
     ColumnA: 1,
     ColumnB: 5
     },
     {
     ColumnA: 1,
     ColumnB: 6
     },
     {
     ColumnA: 2,
     ColumnB: 1
     },
     {
     ColumnA: 2,
     ColumnB: 2
     },
     {
     ColumnA: 2,
     ColumnB: 3
     },
     {
     ColumnA: 2,
     ColumnB: 4
     },
     {
     ColumnA: 2,
     ColumnB: 5
     },
     {
     ColumnA: 2,
     ColumnB: 6
     },
     {
     ColumnA: 3,
     ColumnB: 1
     },
     {
     ColumnA: 3,
     ColumnB: 2
     },
     {
     ColumnA: 3,
     ColumnB: 3
     },
     {
     ColumnA: 3,
     ColumnB: 4
     },
     {
     ColumnA: 3,
     ColumnB: 5
     },
     {
     ColumnA: 3,
     ColumnB: 6
     },
     {
     ColumnA: 4,
     ColumnB: 1
     },
     {
     ColumnA: 4,
     ColumnB: 2
     },
     {
     ColumnA: 4,
     ColumnB: 3
     },
     {
     ColumnA: 4,
     ColumnB: 4
     },
     {
     ColumnA: 4,
     ColumnB: 5
     },
     {
     ColumnA: 4,
     ColumnB: 6
     }
     )
    )

     

    Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.

    Please click Accept as solution if my post helped you solve your issue to close the item. This will help others find it more easily. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 150 Super User 2026 Season 2

Last 30 days Overall leaderboard