
Announcements
I thought this was an option, but I can't seem to get it to work.
I want to be able to add a comment into the row of the Smartsheet that was just modified by the input row feature in Flow.
Problem is the "Add discussion to a row" requires a row ID, but I'm only able to input Row number.
After your "Insert Row" action for Smartsheet:
1.) Add an "Initialize Variable" action.
- Name: Whatever (I went with 'ROW_ID')
- Type: 'String'
- Value: Click the button to enter an expression and input outputs('Insert_row')?['body/result/id']
(You could simply put this value in the next step, but I like having it as a variable now in case I need it elsewhere)
2.) Add your "Add a discussion to a row" Smartsheet action
- Add your "Sheet"
- On "Row Id", click the button for adding dynamic content (the lightning bolt) and choose your ROW_ID variable you created.
- Do whatever you need for Title and Text.
That should be it...
This was so ridiculously painful to figure out that I created an account just to answer this in case anyone else tries to fine a clearly defined solution.