I'm am trying to write my first flow. I am trying to take a schedule from a daily email and write it to a table in excel.
I have gotten as far as the trigger from the email arriving and parsing the text from the email into an array (ScheduleArray2d).
Now I am having trouble pasting the info into Excel.
I need to make sure that the right appointment name goes with the right appointment time. Sometimes there are cancelled appointment times, so not every block of time will be used. I have been able to use "update a row in Excel" and mapped the key column and value. But I cannot figure out how to insert a dynamic value in the updated "Name" field that references the correct name in the ScheduleArray2d variable.
ScheduleArray2d:
[
{
"ID": "1",
"Time": "11:00 AM",
"Name": "Muirenn Poulin"
},
{
"ID": "1",
"Time": "11:30 AM",
"Name": "Shaina Wauters"
},
{
"ID": "1",
"Time": "12:00 PM",
"Name": "Alana Del Bosque"
},
{
"ID": "1",
"Time": "12:30 PM",
"Name": "Caeso Saito"
},
{
"ID": "1",
"Time": "1:00 PM",
"Name": "Edvin Watts"
},
{
"ID": "1",
"Time": "2:00 PM",
"Name": "Olimpia De Ven"
},
{
"ID": "1",
"Time": "2:30 PM",
"Name": "Yaroslav Landau"
},
{
"ID": "1",
"Time": "3:00 PM",
"Name": "Shamira Dustin"
},
{
"ID": "1",
"Time": "3:30 PM",
"Name": "Subrahmanya Bohn"
},
{
"ID": "1",
"Time": "4:00 PM",
"Name": "Nikodim Reis"
}
]
Excel Table
