Hi everyone, hope all is well.
I got an App connected to two different Sharepoint lists.
One is Called A
The other one is called Milestones
The App takes info the user inserts in the App and uploads it to one of these lists.
The flow is as follows:
1. user inserts info that goes to A (trough submitForm)
2. App asks if user wants to add one or more Milestones to this A.
3. If the user answer is yes then there is a new screen with new information the user needs to fill in.
4. This new info will then be uploaded to the A Milestones list.
All this has been done by a colleague that left. I am pretty new to this and am still trying to understand many parts of it.
My task is to get automated mails at certain dates from each milestone. This is possible with automated Flow (Recurrence -> get Item (filter) -> For each(sent mail))
My issue is that my automated flows gets item from list 2 (A Milestones) and i need some information (email addresses) that is stored in list 1 (A).
With my little knowledge i see two possibilities:
1. Somehow, in powerapps, i add the info that is stored to list 1 (A) to list 2 (A Milestones). Here the question that arises is. How exactly does the submitForm work? > What variables does it upload to my list? > all? > only the ones that are written in the same "OnSelect" as the SubmitForm? I cant seem to find a clear explanation of how it works and therefore cannot work this out.
2. In AutomatedFlow, i get items from list 2 but how do i get to use variables from list 1 to use them in my "sent to" input
Thank you in advance!
