Sharepoint List w/ Multiple User Values in one Field

%3CLINGO-SUB%20id%3D%22lingo-sub-2571709%22%20slang%3D%22en-US%22%3ESharepoint%20List%20w%2F%20Multiple%20User%20Values%20in%20one%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571709%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20flow%20that%20will%20take%20a%20Sharepoint%20list%20(calendar)%20and%20turn%20it%20into%20a%20CSV%20file%20with%20one%20record%20per%20attendee%20per%20event.%26nbsp%3B%20The%20problem%20I'm%20having%20is%20that%20they%20can%20(and%20should)%20enter%20multiple%20attendees%20for%20an%20event.%26nbsp%3B%20When%20this%20pulls%20through%20into%20the%20file%20it%20is%20just%20one%20record%20with%20multiple%20values%20in%20the%20attendee%20field.%26nbsp%3B%20Any%20ideas%20on%20how%20I%20can%20get%20to%20a%20solution%20where%20I%20have%20a%20CSV%20file%20with%20one%20record%20per%20person%20per%20event%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2571709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm trying to create a flow that will take a Sharepoint list (calendar) and turn it into a CSV file with one record per attendee per event.  The problem I'm having is that they can (and should) enter multiple attendees for an event.  When this pulls through into the file it is just one record with multiple values in the attendee field.  Any ideas on how I can get to a solution where I have a CSV file with one record per person per event?

 

Thanks!

0 Replies