This is the whole process and there is a 'Create New File' action at the very bottom too.
This is the output when I run 'Get Response Details' (names changed)
"responder": "samantha@samantha.co.uk",
"submitDate": "8/25/2021 4:26:52 PM",
"r4c7aae4b2ad846d2a520705ab0ea1653": "Excel Level 1",
"r7f9bba3dc7b14531a0ed185a5561bd8e": "Charlie",
"r7f88cd2bfb814cffb49b55d9d319f350": "",
"rdf9b8e19ceb14d4abd59453f277ed739": "",
"rbb807edfbd4241d284db261055cb2406": "MSEXL1",
"r81d0397a34ba410a99f35797b20ee867": "Yes",
"r3639237d2ecb4f0981f424dc27952423": "Public Scheduled",
"r1b53f62eac1d4ccba1f9761ba16df9ad": "2021-08-01",
"r64283dc134344ed1a609732ca5b60dd5": "Jo ",
"rb08df1882c8b4d2e87d091d0c5458062": "CW250",
"r30b71880a0af47dbbab8a29a11eb6639": "Virtual Classroom",
"r239e64899be14380a92decc786f657c0": "1-day",
"rb836f560a6ff41d3ab57acdf2a9af35e": "1d",
"r53329380f3a34215855454754e88e044": "100",
"r99fb9cf3aa2541e18455afa56cc2a25c": "",
"r0431ef2e5be8492fac1548b5cb73e262": "Ian ",
"rc39c0d0b09f4419da3e1b74857a936d8": "Ian’s company",
"r2b2f124673f84984897361e868f22626": "",
"r7162e617efd0486babd9ed4ce4b51641": "",
"r32d72d704c4541938e148a2bff83aa88": "2021-08-02",
"rc5bc7e3f66cb4d3c80989b5a2c534858": "Course2",
"r5d70e3cdb57646908c4e7953f6c40ead": "",
"r1d78275f18b943edb797f42064915122": "Public Scheduled",
"r2107752fa5964f84b95c953e884f74d8": "2d",
"reeae24fd1d9049afba5a7485ace5878d": "2-days",
"r40339eadf5134065b0b32de3014ac380": "Jo ",
"r6da18ece73bb449d88454b9cddec4be9": "Yes",
"r7821a29be4a54b96924133d68cda3b4a": "100",
"r52a70b245d1a417ab243b5cdd171dd5c": "Title 2",
"r8a1da8ad59d24968a293a7be050fc1af": "Virtual Classroom",
"r3faa4dbe6b2e4753b1eb81f9874d44aa": "",
"r35379faac7cf48cbbd67fc7730e336ac": "Title 3",
"r3c2df974d8264b74963b44baf428e6d8": "3d",
"r702316da19d9420f9196bd86d113efd9": "3-days",
"r6d39c2b7e35140f096d6374d69afd25a": "Jo ",
"r0b3d8bef0d5741debb75fb78cfb8287b": "Public Scheduled",
"r83dae3d692db4914af1fcff8469d3843": "",
"r4322f3c8f77b4d6989e452cb16ee3143": "2021-08-03",
"r6bc6bb2e2403400ca7eab349664af35a": "Virtual Classroom",
"r5c93884fe1e74644818ff991b1cccff9": "Yes",
"raca08a8b93bd4cb78a9fc47e1afefb84": "Course3",
"rb4bfda8a73d2476c8fba570ac304b521": "100",
"r059fa17852a5454dbd2f08e242301303": "",
"r4dadf7f5da214a14a78e34b719c20fc2": "100",
"re8d4f69ecb514fe59596c7fe3acf5f23": "Jo ",
"rcbecbf904cfb4023a1b17602a19afe69": "Virtual Classroom",
"rb2b85c83c1fa4ae4b5c69ac8ee4e3b7f": "Course4",
"r3ec45d5025374757956ef712228f24e8": "",
"r9d4c87f390d34cfcaa357f592f8b0c4c": "4-days",
"r59ccba943b3048d38b20bcde0ba2b39c": "4d",
"r2d9ddc9ad28c4bfeac148fc34d2e1c21": "Title 4",
"rb03934db52d44d7380488c9908c8bd75": "Public Scheduled",
"rc0d1100b4397404db7ee4390b3a03859": "2021-08-04",
"r7c5d5b2cbd844e57878c25966f4cfaeb": "Yes",
"r85635b9d51c5453ea734a9b08484e4ec": "Public Scheduled",
"r626b8e985b76439298deab6fb05262ef": "",
"r71260451f37b4c709c383bde7d95200c": "Title 5",
"r75c25661d23c407a86103d754b60a771": "2021-08-05",
"r92e44e70015d479aa79be5a0c7f01521": "Yes",
"r85897a4ae4c4440f8492df01329eac40": "5d",
"rfe13c5e27ce146c3a1fbaed96c879478": "Jo ",
"r4881c44f9aa545c08cfaf1d26414b82e": "5-days",
"rcc1bafe26ecf43be82dcb8185b173a57": "100",
"r9d8dbc889f4b4261b7857c99c09d336e": "Virtual Classroom",
"r288ceb5e627a4e42ab3fcbfb367da4aa": "Course5",
"rd87345b9eef94a39912ee383725a80b7": "",
"rdbc60d6c254f430ab137d88751afe4e4": "Title 6",
"r74bbf0f60bb64dacaf0aa63cf69d2fea": "2021-08-06",
"rd04b9d2f2c5443718575c48f787de73f": "",
"r5bd935c699cb46b7b17552182bcc6980": "Course 6",
"refe26d5a25c047eebb39f47f84b048e0": "60",
"r31636e88bec440eba22b6c4e28ebe0ef": "Jo ",
"rfaa75f2dde584b1aaca7e2fa82ef2ad8": "Public Scheduled",
"r4e51cfc1ff9848149cc65fb19622bd68": "6d",
"rc94657e43a374a2895871e5efb7b2bb3": "Virtual Classroom",
"rf46e286ffd2443ecbf7e90afa16256d0": "",
"rbf779bf5dcee4e149a5a00862224c159": "Yes",
"rfcaf28ce19f74a5cb2c172be9cc69127": "100",
"r591f6ec0738143d29dd195e174a5fc0c": "",
"r3cad61b696a942c2815fce6295f7d98b": "70",
"rfe160a9e59774279b8d4c2a75338b9d8": "7d",
"r0917ab28cff34766a0ed5a8e3183cc41": "Title 7",
"r199d1377514a470e975b8192e2557af9": "Course7",
"rb3be33485ecb46b7bafa546533aff07b": "",
"r0b8b1c6a94e748e5a630bc17bf389f31": "2021-08-07",
"r4b983cd6883647eaababa2fedab80663": "Jo ",
"r428095069ee54a6eb826361a302ecbfc": "Public Scheduled",
"rda79f8668b1b4bf187a2fa292e3b05ba": "100",
"r982d143170614733acf586ac48a6662e": "Yes",
"rc78e73da6ff443dab0586ef468c84eb4": "Virtual Classroom",
"r584c07eed68b42c1bb79e6dfba205d03": "80",
"rc381370a40d24a3d8c688f54f7496425": "2021-08-08",
"r20569efedcf94946bf1207cc485ebe68": "Course8",
"r50c11924a81c4650ae6f4fd4960aff19": "Title 8",
"r7d9abb287ded4016ae41cb7982a7f9c8": "",
"r6222fd5bea404f4caef264d9035cdaf8": "100",
"rf6ad89d0d18d4468ac31d76dd74d53f3": "Public Scheduled",
"rb2abedb8c83c4258a700e15d32e14d43": "8d",
"r0e103662d0a14fb4aed3c2d3c0f67487": "",
"rf40248127b6549f798c989fe6a56d56c": "Jo ",
"r4286f33c995a42ccb13aeeb21879dd6a": "Virtual Classroom",
"ref8f5bf3d8734100977c0372558d5808": "Yes",
"rbc75e03ed1fd4f1085f2963673ce3783": "",
"r28c77ecd28db433dbcf82cfb0add3dcd": "Public Scheduled",
"r9499f61f1d2a46d2a4a1b14f2ef515f3": "2021-08-09",
"r251846ab8af0499f9145a932412e1f1f": "90",
"r9b5f14efa9164e6e90dd19a576552337": "Virtual Classroom",
"rb26b1212fadc42539445c9b739ec374f": "100",
"r706473bce7334c5cacc97dfee8f0337c": "",
"rf9f98f7fb000472d93246ae9025333fe": "Course9",
"re0887db1222c42c58c67ccc5732553a4": "Yes",
"rf1a16e4c6ffc47c4a9d53a3533f9c3a8": "Title 9",
"r36e5d20c579943edaa0ab3507fec0198": "Jo ",
"r972225c97dc14a7ab54bf9e57753abeb": "9d",
"r9db4e429090c4786a32dc9f086bcb0dd": "Public Scheduled",
"r0f9a15fa77864e2eb1d4849436cc3e51": "100",
"r5b0721f9d17f406d93c00ca6610d1df5": "Yes",
"rfb96135e62a9462694627e38b4e14d31": "2021-08-10",
"rd9a5ceb5cdf6485a92e06d37ec4f1b56": "Title 10",
"r42d1c1df8e004cd992f9246bcb9df58d": "Course10",
"r48f2fca035a64250a1ff2466e9280a54": "",
"rffb8916df09744e7ba4bb5c095e47e9d": "",
"rf2b729f1048b40a2ac1b0c762e6ab2df": "10d",
"r0ffaba26a28541ef8c0719d13470d9e8": "Jo ",
"rc588fdb9b3ff4b7999c3772578ae1e37": "100",
"r9c3cfa31d5004787a7e9efc2377db0bf": "Virtual Classroom",
"rc7218e057a7443d18f069b1d665fa86d": "",
"r8792a6e65c0e493cb4cc0433a65bffc7": "100",
"r8f9c406c05504c34891e9e81cc44b919": "2021-08-11",
"rd841e7772c5d4bd5aa77748da9a4967f": "Title 11",
"rbed74a52ebb14f139c249e6f9d5032a7": "Jo ",
"rec1263870f014941965c6a98fce8a7d7": "110",
"r80cbec3d705c47aa88a5507cf2b0d10a": "Yes",
"rf162d5f91d304fb7a10ce6353005b385": "Virtual Classroom",
"ra19321581e0c487f883d9af0b6ada720": "11d",
"r8412b5af89a64d2293c63cec52702f46": "",
"r268648f3efa04876a009e13aeb68222c": "Public Scheduled",
"r7e10044c792b4a5bbe44124da331d109": "Course11",
"r92e2414ca9624041b92aa293ef9382c5": "Jo ",
"r3beabe1e8a3c415d854e1b691ed4801e": "",
"r63d0bd0e418c4855b50902d8c880c1cb": "100",
"r24472ee17c4746bbba9a1f4787ac4bd6": "Title 12",
"r22f4e9681dd34c388f8dc48e32de57ad": "Public Scheduled",
"r9e2c12cd8d6c4cb59f1422a96aed94e8": "Course12",
"r6547fa6dc7ea418fb662f0c49ad825fe": "2021-08-12",
"rb7332a09d2894d31be794d2846a71f15": "12d",
"rf743b7cb95ef4885a4a91cca748f8d40": "Yes",
"rc9a03d262eaf4a6a954fc347ae9f1d39": "",
"ra8f2bb6083c747e6ad159c60751ffdbe": "120",
"rc0b27c2d505a4240a6de6af3392513cd": "Virtual Classroom",
"r186740da1e4a40a48c14aed9786180d8": "2021-08-13",
"rdcfdb0622f3c40dcaac668bad68d68a7": "100",
"rfe573dae86074e999fce4f2671b70bac": "130",
"rf67deeb154c74295b0404562ee15e0ab": "",
"r198e0ba6461f45aa83e3d8cec4542d94": "",
"rd831523a8c084c87babef4b99b9dce82": "Virtual Classroom",
"rafd02a19fcf94ebfaa7d2e2816a0f584": "Jo ",
"ra3a68981e22845bc916cfca310036160": "Course13",
"r348d832cf5774b1f99cd78a0a8740789": "Public Scheduled",
"r7e336d915e4c4dd780139e9a9b57a7de": "13d",
"r72eb4a4d32824ef8851c066ac12410a7": "Title 13",
"rafeffc7802464d4da64c49ff5566b332": "Yes",
"r1899dcd8ea43499cbca62a80ebf728f5": "",
"r1e267d8d323346ae8d33750b8075e102": "Course14",
"r8f60c5ceb5534ec9aa30f1ae3feeff70": "2021-08-14",
"r6fabb0c507b4464ba150442ed60bc4ea": "14d",
"ra7bc0e168372469780e2fdfc523eeb3c": "Title 14",
"r7cba01ccc4874777a6b1da1985230900": "Public Scheduled",
"raaff2a0b6cf942e1b0b86dd4dafe765b": "",
"r2ad8801b84b249b2b54a92d4102cee09": "Virtual Classroom",
"r24596fffa463486f94faaea5b366e8d5": "100",
"r2a6148f6b6e548978a9b0ad4d37f6345": "Yes",
"r4cf9645afc29444bace69c6fa0186b8b": "140",
"re969dd7913c249d6b8d524ac6d5f48d4": "Jo ",
"r4b022560bd79474795002785f0a02da5": "Title 15",
"re98951f2fe5d41c087ce220b4eee057f": "Public Scheduled",
"r3d9dcec41c904d5b8aa37f8f7f846a07": "",
"r4865fa60825f4c5ab8c4592c828abc9a": "Course 15",
"r68cc4faefe9b45de994492b8135ff285": "Jo ",
"r2d811ce53c124773b35628cfdacb9c3a": "2021-08-15",
"rce591dbaab124b3ea9ec3ae38ed56213": "150",
"rb77310da223542fc8e81f92c9241813b": "100",
"r5a5867570c554b55a968571e12104bbb": "Virtual Classroom",
"raaa6fff5bfda4a608c97bbcc165eef18": "15d",
"re50adac8fa2e43169818e149008d9d27": "",
"r1900e09368164a71b2142f2c26a6a58f": "1",
"r4106c86f18d3464e87c199e59778c6b8": "2",
"r7b1d6ac4e00c407e838860c808f62ece": "3",
"r1b421d56d32f482697c35f66534bc673": "4",
"r4467aad7c2e54b50b707add0601dc32b": "5",
"reb406b744ecb4bed969d7e23b73005aa": "6",
"rdaa03895216c4f2cbb6ead9894747394": "7",
"r19fbe625fe914966906d1976f75889d3": "8",
"rf83d578e96c64c12b6d3f0a5318b47aa": "9",
"ra8196da6f18d45119be31e7bfec942fe": "10",
"r32baab113b594e29876da329634675b0": "11",
"rfd7736fb655040018c9d0863b83e9603": "12",
"r93a12e4fa6b34ef99ce9b5eaabf44066": "13",
"r04d7ef6b99b04aa08b240200b39d2d46": "14",
"r77833efe7fbf4b938c1b2941d7aded6d": "15"
}
Start Date (1) and Start Date (2) Input for 'Add Row to Table' action (all other Start Dates are in the same format):
Add Row to Table Output:
{
"@odata.context": "https://excelonline-ne.azconn-ne.p.azurewebsites.net/$metadata#drives('b%21MV3dXGo7OEC7HgIVW3x2d0pGvuP8vMVNq3OweJuVscEJNdVO3-QcRpCopZSu2y4S')/Files('015PCJQ27OMU5M7K4RB5GKSSFJWHIVMLWS')/Tables('%7B00000000-000C-0000-FFFF-FFFF00000000%7D')/items/$entity",
"@odata.etag": "",
"ItemInternalId": "347d49b7-a91b-434b-897a-69821436b578",
"ID": null,
"Start time": null,
"Completion time": "8/25/2021 4:26:52 PM",
"Email": null,
"Name": null,
"Managing BDE": "Charlie ",
"Booking Ref": "CW250",
"Booker Name": "Ian ",
"Organisation": "Ian’s company",
"Course Code (1)": "MSEXL1",
"Course Title (1)": "Excel Level 1",
"Start Date (1)": "2021-08-01",
"Number of days (1)": "1-day",
"Number of delegates (1)": "1",
"Delegate names if known (please separate each name with a comma) (1)": "1d",
"Course Type (1)": "Public Scheduled",
"Net Price per Delegate (1)": "100",
"Net Price (1)": "",
"Trainer (1)": "Jo ",
"Location (1)": "Virtual Classroom",
"Add another course under this Booking Ref? (1)": null,
"Course Code (2)": "Course2",
"Course Title (2)": "Title 2",
"Start Date (2)": "2021-08-02",
"Number of days (2)": "2-days",
"Number of delegates (2)": "2",
"Delegate names if known (please separate each name with a comma) (2)": "2d",
"Course Type (2)": "Public Scheduled",
"Net Price per Delegate (2)": "100",
"Net Price (2)": "",
"Trainer (2)": "Jo ",
"Location (2)": "Virtual Classroom",
"Add another course under this Booking Ref? (2)": null,
"Course Code (3)": "Course3",
"Course Title (3)": "Title 3",
"Start Date (3)": "2021-08-03",
"Number of days (3)": "3-days",
"Number of delegates (3)": "3",
"Delegate names if known (please separate each name with a comma) (3)": "3d",
"Course Type (3)": "Public Scheduled",
"Net Price per Delegate (3)": "100",
"Net Price (3)": "",
"Trainer (3)": "Jo ",
"Location (3)": "Virtual Classroom",
"Add another course under this Booking Ref? (3)": null,
"Course Code (4)": "Course4",
"Course Title (4)": "Title 4",
"Start Date (4)": "2021-08-04",
"Number of days (4)": "4-days",
"Number of delegates (4)": "4",
"Delegate names if known (please separate each name with a comma) (4)": "4d",
"Course Type (4)": "Public Scheduled",
"Net Price per Delegate (4)": "100",
"Net Price (4)": "",
"Trainer (4)": "Jo ",
"Location (4)": "Virtual Classroom",
"Add another course under this Booking Ref? (4)": null,
"Course Code (5)": "Course5",
"Course Title (5)": "Title 5",
"Start Date (5)": "2021-08-05",
"Number of days (5)": "5-days",
"Number of delegates (5)": "5",
"Delegate names if known (please separate each name with a comma) (5)": "5d",
"Course Type (5)": "Public Scheduled",
"Net Price per Delegate (5)": "100",
"Net Price (5)": "",
"Trainer (5)": "Jo ",
"Location (5)": "Virtual Classroom",
"Add another course under this Booking Ref? (5)": null,
"Course Code (6)": "Course 6",
"Course Title (6)": "Title 6",
"Start Date (6)": "2021-08-06",
"Number of days (6)": "60",
"Number of delegates (6)": "6",
"Delegate names if known (please separate each name with a comma) (6)": "6d",
"Course Type (6)": "Public Scheduled",
"Net Price per Delegate (6)": "100",
"Net Price (6)": "",
"Trainer (6)": "Jo ",
"Location (6)": "Virtual Classroom",
"Add another course under this Booking Ref? (6)": null,
"Course Code (7)": "Course7",
"Course Title (7)": "Title 7",
"Start Date (7)": "2021-08-07",
"Number of days (7)": "70",
"Number of delegates (7)": "7",
"Delegate names if known (please separate each name with a comma) (7)": "7d",
"Course Type (7)": "Public Scheduled",
"Net Price per Delegate (7)": "100",
"Net Price (7)": "",
"Trainer (7)": "Jo ",
"Location (7)": "Virtual Classroom",
"Add another course under this Booking Ref? (7)": null,
"Course Code (8)": "Course8",
"Course Title (8)": "Title 8",
"Start Date (8)": "2021-08-08",
"Number of days (8)": "80",
"Number of delegates (8)": "8",
"Delegate names if known (please separate each name with a comma) (8)": "8d",
"Course Type (8)": "Public Scheduled",
"Net Price per Delegate (8)": "100",
"Net Price (8)": "",
"Trainer (8)": "Jo ",
"Location (8)": "Virtual Classroom",
"Add another course under this Booking Ref? (8)": null,
"Course Code (9)": "Course9",
"Course Title (9)": "Title 9",
"Start Date (9)": "2021-08-09",
"Number of days (9)": "90",
"Number of delegates (9)": "9",
"Delegate names if known (please separate each name with a comma) (9)": "9d",
"Course Type (9)": "Public Scheduled",
"Net Price per Delegate (9)": "100",
"Net Price (9)": "",
"Trainer (9)": "Jo ",
"Location (9)": "Virtual Classroom",
"Add another course under this Booking Ref? (9)": null,
"Course Code (10)": "Course10",
"Course Title (10)": "Title 10",
"Start Date (10)": "2021-08-10",
"Number of days (10)": "100",
"Number of delegates (10)": "10",
"Delegate names if known (please separate each name with a comma) (10)": "10d",
"Course Type (10)": "Public Scheduled",
"Net Price per Delegate (10)": "100",
"Net Price (10)": "",
"Trainer (10)": "Jo ",
"Location (10)": "Virtual Classroom",
"Add another course under this Booking Ref? (10)": null,
"Course Code (11)": "Course11",
"Course Title (11)": "Title 11",
"Start Date (11)": "2021-08-11",
"Number of days (11)": "110",
"Number of delegates (11)": "11",
"Delegate names if known (please separate each name with a comma) (11)": "11d",
"Course Type (11)": "Public Scheduled",
"Net Price per Delegate (11)": "100",
"Net Price (11)": "",
"Trainer (11)": "Jo ",
"Location (11)": "Virtual Classroom",
"Add another course under this Booking Ref? (11)": null,
"Course Code (12)": "Course12",
"Course Title (12)": "Title 12",
"Start Date (12)": "2021-08-12",
"Number of days (12)": "120",
"Number of delegates (12)": "12",
"Delegate names if known (please separate each name with a comma) (12)": "12d",
"Course Type (12)": "Public Scheduled",
"Net Price per Delegate (12)": "100",
"Net Price (12)": "",
"Trainer (12)": "Jo ",
"Location (12)": "Virtual Classroom",
"Add another course under this Booking Ref? (12)": null,
"Course Code (13)": "Course13",
"Course Title (13)": "Title 13",
"Start Date (13)": "2021-08-13",
"Number of days (13)": "130",
"Number of delegates (13)": "13",
"Delegate names if known (please separate each name with a comma) (13)": "13d",
"Course Type (13)": "Public Scheduled",
"Net Price per Delegate (13)": "100",
"Net Price (13)": "",
"Trainer (13)": "Jo ",
"Location (13)": "Virtual Classroom",
"Add another course under this Booking Ref? (13)": null,
"Course Code (14)": null,
"Course Title (14)": "Title 14",
"Start Date (14)": "2021-08-14",
"Number of days (14)": "140",
"Number of delegates (14)": "14",
"Delegate names if known (please separate each name with a comma) (14)": "14d",
"Course Type (14)": "Public Scheduled",
"Net Price per Delegate (14)": "100",
"Net Price (14)": "",
"Trainer (14)": "Jo ",
"Location (14)": "Virtual Classroom",
"Add another course under this Booking Ref? (14)": null,
"Course Code (15)": null,
"Course Title (15)": "Title 15",
"Start Date (15)": "2021-08-15",
"Number of days (15)": "150",
"Number of delegates (15)": "15",
"Delegate names if known (please separate each name with a comma) (15)": "15d",
"Course Type (15)": "Public Scheduled",
"Net Price per Delegate (15)": "100",
"Net Price (15)": "",
"Trainer (15)": "Jo ",
"Location (15)": "Virtual Classroom",
"Total 1": null,
"Total 2": null,
"Total 3": null,
"Total 4": null,
"Total 5": null,
"Total 6": null,
"Total 7": null,
"Total 8": null,
"Total 9": null,
"Total 10": null,
"Total 11": null,
"Total 12": null,
"Total 13": null,
"Total 14": null,
"Total 15": null,
"TOTAL ALL": null
}
Get a Row:
Get a Row Output - you can see here that all the date formats after Start Date (1) are in numeric format like you get in Excel... I have been into the spreadsheet and played around with multiple formats but I can't get this output to change.
{
"@odata.context": "https://excelonline-ne.azconn-ne.p.azurewebsites.net/$metadata#drives('b%21MV3dXGo7OEC7HgIVW3x2d0pGvuP8vMVNq3OweJuVscEJNdVO3-QcRpCopZSu2y4S')/Files('015PCJQ27OMU5M7K4RB5GKSSFJWHIVMLWS')/Tables('%7B00000000-000C-0000-FFFF-FFFF00000000%7D')/items/$entity",
"@odata.etag": "",
"ItemInternalId": "CW250",
"ID": "",
"Start time": "",
"Completion time": "2021-08-25T16:26:52.000Z",
"Email": "",
"Name": "",
"Managing BDE": "Charlie ",
"Booking Ref": "CW250",
"Booker Name": "Ian ",
"Organisation": "Ian’s company",
"Course Code (1)": "MSEXL1",
"Course Title (1)": "Excel Level 1",
"Start Date (1)": "2021-08-01T00:00:00.000Z",
"Number of days (1)": "1-day",
"Number of delegates (1)": "1",
"Delegate names if known (please separate each name with a comma) (1)": "1d",
"Course Type (1)": "Public Scheduled",
"Net Price per Delegate (1)": "100",
"Net Price (1)": "",
"Trainer (1)": "Jo ",
"Location (1)": "Virtual Classroom",
"Add another course under this Booking Ref? (1)": "",
"Course Code (2)": "Course2",
"Course Title (2)": "Title 2",
"Start Date (2)": "44410",
"Number of days (2)": "2-days",
"Number of delegates (2)": "2",
"Delegate names if known (please separate each name with a comma) (2)": "2d",
"Course Type (2)": "Public Scheduled",
"Net Price per Delegate (2)": "100",
"Net Price (2)": "",
"Trainer (2)": "Jo ",
"Location (2)": "Virtual Classroom",
"Add another course under this Booking Ref? (2)": "",
"Course Code (3)": "Course3",
"Course Title (3)": "Title 3",
"Start Date (3)": "44411",
"Number of days (3)": "3-days",
"Number of delegates (3)": "3",
"Delegate names if known (please separate each name with a comma) (3)": "3d",
"Course Type (3)": "Public Scheduled",
"Net Price per Delegate (3)": "100",
"Net Price (3)": "",
"Trainer (3)": "Jo ",
"Location (3)": "Virtual Classroom",
"Add another course under this Booking Ref? (3)": "",
"Course Code (4)": "Course4",
"Course Title (4)": "Title 4",
"Start Date (4)": "44412",
"Number of days (4)": "4-days",
"Number of delegates (4)": "4",
"Delegate names if known (please separate each name with a comma) (4)": "4d",
"Course Type (4)": "Public Scheduled",
"Net Price per Delegate (4)": "100",
"Net Price (4)": "",
"Trainer (4)": "Jo ",
"Location (4)": "Virtual Classroom",
"Add another course under this Booking Ref? (4)": "",
"Course Code (5)": "Course5",
"Course Title (5)": "Title 5",
"Start Date (5)": "44413",
"Number of days (5)": "5-days",
"Number of delegates (5)": "5",
"Delegate names if known (please separate each name with a comma) (5)": "5d",
"Course Type (5)": "Public Scheduled",
"Net Price per Delegate (5)": "100",
"Net Price (5)": "",
"Trainer (5)": "Jo ",
"Location (5)": "Virtual Classroom",
"Add another course under this Booking Ref? (5)": "",
"Course Code (6)": "Course 6",
"Course Title (6)": "Title 6",
"Start Date (6)": "44414",
"Number of days (6)": "60",
"Number of delegates (6)": "6",
"Delegate names if known (please separate each name with a comma) (6)": "6d",
"Course Type (6)": "Public Scheduled",
"Net Price per Delegate (6)": "100",
"Net Price (6)": "",
"Trainer (6)": "Jo ",
"Location (6)": "Virtual Classroom",
"Add another course under this Booking Ref? (6)": "",
"Course Code (7)": "Course7",
"Course Title (7)": "Title 7",
"Start Date (7)": "44415",
"Number of days (7)": "70",
"Number of delegates (7)": "7",
"Delegate names if known (please separate each name with a comma) (7)": "7d",
"Course Type (7)": "Public Scheduled",
"Net Price per Delegate (7)": "100",
"Net Price (7)": "",
"Trainer (7)": "Jo ",
"Location (7)": "Virtual Classroom",
"Add another course under this Booking Ref? (7)": "",
"Course Code (8)": "Course8",
"Course Title (8)": "Title 8",
"Start Date (8)": "44416",
"Number of days (8)": "80",
"Number of delegates (8)": "8",
"Delegate names if known (please separate each name with a comma) (8)": "8d",
"Course Type (8)": "Public Scheduled",
"Net Price per Delegate (8)": "100",
"Net Price (8)": "",
"Trainer (8)": "Jo ",
"Location (8)": "Virtual Classroom",
"Add another course under this Booking Ref? (8)": "",
"Course Code (9)": "Course9",
"Course Title (9)": "Title 9",
"Start Date (9)": "44417",
"Number of days (9)": "90",
"Number of delegates (9)": "9",
"Delegate names if known (please separate each name with a comma) (9)": "9d",
"Course Type (9)": "Public Scheduled",
"Net Price per Delegate (9)": "100",
"Net Price (9)": "",
"Trainer (9)": "Jo ",
"Location (9)": "Virtual Classroom",
"Add another course under this Booking Ref? (9)": "",
"Course Code (10)": "Course10",
"Course Title (10)": "Title 10",
"Start Date (10)": "44418",
"Number of days (10)": "100",
"Number of delegates (10)": "10",
"Delegate names if known (please separate each name with a comma) (10)": "10d",
"Course Type (10)": "Public Scheduled",
"Net Price per Delegate (10)": "100",
"Net Price (10)": "",
"Trainer (10)": "Jo ",
"Location (10)": "Virtual Classroom",
"Add another course under this Booking Ref? (10)": "",
"Course Code (11)": "Course11",
"Course Title (11)": "Title 11",
"Start Date (11)": "44419",
"Number of days (11)": "110",
"Number of delegates (11)": "11",
"Delegate names if known (please separate each name with a comma) (11)": "11d",
"Course Type (11)": "Public Scheduled",
"Net Price per Delegate (11)": "100",
"Net Price (11)": "",
"Trainer (11)": "Jo ",
"Location (11)": "Virtual Classroom",
"Add another course under this Booking Ref? (11)": "",
"Course Code (12)": "Course12",
"Course Title (12)": "Title 12",
"Start Date (12)": "44420",
"Number of days (12)": "120",
"Number of delegates (12)": "12",
"Delegate names if known (please separate each name with a comma) (12)": "12d",
"Course Type (12)": "Public Scheduled",
"Net Price per Delegate (12)": "100",
"Net Price (12)": "",
"Trainer (12)": "Jo ",
"Location (12)": "Virtual Classroom",
"Add another course under this Booking Ref? (12)": "",
"Course Code (13)": "Course13",
"Course Title (13)": "Title 13",
"Start Date (13)": "44421",
"Number of days (13)": "130",
"Number of delegates (13)": "13",
"Delegate names if known (please separate each name with a comma) (13)": "13d",
"Course Type (13)": "Public Scheduled",
"Net Price per Delegate (13)": "100",
"Net Price (13)": "",
"Trainer (13)": "Jo ",
"Location (13)": "Virtual Classroom",
"Add another course under this Booking Ref? (13)": "",
"Course Code (14)": "",
"Course Title (14)": "Title 14",
"Start Date (14)": "44422",
"Number of days (14)": "140",
"Number of delegates (14)": "14",
"Delegate names if known (please separate each name with a comma) (14)": "14d",
"Course Type (14)": "Public Scheduled",
"Net Price per Delegate (14)": "100",
"Net Price (14)": "",
"Trainer (14)": "Jo ",
"Location (14)": "Virtual Classroom",
"Add another course under this Booking Ref? (14)": "",
"Course Code (15)": "",
"Course Title (15)": "Title 15",
"Start Date (15)": "44423",
"Number of days (15)": "150",
"Number of delegates (15)": "15",
"Delegate names if known (please separate each name with a comma) (15)": "15d",
"Course Type (15)": "Public Scheduled",
"Net Price per Delegate (15)": "100",
"Net Price (15)": "",
"Trainer (15)": "Jo ",
"Location (15)": "Virtual Classroom",
"Total 1": "100",
"Total 2": "200",
"Total 3": "300",
"Total 4": "400",
"Total 5": "500",
"Total 6": "600",
"Total 7": "700",
"Total 8": "800",
"Total 9": "900",
"Total 10": "",
"Total 11": "",
"Total 12": "",
"Total 13": "",
"Total 14": "",
"Total 15": "",
"TOTAL ALL": ""
}
'Populate Word Document' fields all pull in data from the Get Row action.
I hope that helps? Sorry if not... am new to all this!
Thanks in advance
Samantha
