Skip to main content

Notifications

Community site session details

Community site session details

Session Id : QaUlD0yqIIp93NFfArVmgU
Power Automate - Power Automate Desktop
Unanswered

Tutorials - Data Entry from one web based CRM to Another Using RPA in Power Automate

Like (0) ShareShare
ReportReport
Posted on 5 Oct 2022 08:53:32 by 34

Hi 

I'm very much a beginner learning how to build RPA robots within Power Automate. I am looking for a way to automate data entry copying data fields from one web based CRM (Hubspot) to another legacy web based CRM that has no API. 

 

I've searched for tutorial videos on how to do this but can only seem to find tutorials that show me how to move data from Excel sheets or SharePoint lists into a web based application. Rather from 1 application to another, scraping data fields that are on screen and inputting them into another CRM. Ideally, also looking for an attended RPA tutorial that will show me how to initiate inputs from users where there are decision points etc.

 

Could anyone point me in the direction of some tutorial videos to show me how to do this? 

Thanks

  • MichaelAnnis Profile Picture
    5,721 Super User 2025 Season 1 on 05 Oct 2022 at 14:49:46
    Re: Tutorials - Data Entry from one web based CRM to Another Using RPA in Power Automate

    In my experience, I prefer to run reports out of my existing system (in this case HubSpot) and get them into Excel.  I've never used HubSpot but I would be surprised if you can't get the data you want into Excel.  So, use RPA to run the report and open Excel.

     

    Now that you have all the data in Excel, you have all the information you need.  If the legacy CRM has import capabilities (say from csv), then manipulate the data in Excel and import it into the legacy CRM.  If not, just have RPA use the UIs and enter the information one row at a time, looping on the Excel Data.

     

    If you need an input from the user at certain points there is a Message Box, where you can tell them what to do, or there is an InputBox where you can ask for a specific value or entry.  I use a message box when I need human interaction.  It may be a link I can get to via UI or something, so the message box appears and says "click All, then click OK here" so the flow pauses until they click OK.  For the InputBox, I had prices that had to be gotten from 7 different sites, so the flow went to the website and put in the dates and everything, but rather than spend hours trying to get the price from the html code of each website, I decided to just have the user look for it real quick and input it in.

     

    Best of luck!

  • Nived_Nambiar Profile Picture
    17,554 Super User 2025 Season 1 on 05 Oct 2022 at 10:04:13
    Re: Tutorials - Data Entry from one web based CRM to Another Using RPA in Power Automate

    Hi @AlanStevens 

     

    You can achive the same via using UIAUTOMATION [Browser Automation] using Power Automate Desktop

     

    You have to do like below: 

     

    1. Use the Extract details from webpage to extract text from crm (hubspot) fields 

    Nived_Nambiar_0-1664964145343.png

     

     

    2. Then enter the extracted details to another CRM using the Populate Text to webpage

     

    Nived_Nambiar_1-1664964192757.png

     

     

    You can use all browser related actions for your purposes.

     

    This way it is possible

     

    Mark it as solution if this helps you 

     

    Thanks & Regards,

    Nived N

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 11 Super User 2025 Season 1

#2
KO-05050229-0 Profile Picture

KO-05050229-0 4

#2
Brad Darragh Profile Picture

Brad Darragh 4

Overall leaderboard
Loading started