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
