Hi Nintex Communities,
I have three rows of data in the SharePoint List. Two of the rows contain the same vendor name (i.e., ABD Sdn Bhd) and Type of Agreement, but with different Agreement Dates and Agreement Numbers. Please refer to the SharePoint List screenshot.
I would appreciate your advice and guidance on the best approach to extract the three rows of data from the SharePoint List and consolidate the records by Vendor ID. The output should display the Agreement Date, Agreement Number, and Type of Agreement associated with the same vendor.
The workflow should then proceed to generate a separate PDF for the next vendor. Please also refer to the screenshots “Agreement Template PDF 1” and “Agreement Template PDF 2” for reference.
Thank you,
Liy Liy
