question

AinaMike-7566 avatar image
0 Votes"
AinaMike-7566 asked CaseyYangMSFT-4714 commented

How to Create a Flow to automatically insert rows into a SharePoint based on a cell value

Hello Community,

I need to create a flow that will automatically insert X-number of rows in a SharePoint list when a certain value is set in the list.

Example:

A = 2
B = 4
C = 6

I set X-cell to have a value of C, as a result 6 rows are inserted below the row where I added the value of C and all data already in the row are copied down to the 6 new rows. If X-cell is set to A, 2 rows are added to list along with the preceding data. And so on and so forth.

Thank you for your help in advance!

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CaseyYangMSFT-4714 avatar image
0 Votes"
CaseyYangMSFT-4714 answered CaseyYangMSFT-4714 commented

Hi @AinaMike-7566,

Per my test, we couldn't use flow to insert same rows to SharePoint online list. In SharePoint Online list one row means a new item and there is no something like copy item in Microsoft flow we can only use "create item" option. So if you want to copy item in one list base on choice field this will go in infinite loop. You can see the infinite loop in the following screenshot.

132538-1.png


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



1.png (35.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AinaMike-7566,

I'm checking how the things are going on about this issue. Is there any progress on this issue?

0 Votes 0 ·
AinaMike-7566 avatar image
0 Votes"
AinaMike-7566 answered CaseyYangMSFT-4714 commented

Hi @CaseyYangMSFT-4714

No progress on the issue yet. If adding the rows and copying data to the new rows is not a SharePoint function, then we can consider this case closed.

Thank you for looking into it!

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AinaMike-7566,

Thanks for your reply, if there is any other question feel free to ask.

0 Votes 0 ·