web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Web form filling from ...
Power Automate
Answered

Web form filling from excel truncating data

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Guys,

I need help with a flow doing a dynamic web form filling from excel, it will sometimes truncate the data it captures in the fields erratically, please advise what the problem could be. I am using power automate desktop Populate text field on web page

 

I have the same question (0)
  • Riyaz_riz11 Profile Picture
    4,204 Super User 2026 Season 1 on at

    Hi @Davido3 ,

     

    Try to use truncate number action before using Populate that truncate variable you can use inside populate, else if you required for some other criteria also like if or switch condition.

     


    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    Regards,
    Riyaz

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Can you please provide some screenshots of your flow, as well as the page you are trying to populate? Maybe some examples of what happens?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Davido3_0-1704369340293.png

    Davido3_2-1704369499859.png

     

    above is the flow and the populated page, you can see not all characters are captured in fields such as email, address and company name are truncated. sometimes it will get everything sometimes not, there seems to be no pattern

  • CU31080729-3 Profile Picture
    502 Moderator on at

    Hi,

    if you want to automating RPA challenge website in which field are dynamic change every time then you can try this you tube video

    https://www.youtube.com/watch?v=JbXunbF_Nbo

     

    (Note:- if you got your solution you can mark as solution and gives kudos)

     

    Thanks & Regards

    Chetan Ninghot

  • Simona9 Profile Picture
    7 on at

    Hello, I have the same issue. I've used same flow for a few months and after computer update it started truncating numbers. 

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Davido3_0-1704441470198.png

    Hi @Simona9 , try changing the advanced settings as above, it seems to have worked for me, I hope it's a permant solution for both of us.

     

    Let me if it works and a Kudos would be greatly appreciated.

     

     

  • Simona9 Profile Picture
    7 on at

    It worked! Thank you so much!

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 481

#2
11manish Profile Picture

11manish 278

#3
David_MA Profile Picture

David_MA 276 Super User 2026 Season 1

Last 30 days Overall leaderboard