I have an old MS Form that has been updated (new questions added), and I need to migrate all of the data to the new MS List that is on our Teams SharePoint site. The flows to add all submissions using the new form work. However when I created the manual flow to copy all of the old data into the new form. I get blank cells where all of the old information should be, while I get N/A's in the "new columns" that have no data since we didn't originally ask those questions.
The flow runs successfully, but half the fields are blank. I'm at a loss as to the problem.
The image below is of the exported SP data. The yellow columns are the only fields that contain the "old form" data that should be transferred. While all the N/A fields are new questions that weren't on the old form. And the red column are three new questions that also have N/A in the table, but for whatever reason the the N/A didn't transfer over.
As I said I'm at a complete loss as to what I'm doing wrong. Any help would be appreciated.
Here's the peek code from each section
"Manually trigger a flow code view"
{
"kind": "Button",
"inputs": {
"schema": {
"type": "object",
"properties": {},
"required": []
}
},
"metadata": {
"operationMetadataId": "f29d848a-38dd-40f4-a878-b49c76553ecb"
}
}
"List rows present in a table"
{
"inputs": {
"host": {
"connectionName": "shared_excelonlinebusiness",
"operationId": "GetItems",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness"
},
"parameters": {
"source": "me",
"drive": "b!RbwAdrqMV0uFVMWU4WvAXu0gr4ZvHCFFqRdo3wFKkEHneS046Yj8QbbwKEurIXsu",
"file": "01ANA2BBQCCUMKR2XAHNB2W2A3BJZXFDNK",
"table": "{00000000-000C-0000-FFFF-FFFF00000000}"
},
"authentication": {
"type": "Raw",
"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
}
},
"metadata": {
"01ANA2BBQCCUMKR2XAHNB2W2A3BJZXFDNK": "/Manual load to sharepoint.xlsx",
"operationMetadataId": "dc2ae2e9-5dbc-43f8-8d11-c524123a579c",
"tableId": "{00000000-000C-0000-FFFF-FFFF00000000}"
}
}
"Create Item Code View"
{"id":"52d9964d-29d5-4d37-b003-4adea72d7691","brandColor":"#486991","connectionReferences":{"shared_sharepointonline":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/shared-sharepointonl-36c6ae89-739e-41dc-99b7-2268fb005fc2"}},"shared_excelonlinebusiness":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness/connections/shared-excelonlinebu-fe2392d3-0721-4e29-9ced-2dc6330136c1"}}},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzQ4Njk5MSIvPg0KIDxwYXRoIGQ9Ik0xMSAyMGg3LjJsMSAxaC05LjJ2LTguM2wtMS4zIDEuMy0uNy0uNyAyLjUtMi41IDIuNSAyLjUtLjcuNy0xLjMtMS4zem0xMi4zLTJsLjcuNy0yLjUgMi41LTIuNS0yLjUuNy0uNyAxLjMgMS4zdi03LjNoLTcuMmwtMS0xaDkuMnY4LjN6IiBmaWxsPSIjZmZmIi8+DQo8L3N2Zz4NCg==","isTrigger":false,"operationName":"Apply_to_each","operationDefinition":{"type":"Foreach","foreach":"@outputs('List_rows_present_in_a_table')?['body/value']","actions":{"Create_item":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_sharepointonline","operationId":"PostItem","apiId":"/providers/Microsoft.PowerApps/apis/shared_sharepointonline"},"parameters":{"dataset":"https://rcjf.sharepoint.com/sites/AgencyWideProgramming","table":"634f1641-8b86-4261-a68f-a24e764a9334","item/Title":"@items('Apply_to_each')?['Name of Program~1Event']","item/Dateofprogram_x002f_event":"@items('Apply_to_each')?['Date of program~1event i_x002e_e_x002e_ Saturday, January 1, 2022']","item/Timeoftheprogram_x002f_event":"@items('Apply_to_each')?['Time of the program~1event, including AM~1PM i_x002e_e_x002e_ 10_x003a_00AM - 2_x003a_00PM']","item/StaffLead":"@items('Apply_to_each')?['Who is responsible for the planning of this program~1event? i_x002e_e_x002e_ provide Staff Lead''s name~1email address']","item/VolunteerLead":"@items('Apply_to_each')?['Is there a volunteer in charge of an aspect of program~1event planning? i_x002e_e_x002e_ Volunteer Lead']","item/VolunteerContact":"@items('Apply_to_each')?['Who is the Volunteer Lead? (full name, email address, phone) i_x002e_e_x002e_ Jane Smith, jane_x0040_volunteer_x002e_org, 919-555-1234']","item/SupportRequest":"@items('Apply_to_each')?['Do you need additional staff~1volunteer support for this program~1event?']","item/SupportType":"@items('Apply_to_each')?['What type of support do you need?']","item/NumberofStaff":"@items('Apply_to_each')?['How many staff do you need to support your program~1event?']","item/Numberofvolunteers":"@items('Apply_to_each')?['How many volunteers do you need to support your program~1event?']","item/StaffVolunteersNeeded":"@items('Apply_to_each')?['How many staff and volunteers do you need to support your program~1event? Please be specific i_x002e_e_x002e_ 5 Staff and 3 volunteers']","item/Programarea":"@items('Apply_to_each')?['Under which program area does your program~1event fall?']","item/AffinityGroup":"@items('Apply_to_each')?['Which Affinity Group? Pick one']","item/IfOther_x002c_pleasebespecific":"@items('Apply_to_each')?['If Other, please be specific']","item/RegistrationImmediate":"@items('Apply_to_each')?['Should registration for this program~1event go live immediately?']","item/Livedate":"@items('Apply_to_each')?['When should registration go live?\n\nDefault start time is 8AM, if start time should be different, please add in additional comments section']","item/Closedate":"@items('Apply_to_each')?['When should registration close?\nDefault time is 12_x003a_00pm, if end time should be different, please add in additional comments']","item/Frequency":"@items('Apply_to_each')?['What is the frequency of this program~1event?']","item/Location":"@items('Apply_to_each')?['What is the location for the program~1event?']","item/VirtualLoginDetails":"@items('Apply_to_each')?['For virtual programs~1events, please provide us with the meeting information (Zoom link, meeting ID, etc_x002e_)\n\nIf not yet created, please list who will be providing this information']","item/OffsiteLocationDetails":"@items('Apply_to_each')?['For offsite programs~1events please provide the complete address of the program~1event location, as well as any pertinent information such as parking_x002e_']","item/RegistrationNotification":"@items('Apply_to_each')?['Who, in addition to the registrar, should be notified when someone registers? Provide an email address or enter n~1a']","item/FreeRegistration":"@items('Apply_to_each')?['Is there a registration fee for this program~1event?']","item/RegistrationFee":"@items('Apply_to_each')?['What is the registration fee? If there are multiple registration levels, please list each one separately_x002e_\nEx_x002e_ - JCC Members -- $5 General Community -- $10 \n\nDefault is that this fee will cover 1 p_x002e__x002e__x002e_']","item/Description":"@items('Apply_to_each')?['Please provide a detailed description to be added to the system for your program~1event including_x003a_ any speaker''s bio, parking, where the group will meet, etc_x002e_ \n\nNOTE_x003a_ If your description require_x002e__x002e__x002e_']","item/Maxparticipants":"@items('Apply_to_each')?['Is there a maximum number of registrations for the program~1event?']","item/RegistrationMax":"@items('Apply_to_each')?['What is the maximum number of registrations for the program~1event?']","item/CouponsAdditionalQuestions":"@items('Apply_to_each')?['Please use this space to provide any additional information about the program~1event, including coupon codes and additional questions to be asked on the registration form_x003a_\n\ni_x002e_e_x002e_ Coupon_x003a_ Early15Off_x002e__x002e__x002e_']","item/CommentstoCommunicationsTeam":"@items('Apply_to_each')?['A communications plan will be created for this program~1event and sent to you for review_x002e_ If you have something you would like that team to be aware of while they are creating that plan, enter it _x002e__x002e__x002e_']","item/Set_x002d_up_x002f_Clean_x002d_u":"@items('Apply_to_each')?['How much time is needed for set-up and clean-up? This will determine total usage time to reserve at the location_x002e_']","item/DesiredLocation":"@items('Apply_to_each')?['Please rate your location choice in order of preference_x002e_ Desired Location - 1st Choice - list them\n\nAmphitheater\nCover Court (old, lower court)\nDeck overlooking the lake\nField A\nField B\nField A & _x002e__x002e__x002e_']","item/NumberofAttendees":"@items('Apply_to_each')?['Approximate number of attendees']","item/NeedTablesChairs":"@items('Apply_to_each')?['Do you need tables and chairs?']","item/Numberoftables":"@items('Apply_to_each')?['How many tables do you need?']","item/Numberofchairs":"@items('Apply_to_each')?['How many chairs do you need?']","item/Numberoftablescharis":"@items('Apply_to_each')?['How many tables and chairs do you need?']","item/Set_x002d_upRequested":"@items('Apply_to_each')?['For some programs~1events during business hours, we are able to assist setting up tables and chairs in your desired format_x002e_ If possible, would you like your requested tables and chairs set-up for you?']","item/Foodavailable":"@items('Apply_to_each')?['Will there be food at the program~1event? (to help us prepare trash and recycling bins)']"},"authentication":{"type":"Raw","value":"@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"}},"runAfter":{},"metadata":{"operationMetadataId":"f4c34e7e-08bd-4c4f-abcf-f89d4dff029d"}}},"runAfter":{"List_rows_present_in_a_table":["Succeeded"]},"metadata":{"operationMetadataId":"5d636dbc-30c0-411b-8c9b-87fa121747a5"}}}
