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

(0) Share

Report

Posted on by jshannon

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

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

thanks,

jen

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report
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.
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.

Was this reply helpful? Yes No
jshannon 17 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

jshannon 17 on at

Like (0)

Report

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

Here is the Smartsheet w/the helper column

Was this reply helpful? Yes No