Trying to get my flow to kick out and e-mail when an "n" is in the column 'processed'

[bcameron70]

Hey there, I have an excel form that people use to get online estimates all the online estimates populate to a subsequent table and add a "n" to a "processed" column by default.

Every hour I would like to set a flow to

->check the table for the 'processed' colum for 'N' if it finds one or more then-> create an e-mail from the table data (i see how to creat the e-mail) -> after e-mail is sent out replace that 'N' in that corresponding 'processed' column's row with a Y so that same record (row) will not process on the next hour.  If there are multiple records that had been entered online (with multiple N's to be processed) the flow should complete them all.

I have CHAT GPT'd the heck out of this, but cant quite get the flow to work.

What have I tried?

Reoccurance-> List rows present in a table (filter queery Processed eq 'n')->Apply to each (not sure what the output value should be, it autoinserted dynamic 'VALUE' in the "select an output from the previous steps" and nested another Apply to each2 with Dynamic 'Value" )->Send an e-mail-> Update a row (Key Column 'processed' Key Value 'Y')

[creativeopinion]

Because you are just building out the flow, you need to use a manual trigger. This will speed up your building/testing process. You can replace the manual trigger with a recurrence trigger once you've built and fully tested your flow.

I would not recommend trying to build out the entire flow. You need to build it in parts and test while you add more to your flow to see if you've missed anything. This is what your first portion of your flow should look like. 

List rows present in table 

You indicated in your original post you want to check for an 'n', but then went on to reference it as an 'N'. It's important that the string you enter in the Filter Query field is exact. Can you confirm if it's a lower case or upper case 'n' that is entered in your spreadsheet?

Compose - Count Items

Tip: Rename your actions to keep your flow organized.

Add a Compose action with an expression. Make sure you've selected the Expression tab. Type in length() into the expression field.

Next, click the Dynamic content tab. Make sure your cursor is in between the parentheses. Then click on the value dynamic content to insert that in between the parentheses.

Your expression will look something like this. Press Update to insert it into the Compose action.

Run a test. 

Check the Compose action outputs. It should display a number. This number will be how many rows matched your filter query. 

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

[bcameron70]

Hey there, I tried the new flow, and my inputs are matching my outputs in the compose field, although my Processed header only has 3 N's, thoughts?

[creativeopinion]

That's interesting. Any chance there are hidden rows in your table?

[bcameron70 · Accepted solution]

I did not hide any rows (on purpose at least).  My original issue of the N's not reporting properly was from not waiting long enough to do the changes on the sheet (to N) and running the test.  I was able to get it to finally sense them and now finally change them to processed.  So your original suggestion did not help, I was not being patient enough in between the changes and the test runs.