Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Flow help needed from Form > List Rows Table > Array by filter > Smartsheet Insert Row

(0) ShareShare
ReportReport
Posted on by 17

Hello PA forum,

 

I'm getting stuck on this at the filter and array step specifically..

 

I have been able to pull all quiz results into a Create file, successfully

then pull those records from List Rows action, successfully

 

What I want to do next is :

1. build an array off of the outputs of List Rows ... that will work w/Smartsheet Insert Row 

2. Use the filtering to ONLY those use the rows in the file submitted in the last day/24 hours comparing against Completion Time (I don't know how to do this given how output data doesn't look like the data in the Excel row for the utc expression)

3. then in a loop feed those rows - one at a time Apply to Each? - into a smartsheet using Insert Row action

4. optionally I might like to convert Total Points from string to integer before pushing the row to Smartsheet

 

any help is appreciated, here's the general steps

 

jshannon_0-1676311099428.png

 

Here is what the Create File / Excel looks like for the List Rows action

jshannon_1-1676313969897.png

 

thanks,

jen

  • Verified answer
    jshannon Profile Picture
    17 on at
    Re: Flow help needed from Form > List Rows Table > Array by filter > Smartsheet Insert Row

    The following solution works

    This flow get MS Forms Quiz Total Points, places them in a file, then Filters all the responses in that file by Today's date (see Filter Array)

    Today's quiz scores are then inserted into a sheet in Smartsheet using an Apply to Each, mapping the sheet fields to the array fields

     

    *Total Points will go into Smartsheet as a string, to solve for integer

    Open your Smartsheet and create a Helper column and use the following function to convert to integer, =VALUE([Total points]@row)

     

    Solution is largely based on the guidance from the following tutorial at  

    https://www.youtube.com/watch?v=4eWGdi_C2hQ

     

     

    jshannon_1-1676408260538.png

    jshannon_2-1676408333946.png

    jshannon_3-1676408401725.png

     

    jshannon_4-1676408427149.png

     

    Here is the Smartsheet w/the helper column

    jshannon_5-1676409051946.png

     

  • David_MA Profile Picture
    11,767 Super User 2025 Season 1 on at
    Re: Flow help needed from Form > List Rows Table > Array by filter > Smartsheet Insert Row

    In that case, I cannot help you. I have very limited experience with the HTTP requests action.

  • jshannon Profile Picture
    17 on at
    Re: Flow help needed from Form > List Rows Table > Array by filter > Smartsheet Insert Row

    @David_MA 

    It's not a Get Items...  it's a Send an HTTP request to Sharepoint b/c what I have to do with this flow is pull the entire list of responses from Excel b/c the Total points is already calculated at that point for each response... we can't calculate these on the fly w/a Get Response Details action b/c the questions will always be changing..

    So, I reference the form's ID > then GET all the responses via the Send an HTTP > which allows the create File > which establishes the List Rows Present in a Table > from here I want to filter just those rows from last 24 hours into an array to feed thru an Apply to Each/Insert Row step

     

    So, can I Filter within the List Rows action or do I need to add a Filter Array function after List Rows?

    also can you send the code view of the two expressions?, I'm really new to this and not tracking how to join those two expressions you showed

     

    jshannon_0-1676387788277.png

    jshannon_1-1676388072324.png

     

  • David_MA Profile Picture
    11,767 Super User 2025 Season 1 on at
    Re: Flow help needed from Form > List Rows Table > Array by filter > Smartsheet Insert Row

    I can help you with getting items from the past 24 hours; that's pretty simple. I assume you renamed the action Get items to Get form responses. If so, you can use a filter query to limit items created in the past 24 hours. 

    David_MA_0-1676317198297.png

    The first expression is:

     

    addHours(utcNow(),-24)

     

    And the second expression is:

     

    utcNow()

    Replace "Created" in the filter query with the internal name of your Completion time field. Note, internal names do not contain any spaces. If you don't know how to get the internal name, open your list settings, click on the field and it will be shown at the end of the URL.

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1