Was wondering if anyone has tried to do this. Trying to create a flow that looks like this:
When a sheet is updated > "Pending" is in the sheet (in a cell) > Generate Approval
I can obviously choose the sheet, but not sure where to go next. Tried adding a condition but really unsure on the format of expression thats needed, or where to even put it.
I can also add in "get columns" as another action after the first trigger, but then I can't seem to do anything with those columns other than write conditions based around the actual column cell, like it's name, unique ID etc.
Wanted to use Smartsheet because of it's forms and data collection and how dynamic it is.
Thanks for any help, I'm really new to Flow, and actually new to expressions and formula anyway, just not sure if what I want to do is possible right now!
Hi @trand86 ,
Do you want to check if the value of a specific cell is “Pending” then start an approval email?
I have made some test, however it seems that we could not get the value of a specific column or cell directly.
Please add a request at the Flow Ideas Forum about this issue:
Hi @v-yamao-msft thanks for replying!
That's correct, even if "pending" is anywhere in the sheet if I limit it to one entry at a time.
So I next tried to copy the data over to Excel (via OneDrive Business). My thinking was this:
When a new row is added to Smartsheet > Copy new row to Excel
I may be able to then get something in place to kick off Approvals. The problem is, when the columns and data is retrieved from Smartsheet, Flow seems to copy the new row to Excel but with each row on it's own column. I can't seem to stop this from happening, so maybe I'm not setting the flow up correctly.
Hi @trand86 ,
Thanks for updating.
The issue could be reproduced by me when working with trigger When a new row is added to Smartsheet.
As you mentioned, flow will copy the new row to Excel with each row on its own column. A screen shot likes below:
I will help confirm this issue and back to you later.
Thank you for confirming this issue Mabel.
So far I can't seem to find a work around. There are a few actions associated with the trigger "when a row is updated" in Smartsheet, such as "get columns" which then allows you to "get row cell data" but these actions don't produce usable results, at least for me.
I did try some odd things such as putting the cell data into a table as I thought maybe I could then pull that data but that doesn't work either.
Any suggestions you have from here would be great!
Hi again @v-yamao-msft
I wonder if this has something to do with the "apply to each" that auto inserts when I select ranges to import into an excel table from Smartsheet?
There's no way to get rid of the "apply to each" but I think it's grabbing the columns of a Smartsheet, and applying the action of "cell display data" to EACH column, treating it as is. Therefore, the column data that gets inserted into Excel goes in for each row. Like instead of column data being inserted into one row, each column BECOMES it's own row.
What do you think?
HI @trand86 ,
Could you provide the flow definition, and raw inputs/outputs for the Smartsheet and Excel Online business actions?
So I've stopped with Excel, and managed to make a flow work using Excel only.
I'm now looking at Smartsheet again, maybe you could help with this:
When a sheet is updated > Get a sheet > get the columns of a sheet.
The output from that gives the dynamic content "A Smartsheet Sheet with Rows" which has all column AND all row data in it.
How would I use workflow definition language to pull row data from that output into variables? I just want to be able to display a particular column and its display cell data, which exists in the output from "A smartsheet sheet with Rows".
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.