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

Unable to create app from sharepoint list

When I create an app from a sharepoint list, the default app begins with this error:

 

The requested operation is invalid.

Server Response: The expression "*,Title,NewColumn1,Assigned_x0020_rates/Title,Status,Status_x0020_note,Executed,Expiration,Contract_x0020...

Name,Editor/Name,Assigned_x0020_rates/Rate Abbreviation" is

not valid.

 

I noticed that it will "deselect" my data source. Reselecting the data source will cause the error to briefly go away, then it comes right back.

 

I would like to know how to resolve the error so that I can work with my data.

 

I am relatively new to powerapps, so I appreciate any help and direction you can give me.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
JoshBrown
Frequent Visitor

Re: Unable to create app from sharepoint list

I resolved my issue by re-creating the list.

 

I am not sure what caused the problem, but it's fixed now. Thanks for the help!

View solution in original post

6 REPLIES 6
Tech08 Advocate V
Advocate V

Re: Unable to create app from sharepoint list

To me it sounds like an error with rights to the data.  When I shared my app to others, they would get an error similar when they tried opening the app, but didn't have rights to the data source.  I'm still new to Powerapps and learning as well.  Hopefully this helps.

Community Support
Community Support

Re: Unable to create app from sharepoint list

Hi @JoshBrown,

 

Could you please share more information about the SharePoint list, is it a custom list?

Currently PowerApps only supports to generate App from the SharePoint custom List, other list types may not work as expected.

Further, there are some known issues when working with SharePoint list in PowerApps, check the following article for more details:

Connect from Microsoft PowerApps to SharePoint

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AvenaFernando Helper II
Helper II

Re: Unable to create app from sharepoint list

Report which function you used and which generates this error.

 

Explain your problem better

Highlighted
JoshBrown
Frequent Visitor

Re: Unable to create app from sharepoint list

As stated I am new to powerapps. This is using the default app. I am not sure what function generates the error because all I did was click "new app from data" and navigated to my sharepoint list, selecting it as my data source.

 

Is there a way to view and edit the underlying query in power apps? If so, how? I have not been able to find a way to do this.

 

Thanks

Community Support
Community Support

Re: Unable to create app from sharepoint list

Hi @JoshBrown,

 

Please follow the article below to modify the query with the items property of the Gallery:

Customize a gallery layout in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JoshBrown
Frequent Visitor

Re: Unable to create app from sharepoint list

I resolved my issue by re-creating the list.

 

I am not sure what caused the problem, but it's fixed now. Thanks for the help!

View solution in original post

Helpful resources

Announcements
secondImage

Community User Group Member Badges

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

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,292)