Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Create multiple entries on One Click for all Choice column

(0) ShareShare
ReportReport
Posted on by 6,048

0.jpg

 

Above is my table, All choice column have values like. There are 6 companies, 12 month, 3 Office Locations, 7 Categories.

On one click i want to make a collection where schema is a value for every combination and permutation of this choices.

For eg. 

YearCompanyMonthOfficeLocationCategoryRateAmount
2021Company AJanuaryAhd-AAdminExp740
2021Company AJanuaryAhd-ARent740

 

Same for all the companies * all the months * all the office location * all the categories. Just rate amount and year will be fixed. i Can do that for one choice field as you can see from below pics.

 

q.jpgq2.jpg

 

 

 

 

I don't know how to do that for combinations. Let's say if i try below code it will create 84 entries for 7 companies and 12 months. But even in the company field it enters Months. Because inner for loop is for month. What i want is each company has 12 entries for 12 months.

 

 

q3.jpg

 

 

Any help please.

Categories:
  • Verified answer
    zmansuri Profile Picture
    zmansuri 6,048 on at
    Re: Create multiple entries on One Click for all Choice column

    q4.jpg

     

    Ok. This did the trick. Should have known it will be something simple

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard