I’m new to Microsoft Flow.
I have a csv file that contains the following data:
The headers are - "Role","Name", and here is a sample of the data.
“Student ”,”John Smith”
“Student ”,”Mary Scott”
“Student ”,”Joseph Doe”
“Tech”,”Joseph Doe”
“Tech”,”Peter Paul”,
“Admin”,”Peter Paul”
“Admin”,”John Smith”
As you can see a person can have more than one role.
I would like to use flow to create an excel spreadsheet where the Role is the column header with the names listed in a separate column and the role that they are assigned have a true/false indication.
The sample output I envision in Excel is:
Name. Student Tech Admin
John Smith X X
Mary Scott X
Joseph Doe X X
Peter Paul X X
For instance, in Java one could create a map where the key would be the person name and the value would be a map of the roles. Then one could iterate through the input list and if the “next” person read was not on the map, one would create an entry for that person and the value map would have the role from the line read. If the person already existed in the map, then the role just read would be added to the existing role map for that person. After iterating through the data, I would be able to create the appropriate Excel spreadsheet by iterating through the map just created. I’m struggling to understand how I could do similar with MS flow.
Any help/suggestions would be greatly appreciated.
MLG
