Answered

When a new row is created in Smartsheet, Create SharePoint List Item

(0) Share

Report

Posted on by chasquad

I'm trying to do my first Smartsheet flow. I've created a SharePoint list to hold the data. When a new row is added to a Smartsheet, I would like for that row of data to be used to create a new item in a SharePoint List.

The part that I need help with is the mapping of the columns from the SharePoint Create Item step. Need to map the columns to the ones coming in from Smartsheet.

smartsheet mapping.PNG

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report

Re: When a new row is created in Smartsheet, Create SharePoint List Item

Hi @chasquad ,
Do you want to when a new row is added to a smart sheet, use that row's data to create a new item in a SharePoint list?
If so, I have a test for your reference.
In my scenario:

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
glennvdmconsult 13 on at

Like (0)

Report

Re: When a new row is created in Smartsheet, Create SharePoint List Item

Hi @v-yetonggu-msft,

Great solution .... I need a similar solution that requires a SharePoint folder to be copied and renamed when a new Sharepoint row is added ... the renamed folder needs to apply SharePoint cell values such as project number (cell 1), project name (cell 2) and project address (cell 3)

Any suggestions would be greatly appreciated.

🙂

Was this reply helpful? Yes No
tjb21121 2 on at

Like (0)

Report

Re: When a new row is created in Smartsheet, Create SharePoint List Item

In the 'ApplytoEach' step, how are you able to extract the Smartsheet column name called "Tasks" ? From what I see, there's no way to parse the actual smartsheet to get those values so I'm missing something in your step.

Was this reply helpful? Yes No