Power Platform Community Forum Thread Details

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.

Year	Company	Month	OfficeLocation	Category	Rate	Amount
2021	Company A	January	Ahd-A	AdminExp	74	0
2021	Company A	January	Ahd-A	Rent	74	0

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.

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.