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 Automate
Unanswered

Texting automation

(0) ShareShare
ReportReport
Posted on by

I'm trying to make a flow where it will open an APP which I got then open an excel file and grab data from certain columns and rows which i got and it stores the info in a excel data table and then on the app which is a texting app I want it to pull the first number and paste it on the number bar on the app and then I want it to grab the name that corresponds to the number and paste it in the texting bar with a custom message with name first then hit send and repeat the process about 500-750 times with the next name and number in the data table but i cant get it to go to the next name and number just pastes the whole data table instead 

I have the same question (0)
  • VishnuReddy1997 Profile Picture
    2,666 Super User 2026 Season 1 on at

    Hi @radsmack ,

     

    Please use For each loop action and  use CurrentItem so it will paste single value.

    Can you please share the screenshot of your flow.

     

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

     

    Thanks & Regards

    Vishnu Reddy

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    @VishnuReddy1997 is on the right track.  Beyond that, the syntax for pulling the items is a little more difficult.

     

    You typically have a title such as 'Number' and 'Name' representing each column.  When using syntax to pull from a table, you can use indexes beginning with 0, or column names if the ExcelData was captured with a column name.

     

    When you use a for each on a table variable such as ExcelData, each CurrentItem is one row of the table, so the syntax becomes a little easier to deal with.

     

    During the for each process, we can individually reference each column of the "CurrentItem" as follows:

    %CurrentItem[0]% or %CurrentItem['Number']% to pull the first column in my example

    %CurrentItem[1]% or %CurrentItem['Name']% to pull the second column in my example

     

    So your flow looks like this:

     

    Launch Excel

    Read from Excel

    Launch App

    For Each %CurrentItem% in %ExcelData%

        Populate text field with %CurrentItem[0]%

        Populate text field with %CUrrentItem[1]%

    End (for each)

     

    Good luck!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 248 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 160 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 142 Super User 2026 Season 2

Last 30 days Overall leaderboard