Advanced Excel in Microsoft Power Automate Desktop - Use Case for Accountants

Excel is straightforward in Microsoft power automate for desktop today we will solve an accounting case the mission is to get the latest Community rates from the web page and write them in the correct places on this sheet Danish krona DKK is our base currency then in our accounting sheet we have multiple transactions with different currencies for each row we want to determine which currency is used then look up the previous sheet and write the correct exchange rate finally do the calculation qnc amount times exchange rate divided by 100 and write it in the amount DKK my name is Anna Jensen let's learn some Advanced Microsoft power automate for desktop first navigate to the course page there's a link to it in the video description then click download the now go up here click the three dots and take download I will be placing this Excel book on my desktop so I move it out here let me just minimize this so you can see my desktop then I make a folder so I right click new Boulder and I will call this currency RPA like this then I move the Excel sheet into here and then I will get the path of that here comes the trick you can press shift on your keyboard I repeat shift on your keyboard and right click with your mouse and then you can see a copy as path we will use that so click here then we go to Power automate for desktop where I have been creating a flow first we set a variable for the project path so find a set variable here and drag that one in we will call this project path so up here in variable say project path that