cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JMebis
Frequent Visitor

Connection Excel with Power Apps and Power Automate

I have created an Power App that is connected to an Excel table. the data of the table was visible in the app.

But I also want to connect the spreadsheet with Power Automate to add data to the table. But after making that connection, the data was lost in the power app.

Is this not possible?

4 REPLIES 4
v-xiaochen-msft
Community Support
Community Support

Hi @JMebis ,

 

If you want to read data in excel table in powerapps and write data to it, I suggest you put excel into onedrive for business and use the connector in canvas.

At this point, you will no longer need power automate.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

JMebis
Frequent Visitor

Hi

 

Thank you for your reply. I'm currently using onedrive for business.
The new data (new rows) are coming from another Excel document and should be added automatically.

How can this be done without Power Automate?

v-xiaochen-msft
Community Support
Community Support

Hi @JMebis ,

 

If you want excel table B to automatically update data when there is data input in excel table A, then I suggest you use automated flow.

So far, I don’t know what your specific needs are and what you have done.

If you want to get further help please provide more information.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

JMebis
Frequent Visitor

Hi

With one Excel file: 

I'm using Power App for visualizing the data.
I'm using Automated flow for adding data (new rows) automated. 

But, when I connect the Excel file with Power App and Automated flow. The connection with Power App is lost. 

The data isn't visuel any more in the app.  

Can I connect one and the same Excel file with Power App and Automated Flow?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,083)