I cant find answer to my problem, it was similiar questions, but not this one.
I want to build automatic flow, when new form is submitted to send email to members in same row.
now, it sends all the rows as emails, I want only the last one. not all of them which are previously send.
I don't know could flow write in specific colum something like "sent", and sends only rows without "sent", or just last row?
also i think that the flow maybe doesn't see the last row because it create a flow immediately after flow is being submitted and row in excel doesn't have data jet.
I am using office 365 for business
any help please.
@Karlo you are using the Forms When an new response is submitted trigger but you're not saving that to your spreadsheet which you need to do. Also, you are sending an email to every row in the spreadsheet: apply to each value -> send an email. What you need to do is to have a column in your spreadsheet for EmailSent and in your flow add a condition that if the EmailSent column is equal to No then send the email, but if it's equal to Yes then do nothing.
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
I see what you mean. tnx
but as I am new in this, could you please help me and explain how to set flow to write in specific column like "sent" for sent emails, and read after when sending not to send from that columns with "Sent".
I also add delay of 1 minute to wait before sending, as spreadsheet is not populated yet with form.