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
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
In that case, I cannot help you. I have very limited experience with the HTTP requests action.
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
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.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1