Power Platform Community Forum Thread Details

Hello,

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.

Note: Data is pulling for nearly 800+ stores and 1 person will visit 4 or 5 stores in a week and comments may vary.

Data Available in the Sharepoint:

Store Name	Store No	Name	Email	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

Expecting Result:

Name	Email	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

Current Result:

Name	Email	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