How can I take a single piece of data from excel and use it to name share point folder?

[Angelbrain]

Hello.

I have a requirement for the following from a form I have created:

When the form is filled out and submitted I require power automate to do 4 actions..

• create a new line in an excel doc, creating a unique ‘job number’ for each line.
• create an item in planner.
• create a new folder in sharepoint for attachments, included in the form submission, along with a .txt file with form data. 
• email to confirm completed form.

I have all of the above working but what I would like to is take the unique ‘job number’ from the newly created line in excel and use that to name the sharepoint folder and planner entry.

Any and all advice is welcome.

cheers

[v-qiaqi-msft · Accepted solution]

Hi @Angelbrain,

Based on the issue that you mentioned, do you want to name the folder once a new job number is submitted?

Could you please share a bit more about your scenario?

 

Actually, if you want to create a new folder dynamically when you submit a new job number, you could check as below: