Power Automate Smartsheet Row to Microsoft Teams Channel Posting

Robby Elliott

Hey everyone I am trying to set up a flow when a row in smartsheet is added a message is sent to a specific Teams Channel.

I have the following:

Trigger for power automate "When a new row is created"

followed by "Get a sheet data (dynamic schema)

Then "post a message in a chat or channel"

When i run this is populates a separate message for every single row.

Can someone help me only populate the newly created row, not everything?

Thanks,

Robby

Genevieve P.

Hey @Robby Elliott

From your description it sounds like the trigger for the workflow is separate from the action. This means that each time a new row is created, the workflow gets the entire sheet.

In this other discussion Laurel was able to just get the "last row" by adding a formula:

https://community.smartsheet.com/discussion/comment/323065#Comment_323065

If this other thread hasn't helped, I would suggest posting directly in the Power Automate Community, here.

Cheers,

Genevieve