Hi
Actually I am creating app for canteen to order the food for for employees.
Food requirement - Tiffin, Lunch, Snacks & Dinner. Users are ordering the food what they need.
Now I want to send a scheduled mail with filter all the Tiffin data and sent a mail at 8 AM, Lunch data and sent a mail at 12 Noon,
Snacks data and sent a mail at 4 PM and Dinner data and sent a mail at 8:30 PM.
I am patching the data as records in JSON format from canvas app to Share Point List as follows (dummy data)
[{"Date":"2023-02-20","Employee_ID":"500891","Employee_Name":"H DHARMENDER","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"12","Shift":"A"}] [{"Date":"2023-02-20","Employee_ID":"501653","Employee_Name":"S BALARAJU","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"123","Shift":"A+B"}] [{"Date":"2023-02-20","Employee_ID":"500891","Employee_Name":"H DHARMENDER","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"12","Shift":"A"}] [{"Date":"2023-02-20","Employee_ID":"501412","Employee_Name":"EPETER PAUL","Meal_For":"Tiffin","Meal_Type":"DUTY","Remarks":"21","Shift":"A+B"}] [{"Date":"2023-02-20","Employee_ID":"521821","Employee_Name":"Pallapu Madhu","Meal_For":"Dinner","Meal_Type":"DUTY","Remarks":"Night continued","Shift":"B+C"}] [{"Date":"2023-02-20","Employee_ID":"520629","Employee_Name":"M VAMSIKRISHNA","Meal_For":"Dinner","Meal_Type":"DUTY","Remarks":"For beml assy","Shift":"G+B"}] [{"Date":"2023-02-20","Employee_ID":"BML0088","Employee_Name":"K.Madhu kumar reddy","Meal_For":"Dinner","Meal_Type":"DUTY","Remarks":"For beml assy","Shift":"A+B"}] [{"Date":"2023-02-21","Employee_ID":"521290","Employee_Name":"MANUGONDA HARISH KUMAR","Meal_For":"Lunch","Meal_Type":"DUTY","Remarks":"No","Shift":"A+B"}] [{"Date":"2023-02-21","Employee_ID":"521899","Employee_Name":"Sunkari Prashanth","Meal_For":"Dinner","Meal_Type":"DUTY","Remarks":"INSPECTION","Shift":"A+B"}] [{"Date":"2023-03-03","Employee_ID":"BML0079","Employee_Name":"M.Shankar","Meal_For":"Lunch","Meal_Type":"CP","Remarks":"For beml assy","Shift":"A"},{"Date":"2023-03-03", "Employee_ID":"BML0080","Employee_Name":"V.Ajay","Meal_For":"Lunch","Meal_Type":"CP","Remarks":"For beml assy","Shift":"A"},{"Date":"2023-03-03","Employee_ID":"BML0090", "Employee_Name":"P.Jahangeer baba","Meal_For":"Lunch","Meal_Type":"CP","Remarks":"For beml assy","Shift":"A"},{"Date":"2023-03-03","Employee_ID":"BML0085", "Employee_Name":"M.Arun kumar goud","Meal_For":"Lunch","Meal_Type":"CP","Remarks":"For beml assy","Shift":"A"},{"Date":"2023-03-03","Employee_ID":"BML0091","Employee_Name":"Sibatullah", "Meal_For":"Lunch","Meal_Type":"CP","Remarks":"For beml assy","Shift":"A"}]
All the records (JSON Format) are patching by different users
At present I am able to send email with one JSON record directly from Sharepoint List by using flow
ParseJSON Select Create HTML Table etc.
Request your support to filter the data in all JSON records directly from sharepoint list (Filter with Date or Employee ID or Shift etc) and send email in Power Automate.
Thanks & Regards