I have a flow the occurs once a day based on who applied to my form (which transports to an excel sheet). I want the flow to only grab new submissions and send the new submissions the emails, however, everyone on the list is sent the emails. I wanted to set a condition where the at first __PowerAppsId__ is blank, could be the condition, but it does not show up in the dynamic portion.
Mainly looking how to only run flow on the responses that has not been run on already.
Could you please share a screenshot of your flow’s configuration?
The _PowerAppsId_ column would be populated with a unique ID automatically when a record is added into the Excel file, so I don’t think “_PowerAppsId_ is blank” could be used as a Condition.
I afraid that there is no way to grab new record of Excel file in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
Thanks for replying! This is my Flow. I did read that there is not a way to grab rows whenever there is a new submission. Do you have a recommendation on how to set a condition so that only new rows get the next part of the flows. I tried to write an equation inside of my excel sheet so that I can use that as the condition but then an error runs at the "get rows-excel" portion. My main concern is that the same people will get the email again.
Can you add a new column to your excel (let's call it "EmailSent"), so whenever you create a new excel row you leave it empty?
Your flow should send email notifications to all rows with this column with this column value empty, once email notification is sent you can "Update Row" (https://docs.microsoft.com/es-es/connectors/excel/#Update_row) and change the column value to YES.
If you cannot modify Escel table structure, maybe you can store each row "EmailSent" related status info together with row _PowerAppsId_ in an independent data source you create for such purpose
Hope this helps
Hi, thank you for replying. I just tried what you suggested and it got past the 'get-rows' and 'condition problem', however, the 'update row' is running an error now. Would I just put "YES" in the change value for "EmailSent"?
I think that was the problem, I had the excel document open in another tab. Now the condition went through, however the following steps are not being used on the emails that qualify for the condition that I had set up.
Thank you so much for your help!
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!