Currently i have created the flow to sent the mail from the details(next 7 days) available in the sharepoint. Comments are available in the mail but i need the comments to be updated for each and individual comments from sharepoint instead it just updating the one recent comments for all the employees in the mail. Please help.
Data Available in the Sharepoint:
| Store Name | Store No | Name | Visit Date | Time | Status | Comments | |
| AA | 1 | AABBCC | AABBCC@mail.com | 16-Dec-24 | 07-00 to 15-00 | Booked | Help |
| AA | 1 | AABBCC | AABBCC@mail.com | 17-Dec-24 | 07-00 to 15-00 | Booked | |
| BB | 2 | BBNNDD | BBNNDD@mail.com | 16-Dec-24 | 09-00 to 14-00 | Booked | Must Visit |
| BB | 2 | BBNNDD | BBNNDD@mail.com | 17-Dec-24 | 09-00 to 14-00 | Booked | Required HS |
| CC | 3 | CCPPMM | CCPPMM@mail.com | 19-Dec-24 | 10-00 to 12-00 | Booked | Visitng Data |
| DD | 4 | NQTOM | NQTOM@gmail.com | 20-Dec-24 | 07-00 to 15-00 | Booked | Helping Conditions |
| Name | Date and shift time | Comments | |
| AABBCC | AABBCC@mail.com | 16-12-2024 - 07-00 to 15-00 | Help |
| AABBCC | AABBCC@mail.com | 17-12-2024 - 07-00 to 15-00 | |
| BBNNDD | BBNNDD@mail.com | 16-12-2024 - 09-00 to 14-00 | Must Visit |
| BBNNDD | BBNNDD@mail.com | 17-12-2024 - 09-00 to 14-00 | Required HS |
| CCPPMM | CCPPMM@mail.com | 19-12-2024 - 10-00 to 12-00 | Visitng Data |
| NQTOM | NQTOM@gmail.com | 20-12-2024 - 07-00 to 15-00 | Helping Conditions |
| Name | Date and shift time | Comments | |
| AABBCC | AABBCC@mail.com | 16-12-2024 - 07-00 to 15-00 | Helping Conditions |
| AABBCC | AABBCC@mail.com | 17-12-2024 - 07-00 to 15-00 | Helping Conditions |
| BBNNDD | BBNNDD@mail.com | 16-12-2024 - 09-00 to 14-00 | Helping Conditions |
| BBNNDD | BBNNDD@mail.com | 17-12-2024 - 09-00 to 14-00 | Helping Conditions |
| CCPPMM | CCPPMM@mail.com | 19-12-2024 - 10-00 to 12-00 | Helping Conditions |
| NQTOM | NQTOM@gmail.com | 20-12-2024 - 07-00 to 15-00 | Helping Conditions |

Report
All responses (
Answers (