Creating a folder in Sharepoint from Smartsheet and naming it based on row data

Like (0) Share

Report

Posted on 28 Mar 2023 10:02:29 by amync

Hi there,

I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the dynamic content fields from Smartsheet but they are limited and do not contain the column data I'm looking for.

Any ideas on how else I might be able to do this?

Thanks

Sharepoint folder...

All responses (1)

Answers (0)

Unknown geen idee 1,755 on 28 Mar 2023 at 14:32:08

Like (0)

Report

Re: Creating a folder in Sharepoint from Smartsheet and naming it based on row data

Dear Amymc,

We covered a similar item recently, have a look at: https://powerusers.microsoft.com/t5/Building-Flows/Copy-Smartsheet-to-Excel/m-p/2061368#M227730.
Common issue is that the output from Smartsheet is not directly usable ... seems they have not made it directly compatible.

Hope it helps,
Happy flowing,
Koen