We then added another action to copy this data to the existing employees sheet.įinally, we ran the flow to confirm it works correctly. Let's stop here, and recap what we've done.įirst, we created an action to find all the data in the new employees sheet. If we open the existing employees file in Excel, we can see the new employees have been added successfully, which confirms the flow is working properly. If we follow the link to the Flow Runs Page, we can see the flow has run successfully. We have the files closed, so we'll press Continue, and then Run Flow. The flow then checks that we have the appropriate connection to Excel Online ready to go.Īt this point, note that you shouldn't have the Excel files open when trying to run the flow as the flow will fail if the files are open. We'll test the flow manually, and select Test. So let's move on to step three.įirst, we'll press the Save button at the bottom of the flow to save it.Īnd then we'll select Test in the top right corner to test the flow. We'll select Employee Name here, and then select the appropriate content for ID number, location, and division. If we select the employee name box, we can see we have a piece of dynamic content for each of the four columns in our table, representing a row extracted from Excel in the previous step. This time, we're looking for the file that we want to add data to, so we'll select the folder icon, and find the existing employees file.Īs before, the table in this file is named employee details.įinally, we need to specify what data we're adding.Įach time we add a row to the existing employees sheet, we need to access the output of the previous action in the flow. Here, the action we want is to add a row into a table, so we'll select this.Īs before, the location will be OneDrive for Business, and the document library will be OneDrive. We'll select Add an action, and select Excel Online again. Now we can add an action to determine what to do with these rows. We've now set up a loop that will run on every row we extracted from the new employee sheet in the previous step. We'll select the value option, which represents a list of the values returned by the previous action. If we select this box, the dynamic content box shows us the outputs of the previous step in the flow. This will perform an action on each row we listed in the previous step.įirst, we need to select the relevant output from the previous step. In order to add a loop to our flow, we'll select Control, and we'll choose Apply to each. Let's select New step, to add this action to our flow. This will add new employees to the existing employees sheet until it runs out of new employees to add. In Power Automate, we need to add this data one row at a time, which means we need to add a loop to our flow. We're now ready to move on to step two, where we'll copy this data into the existing employees sheet. This action will go into the new employees file and extract the data from the employee details stable. We've now completed our first action in this flow. We'll select the folder icon, and find the New Employees file.įinally, we'll select the table and we can see the only table of data in this file is the Employee Details table. We then need to specify the file we're connecting to. ![]() We'll specify the location of the Excel file we're connecting to, which is OneDrive for Business, and the document library, which is OneDrive. ![]() Now we need to configure the details of this action. We're looking to identify all the rows from the new employees sheet, so the action we're looking for is list rows present in a table. This brings up a list of all the actions we can take for an Excel sheet. We're going to connect to an Excel sheet, so we'll select Excel Online Business. We now have to choose what kind of action we want to add based on what data we want to connect to. Let's start with step one, where we'll add an action to our flow to find the data in the new employees sheet. We'll then add an action to copy this data into the existing employees sheet.įinally, we'll run the flow and make sure it all works. In this lesson, we'll build the flow by creating several actions.įirst, we'll add an action to find the relevant rows in the new employees sheet. In the previous lesson, we created a flow that we're going to build manually by combining actions together.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |