cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Help: Excel Online row data entry triggers flow to send email including row data.

Hello,

 

I have built a form using Forms for Excel and need some help with what seems to be a somewhat complicated flow design.

 

I need to make a flow that accomplishes the following:

 

When a column in an Excel Online (Business) spreadsheet has data entered into it, I need flow to take all the data in that row that is not blank (if a cell is blank in the row, then the corresponding column is not relevant) and create an email that includes the data in the row that was updated.

 

Can this be done? If so, how?

 

Thank you a million.

1 REPLY 1
v-xida-msft
Community Support
Community Support

Hi @Anonymous,

 

Do you want to fire your flow when a column in your Excel Online (Business) spreadsheet is filled with data?

 

There are no triggers are supported in Excel Online (Business) connector currently in Microsoft Flow. In addition, there is no way to check if there is a column in an Excel Online (Business) spreadsheet is filled with data in Microsoft Flow currently.

 

I afraid that there is no way to achieve your needs in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

More details about Excel Online (Business) connector, please check the following formula:

Excel Online (Business) connector

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (3,692)