Power Automate Smartsheet Row to Microsoft Teams Channel Posting

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.