When a new row is created in smartsheet get the data from that new row and use it in Power Automate
I have a Smartsheet sheet which is populated using a Smartsheet form. When the form is submitted it creates a new row in the Smartsheet and inserts the relevant form data into the corresponding Smartsheet columns.
I now want to use the data from that row in a flow in Power Automate. I am using the "When a new row is created" trigger but I am struggling to then access/use the data in the columns of that new row.
For example one of the values is User Department Name - I want to take the value from that column for the newly inserted row and use it in Power Automate email or updating a sharepoint list etc... etc...