Multiple Sharepoint list items from Google Sheets

(0) Share

Report

Posted on by AndyTierling

Hi everyone

I am trying to automatically populate a Sharepoint list when a new record is detected in a Google sheet. It collects training records and there is a cell that could contain multiple values at the same time. If this cell has two values I need to create two records in SharePoint.

As an example, if the Google sheet had values like:

The flow would create two list items:

Trainer Name Training Register
Test Test User1

Test Test User2

I can connect to the Google sheet and extract the rows that I want to process. I can then parse these JSON records but I cannot for the life of me work out how to get multiple records into Sharepoint. I have tried using the split function on the Training Register value returned when parsing the JSON and all my tests fail of the flow doesn't validate.

I am sure it is possible and is probably quite simple so I would appreciate any advice.

My flow (not with the test above but with real data) is currently:

Many thanks

Andy

All responses (2)

Answers (1)

AndyTierling 5 on at

Like (0)

Report

Re: Multiple Sharepoint list items from Google Sheets

Amazing - thank you so much
Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: Multiple Sharepoint list items from Google Sheets

Hi @AndyTierling ,

I've made a test for your reference:

1\My Google Sheet

2\The flow

split(items('Apply_to_each')?['Training_x0020_Register'],decodeUriComponent('%0A'))

Result:

Best Regards,

Bof