I am having an issue when creating a new item in SharePoint and adding rows to an Excel Table (using Power Automate). The main issue seems to be the SharePoint column field, specifically a "Choice" (drop down with checkboxes). Using Power Automate, when an item is created a row will be added to an Excel table (on SharePoint). If the Item's column field happens to be a "Choice", as opposed to a single line of text, the data added to the Excel table will be duplicate rows (the variance in duplicate rows being the checkbox selections). Is there a way to combine all of the checkbox selections onto a single row and not create duplicate rows?

Report
All responses (
Answers (