Answered

Extracting data from a form to a csv file, populating office details, just by choosing which office.

(0) Share

Report

Posted on by Tim-Holmes73

I am using forms to create a user CSV. HR will fill out the form, then I want power automate to populate the csv so I can use this to create a user. I need to take the first letter of the first name and use the whole of the surname.

In the form, I ask the HR rep for the persons first and last name, manager etc. Then I want to just create that into the CSV, I can move the stuff over easily enough, for the name and manager etc, I know how to do this with Powershell, but I am having difficulty with it when I use the 'create csv table' option. Is there an 'Expression' I need to use?

We have two sites, and I want to put the branch in, if this site is chosen, populate this whole address and if this site is chosen, then choose this one.

Any ideas or comments thankfully recieved

Thanks

TIm

All responses (5)

Answers (2)

ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Extracting data from a form to a csv file, populating office details, just by choosing which office.

@Tim-Holmes73

I am glad that I could assist!

If my suggestions helped you solve your issue, please mark my post as the solution - that will help others with a similar question quickly find a solution.
Tim-Holmes73 24 on at

Like (0)

Report

Re: Extracting data from a form to a csv file, populating office details, just by choosing which office.

Awesome, just the nudge I needed in the right direction.
Thanks
Verified answer

ScottShearer 25,228 Most Valuable Professional on at

Like (1)

Report

Re: Extracting data from a form to a csv file, populating office details, just by choosing which office.

@Tim-Holmes73

It depends on where the address data is stored. For example, it there is a SharePoint list where the address info is stored, you can look it up via Power Automate (assuming that there is a way to link the data such as the city name). If you have the data stored in SQL Server as well as many other locations, you can access that data via Power Automate but it will require an upgraded license.
Tim-Holmes73 24 on at

Like (0)

Report
Re: Extracting data from a form to a csv file, populating office details, just by choosing which office.

I just realized I am doing this through Powershell,
$username = Name.substring(0) + " " + $Lastname
but what I do need is to be able to choose from 2 addresses, and when I choose the Vancouver office on the form, it will populate the Street address, City, state, zip etc. Is there a way to do this?
Thanks again
Verified answer

ScottShearer 25,228 Most Valuable Professional on at

Like (1)

Report

Re: Extracting data from a form to a csv file

@Tim-Holmes73

See my example below - not sure if this is what you are asking for... I used a Compose actions for the first and last names - you will just reference the data from Forms. I could have/should have used a compose action rather than a variable. Let me know if you have any questions.