cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

PowerApp cannot write to Excel file with data

Hello,

 

I have an app published inside a Power BI service report.

When I try to submit a form, I get the error:

image.png

It seems that it isn't capable of writing to the Excel file that stores the data of this app.

However, that file is in my OneDrive for business shared with anyone with the link.

 

Can anyone help?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper V
Helper V

Re: PowerApp cannot write to Excel file with data

Hello @v-siky-msft 

 

The app was shared, but it turned out the Excel share was not allowing edition 🙂

 

Thanks for helping! 

 

 

 

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: PowerApp cannot write to Excel file with data

Hi @WebPortal ,

 

Have you shared the App with the users of report? Not only data source, but also App need to be shared with users.

Note: You can only share the app with users in the same organization.

 

Also please ensure that "Allow editing" permission of Excel is also shared with users.

Annotation 2019-09-26 163529.png

Best regards,

Sik

Highlighted
Helper V
Helper V

Re: PowerApp cannot write to Excel file with data

Hello @v-siky-msft 

 

The app was shared, but it turned out the Excel share was not allowing edition 🙂

 

Thanks for helping! 

 

 

 

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (5,915)