How to save a certain amount of data to a new sharepoint list

(0) Share

Report

Posted on by ArpanBala

Hello,

I built an app which shows record of students from a SharePoint list.

It has a filter option in a dropdown.

After filtering data

I want to create a new SharePoint list with the first 7 records after filtering the data and then create a new SharePoint list to save the another remaining 7 records.

For example:

I filtered the data with Group: white, Designation: AB, Section:005,

You can see there are 10 records.

Now I want to create a new SharePoint list and save 7 records to that SPList, and the remaining 3records will create a new SPList and save the record in it.

The frequency is 7.

Kindly help me out of this. I don't know what to do?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

you can only do this with PowerAutomate and it will be time consuming, why not just add another column to your current list, which is like a key / group that the 7 users can be distinguished by. Also you don't want to really be creating lots and lots of lists unnecessarily as these are taking resource and need to me managed, it will cause a head ached later down the line.

Was this reply helpful? Yes No
ArpanBala 24 on at

Like
a
(0)

Report
Copy link

Link copied!

I created another column in my SPList name GroupKey.
Now how can i save the frequency of 7 records?
How i restrict to put only 7 records and then so on.?

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

what would you like the first 7 records to be called, then the next 7, etc etc. you will need to patch the each record in a ForAll() loop where you count each time the process runs using a variable e.g. Set(var_count, var_count + 1)

you would use an if formula in the forall loop where if the value of var_count is less than or equal to 7 use one name, else reset var_count to 0, and change the name to the next required name for the next group of 7.

you may struggle to get this to work if you have a really complex naming system. i would try to increment values with prefixes or suffixes. basically the name needs to be something you can keep adding to for each group of 7, therefore, text on its own will not work as it is unique. Its also possible to store your naming into a collection to get unique names but this is fairly complex and i don't have time to mock it up for you in PowerApps.

Was this reply helpful? Yes No
ArpanBala 24 on at

Like
a
(0)

Report
Copy link

Link copied!

So I need to assign custom name for all the groups which will create?
So in that case I think the flow option will be better.
There I can export into a csv file and set the file name to timestamp and save the file into a document library.
What do you say?

Was this reply helpful? Yes No