
I am looking to utilize the smartsheet connector to add a row to a given sheet at completion of a data input form around project budgets and utilization.
My outbound flow utilizes the smartsheet.insertrow action as shown below with the following columns to be updated.
Each column to be updated has a corresponding data field entry within my PowerApp for data input.
I have created a 'Submit' button that I would like to trigger the flow to take action and utilize the smartsheet action to fill the form and submit the InsertRow.
My current understanding of structure is as follows but unable to currently link across App to Flow
- Initialize variable within the flow 'AddTimeEntryRowtoSS' for each data point required
--- 'PrimaryV' 'ResourceV' etc..
- In 'OnSelect' command utilize the values from the the input form to map to the flow data points