hello everyone welcome to RPA solution channel in this video I'm going to explain how we can able to call a builder or other cloudflow connectors from the power automate desktop usually we will call the desktop force from the cloud uh using the registration of the machine and we will can able to trigger the dtop flows using the cloud flow but there are no direct actions so we can able to call Cloud flows from the desktop we can use the HTTP request or response methods and which will generate the
TTP post URL which will be utilizing inside the inoke web services from the power autom and desktop so in order to call a builder actions or other Cloud flow let me quickly create a HTTP request uh trigger and we can call Any Other Name can simply create this one so I switch back to the old design which I will be getting used so when we uh create this particular Trigger or adding this trigger we will be getting HTP post URL and this URL will will be utilizing inside the in weip Services action
so for uh who can able to trigger the flow you can simply quick any user or anyone and once we added it will require some Json schema for to uh use the input variables or output variables simply create one variable from the Json script so if it is a string we can use inside the string variables if it is a number you can simply type the number amount so once we created our requirement variables we can simply click done it will autop populate the schema data so two different variables I created on
e is a string and another one is the integer so next step will be We Will adding the response whichever the request we are doing so response action or triggers can type fully yeah this is the one we need to select so what it will do is simply whenever the request is invoked it will be receiving the status whether it's a 200 means success or 400 41 43 depending upon the type of failures we are getting uh usually generally 200 means it's a successfully invoke the cloud flow or the request is recei
ved so we can out body format we can give and we can whatever the output variables from the pad it can be able to send it back to from and to the cloud flows so when HTTP and we can simply click save button to generate the URL once we click the save uh if as you can see uh the URL will be generated we can simply copy this one go back to our power autom desktop create a new flow and initiate or set a variable so I'm copying that URL here so as you can see the value will showing as invalid because
the syntax of this particular will be quickly modifying that one before that let me just quickly change the your variable name and here if you see there are the syntax related to the particular website we need to either reversing this one using the our regular slash to get it as per the syntax otherwise you can use the uh this dollar symbol can simply change it back to the slash so once we change it we canly save and the next action we required was to get the output variables or the actions we
want to transfer the particular output variables to Cloud so simply create another two varable which we created in the cloud so where one can give any name simply copy paste this action and uh we will be creating this second variable as integer this will be passed as the output so to the cloud so next action will be the invoke service invoke web services [Music] action so the URL will be the the requested URL we are using from the HTTP request so we can simply already created that inside a varia
ble so we can simply use that variable so the method will be the post because we are calling uh desktop to Cloud uh so we will be using the post method so the accepted format we will be using as a Json so because the content we are doing so we can simply type the Json and the requested body so here we can assign the variable formats from the cloud flow so we created two variables in the cloud right can we will just assign the values based upon so the exact values we need to pass inside the deskt
op flow so input one and in these are the two variables I created so you can simply pass those one and it will be string uh we can use the variable like this and integer so like this way you can simply click save uh before that we need to uncheck one more one so encode the requested body if we should need to uncheck otherwise sometimes the syntax errors or related content for the Json format will get affected can simply click on check click on Save and let me just put inside the quotation this i
s the string where will be defined this is the one and uh when we adding the two variables okay so next we will defining the one more variables in the cloud initializing the variable so this variable will be considered as input to the power autom desktop instead of testing we can able to pass between the two systems or three systems from the cloud to power automat power automate desktop to the cloud so you can simply some give name and the string value so next will be we will be calling the a bu
ilder dire actions as I told you in this video uh in order to add the table dire actions we need one one drive folder where we are keeping the output file where we are storing the data of the extracted invoices so in this out uh a builder action we are extracting the these three information fields for suppose uh as you can see here in the screen so invoice ID or the invoice company name and that will be extracting the total balance du so these are the three things I will be extracting using the
a builder so let me quickly add the action so the file path we will be providing inside the a builder we will get as the how we can able to get that file so I will be using the one drive action to get the file content so not the one drive for business if you are you're already using one drive for business you can use it otherwise I'm using a regular one drive so we will be getting the input file fight path for particular thing and get file content using the path this is the action we will need t
o use so the file path will be the it's under test folder and this is the invoice we are getting extracted next action we will be adding AA Builder extract invo extract information from the invoices so this is the pre-built model we can use directly without creating a customer so the invoice input will be the file content which we are getting from the one drive so once we added so how we need to uh once this information is extracted where we need to save it will be inside the one of excel so thi
s is the Excel file I created and we need a minimum of one uh table it need to pass the data to that particular table related columns or cell values okay let me quickly add a another [Music] action Excel online here also again uh you can use Excel onine or business I will be using Excel online one drive so add a row into a table so you need to select the particular path of the table it will be inside a test folder and book one is the one and the table name whatever the table you are giving so th
is is the table I created so in this table we have the three different values and whatever the information we extracted it will be autop populated in the dynamic content can simply type so if you type the name it will be the customer name and if you type the ID it will be the invoice ID or the customer ID we will be extract the invoice ID and the total amount of balance you so you can simply type invoice total so these are the three fields we extracted you from the invoice so the same three Fiel
ds I will be passing back to the power automate desktop can simply type and use the whether you can use the existing Excel values or whether you can directly pass that extractor information from the a builder so I will be passing customer Name ID nice ID and the total value so this way these values can be going as the input parameters or the parameters which is going into the power automatem and whatever the data we added here these values will be uh consider as outputs and we can able to pass b
ack to the cloud flow so that's what we added initializing of this variable and to get those values we can simply create a another action set variables so we will be setting the variable uh values as input and another integer so this will be uh which you are getting from the power autom desktop okay that's it uh it looks good and let me quickly save and try to run it so this is automated flow Whenever there is a request is received from uh Power autom desktop or HTTP response we will be this flo
w will be automatically getting triggered so let me just quickly save and run from the power automate desktop so we are using the same URL and the same variables we are passing from the desktop so only if you see any AR related to the syntax and all you can just quickly uncheck the encode request body and let me [Music] run so from here it will take some time like 5 to 10 seconds because it is calling the cloud flow let me see how whether it's running this particular Cloud flow or not yeah as yo
u can see it is getting run you can see the status by clicking that particular log so as you can see there some of the steps which is already completed and it is extracting the information from the invoice in AA Builder the similar way you can use the other Cloud flow connectors to get in pass the data once uh we have the information it it will be getting back uh from Power automatic stop to Cloud flow using the variables so as you can see the status code which we returned as a 200 it is a succe
ss if you see anything like 400 or 41 43 so there is some issue which is related to the the technical code or the which is a sign in issue so that's the reason we need to use the particular user inside the tenet to get it run so let me see the particular response we received so yeah this is the extraction data we did one is the customer name and the invoice ID and the total balance so the same is added inside the one of the Excel which we stored inside the one drive yeah as you can see the previ
ously we have one line and currently the same data is getting extracted and stored inside the another row so this is the way we can able to use uh Cloud flows calling from the desktop flow thank you guys if you have any doubts please reach out to me in the comments or you can reach out to me the mail which is I mentioned in the description thank you so much
Comments