cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vish_p
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

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
Drrickryp
Super User
Super User

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. 

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

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

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

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

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn 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.

Top Solution Authors
Top Kudoed Authors
Users online (1,173)