Second Sharepoint List in PowerApp has blank fields - "this formula uses scope which is not presently supported for evaluation"

[CliveMM]

Hi All

This is the first time I am using multiple sharepoint lists in power apps.

I set up 2 x lists in the same site in Shrepoint.  one called JobsMast and the other JobItems. I created the default App with JobsMast and got the Browse/detail & edit screen all working fine.

I then insert a new form and connect it to the second list in share point caleed JobItems, but no data come through.  The two list are not joined, at least not yet) . I have tried the Item=Defaults('JobItems')  suggestion put that did not help. The data table displays in the below the formula box. I think this message which I get quite often may be something to do with it and I would appriciate any further help or suggestions

"this formula uses scope which is not presently supported for evaluation"

I keep seeing the message "this formula uses scope which is not presently supported for evaluation"

Help!

[Pstork1]

If JobsMast is a parent to JobItems then you probably want to add a gallery for JobItems rather than a form.  Then set the View form.  Then set the Gallery's  Items property to be 

Filter(JobItems, ForeignKey = Gallery.Selected.ForeignKey)

ForeignKey is whatever field ties the two lists together logically, Like JobID if there is one.

[v-xida-msft]

Hi @CliveMM ,

Could you please share a bit more about your scenario?

Is there a relationship between the JobsMast List and the JobItems List?

Do you want the new Edit form to load data from your JobItems List?

If one record in JobsMast List only matching single one record in JobItems List, please consider take a try with the following workaround:

Set the Item property of the new Edit form to following:

LookUp('JobItems List', JobId = BrowseGallery1.Selected.ID)

If the JobId column in your JobItems column is a LookUp column, please modify above formula as below:

LookUp('JobItems List', JobId.Value = BrowseGallery1.Selected.ID)

Note: I assume that the JobId column in your JobItems List reference values from the ID column in your JobsMast.

Set the DefaultMode property of the new Edit form to following:

FormMode.Edit

Set the DataSource property of the new Edit form to your JobItems List.

Best regards,

[CliveMM]

There needs to be a link between JobsMast and JobItems, but I have not addd that at this stage.  I have added a colum to JobItems to store the jobMastID on each row. 

1. Does sharepont have the option to link up Lists?  If so I cant find anything in share point.  If there is something please let me know else I will just filter the JobItem rows on the JobMastID

And yes I want the new edit for to load records from JobItems where the JobMastID matches the JobMast.ID in the previous BrowseGallery.

[CliveMM]

Thanks Paul, If I use a Gally in Edit mode how do I post it as SubmitForm() only accepts a form not a gallery

Regards

Clive

[Pstork1 · Accepted solution]

To post changes in the child gallery you would need to use a ForAll(Patch()) statement. You can't submit a gallery of changes.  The other option is to create another screen that would edit the child record.  Then let the user select a record from the child gallery and navigate to that screen, make changes, and submit those changes when you navigate back.