Please do not send links for what you followed, we need to see what you have done specifically. We cannot debug someone elses code that probably worked or they wouldn't have recorded it hehe.
Ok so, without seeing what you have here are some instructions based on educated guesses which (wastes a lot of time) versus just sharing what you have..
1. Trigger ( I have no idea when you want to trigger, but I am assuming a Reocurring trigger every day at some set time)
1b. Create an Array, that we will use to store the line items to email about.
--I suggest that you actually initialize it with headers so when you send the table its nice looking with headers to the user
2. Get items A1
3. Select (only pulling the person's email address who owns that line. You will want to get into advanced mode in the Select to click the little button. since all we need is literally the Dynamic Column nothing else
4. A Compose so we can get the Unique Email addresses or whatever you use to identify people, since I am assuming they can have more than 1
-type the expression union(body('Select', body('Select'))
This will give you a unique list of users nothing else
5. Add an Apply to each with the output of #4 so we can loop through each users specific rows in the secondary list
--Inside the apply to each
5a. add a Filter Array.
---The input comes from step 2 (the original get items)
---The left side should be the dynamic property for the email/unique identifier
---middle = is equal to
---right = item() <== since we only added the dynamic property its the ONLY column of data and it has no header, so we are just looping through unique strings
5b Add another apply to each and use the data in step 5a, because we need to see if there is a record in the other table (and if not email) OR if the record in the other side is over 2 weeks or whatever and email.
5b. Add another Get Items <== with the filter being the current
5c. add a condition to check the expression length(Dynamic value from 5b) is equal to 1
--why do we do this? Because we will either get 1 row or 0 rows for that Scheme/Person in the second table
In the Yes side, we assume 1 means yes
--In the yes side, you can check if its been more than 2 weeks by using a condition
have the condition check if its more than 2 weeks and if so, then use the Append Array, to add the information about the scheme , so we have it for the email
In the No Side,
we do not need a condition, it didn't find any records, so you just need to use Append Array to add the information about the scheme , so we have it for the email
I would suggest having a Column Header like Reason
when there is no record, the reason is No Record
when its more than 2 weeks, the reason is More than 2 weeks old
NEXT Email them wtih data
1. Outside the 5B apply to each (remember that one is building up the information we want to send to the user), but still inside the step 5 Apply to each
we want to add a Create HTMl Table action. Using the Array as the input and selecting that there are headers
2. Now add a Send Email V2
For the body put whatever you want, but also put the outputs of the Create HTML Action to add the table.
If you want to make it pretty looking you need to use CSS. Like this
OK, now your work will loop through and capture then email the people.
Please please, go through each step, read it carefully and just create the flow as it states, then come back if you have questions, but its in order as is needed.
The only thing I do not know is, what is the unique identifier between the 2 lists and for sure, if the users email is in the line items in A1.
But you have to be able to group by the Person who owns the line items in A1. If you cannot then you cannot send them an email with their details.
Heck draw it on paper if you need too to get it down and understandable :-)
If this answers you question please Mark as such and maybe a like.
Thanks
