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

Navigation error : Invalid datasource

I am facing an issue i.e. i used to navigate users to a "Detailscreen" wherein the details of the item selected by the user on the Datatable is used to displayed i.e. the formula in "Onselect" property of Datatable was :

Navigate(detailscreen,Fade) 

and the "Items" property of that particular details form was :

Datatable1.Selected

this used to work earlier,now after applying following formula (in "Items" propery of Datatable1) : 

AddColumns(Filter(POlistitems,Author.Email = User().Email),"Application Status",Status.Value)

 whenever i try Datatable.Selected i am getting an error : "Invalid Formula Expected a value Compatible with Datasource" And the datasource for my Detailscreen Form is "POlistitems"(i.e. the cllection of 2 sharepointlists)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Navigation error : Invalid datasource

Hi @vish_p,

You will find that you cannot save to a collection from an Edit form.  Also, a single form can only write to one datasource at a time.  If you are creating a collection and making changes to it, it only exists in memory until you save the changes back to the original datasources. If you leave PowerApps, the collection and any changes you make to it will disappear.  

To make any permanent changes, you have to save your data back to the original datasources you used to create the collection.  If there are two datasources, you can either use two Edit forms or use the Patch() function twice to do this. Also If your two datasources are a One to many type relationship, you will not be able to save the Many side of the relationship until you create the One side. 

View solution in original post

6 REPLIES 6
Highlighted
Super User III
Super User III

Re: Navigation error : Invalid datasource

You need to make the item property of the form match the datasource
Lookup(POlistitems,ID=Datatable1.Selected.ID)
Since the datasource of the gallery no longer matches the datasource of the form, you must be more specific. 

Highlighted
Helper V
Helper V

Re: Navigation error : Invalid datasource

I tried this,but is not working,please tell me how to mactch the datasources on both places

Highlighted
Super User III
Super User III

Re: Navigation error : Invalid datasource

The datasource of the form has to be an actual list not a collection.

Helper V
Helper V

Re: Navigation error : Invalid datasource

i need to collect data from 2 lists actually,without that the app wont acheive its objective.Any workaround may be ?

Highlighted
Super User III
Super User III

Re: Navigation error : Invalid datasource

Hi @vish_p,

You will find that you cannot save to a collection from an Edit form.  Also, a single form can only write to one datasource at a time.  If you are creating a collection and making changes to it, it only exists in memory until you save the changes back to the original datasources. If you leave PowerApps, the collection and any changes you make to it will disappear.  

To make any permanent changes, you have to save your data back to the original datasources you used to create the collection.  If there are two datasources, you can either use two Edit forms or use the Patch() function twice to do this. Also If your two datasources are a One to many type relationship, you will not be able to save the Many side of the relationship until you create the One side. 

View solution in original post

Highlighted
Post Patron
Post Patron

Re: Navigation error : Invalid datasource

Oh my gosh!!!  This has been a lifesaver for me!  Thanks so much! 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

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