Hi,
I've been experimenting Microsoft flow to initiate an approval request on a sharepoint list submission.
Have encountered many challenges, redesigned the flow and feel i'm the right direction until i hit a barrier which had put me on a hold. I've looked at many discussions thread around here however none was able to help.
Below is the process of my flow that I have summarize to the challenge faced.
I have an array of items.
[
"DepartmentA->DeptAOwnerEmail",
"DepartmentB->DeptBOwnerEmail",
"DepartmentC->DeptCOwnerEmail",
"DepartmentD->DeptDOwnerEmail"
]
1. used "Apply to each" & item() to extract data from array: GOOD
"DepartmentA->DeptAOwnerEmail"
2. using split command, i extracted data into another array(just 2 items per array): GOOD
Example:
[
"DepartmentA",
"DeptAOwnerEmail"
]
3. Now the challenge I have is using the Array(output) and passing it on to another "Apply to each" loop
The reason I'm doing this is because I am trying to set an initialized variable with the output from here which will be used in a later part of the flow.
dept = "DepartmentA"
deptowner = ""DeptAOwnerEmail"
in theory, if initial array consists of 4 items, there will be 4 sets of dept & deptowner.
within the loop itself, an approval request will be made using data from above. Initial array value depends on the data on the sharepoint list itself, ranges from 0 to 11 maximum.
Without even reaching "set variable" action, I can see that the output from previous "split" command is NOT being passed on to the 2nd "Apply to each" loop.
Any help would be much appreciated.