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 / Use make an massive op...
Power Automate
Answered

Use make an massive operation to data of excel

(0) ShareShare
ReportReport
Posted on by 44

Hello there!
I need to multiply a parameter to a data from excel, but PAD said that can't applied to text.
all the extract data are numerics.

 

Celaque_0-1701469442542.png

 

Celaque_0-1701470285172.png

 

 

  • Verified answer
    UshaJyothiKasibhotla Profile Picture
    225 Moderator on at

    Since the value of your input are of text type it does not support * operation

    use convert text to number activity and convert 2 variables in to numbers which you want to multiply

    you need to use for each to loop through the excel the sample flow i have created is in below

    for reference please see below image

    UshaJyothi20_0-1701493394576.png

    UshaJyothi20_1-1701494270160.png

    Try like this

    Hope this helps

    Usha

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Since you are reading a range from Excel, %ExcelData% is not even a text value - it actually is a data table, with multiple values. You cannot multiply a table. You need to process each value individually, by either reading every cell separately, or reading the table, and then building a loop to iterate through the values and convert them to number individually.

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

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 273 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 235

#3
David_MA Profile Picture

David_MA 172 Super User 2026 Season 2

Last 30 days Overall leaderboard