Customize Sharepoint Online Form Parent-Child Lookup field

[marcmoe]

Hello,

i have 2 Sharepoint Lists (SPO).

List Project and List Tasks

A Project can have multiple tasks, so we have a lookup column in the tasks list for project.

Now i want to customize the new/edit/dispform for the projectlist to show also the task list entries for the project.

I want to have possibility to add/edit/delete entries from the task list in the project list form. 

All in normal browser.

Is this possible with powerapp to customize the forms for Sharepoint?

Regards

Marc

[RandyHayes]

@marcmoe 

Marc, you are in the right place!  PowerApps will allow you to do all of that and much more.

In this case, your only real choice will be - make an App or customize the SharePoint forms.  Either way will provide what you need.  One is more portable and can be a bit friendlier (the App) the other will fit nicely into what you and your users already use (the customize).

Good luck and post back if you get stuck on things...plenty of folks here to lend a hand.

[marcmoe]

Hello,

thanks for your reply.

I have created a sharepoint List (custom list) projects. 

I have created list tasks. In the task list there is a "lookup" for projects.

So i have the relationship using the lookup column. 

Now i want to create a sharepoint formular (dispform and editform) with powerapps which is showing the project and also the tasks for the project (filtered on lookup field).

I have added a "gallery" and added the tasks list as datasource. But i can not figure out the correct way to filter the tasks 😞

Anybody can help, maybe has some examples?

Also there is no easy way to add some kind of tabbing out of the box?

In the real project here we have one "master list" with multiple lookup columns to sublists.

So we have to present a lot of data on the form, tab would be great.

Regards

[Anonymous]

Hello,

I have done this a few times! In your Tasks List you would have a Lookup to the Projects List. When you create the PowerApps to customize the Project Edit/Disp Form, you can bring in a Gallery of the Task Lists - you would set the items to something like

Filter(TaskList, ProjectColumn.ID = SharePointIntegration.Selected.ListItemID) 

Here's some more info on the SharePoint Integration

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/sharepoint-form-integration

[RandyHayes]

@Anonymous spot on for the example!

@marcmoe as for the Tabs...take a search through this forum, there has been that subject a few times.  There is no out-of-the-box solution for it, but it's pretty easy to implement.  Also, take a look over at Shane Young's recent video on Tabs, that might be helpful also.

[v-xida-msft · Accepted solution]

Hi @marcmoe ,

Do you want to custom a form for your Project SP list using PowerApps?

Further, do you want to display related Task list reocrds when you display a specific Project reocrd? Do you want to create three separated forms to new/edit/display project record?

If you want to create three separated forms to new/edit/display project record, please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/separate-custom-forms/

In addition, I also agree with @Anonymous 's thought almost. You could consider take a try to configure your custom form into a Tablet layout as below:

then add a Gallery control at the right within the screen as above. Set the Items property of the Gallery control to following formula:

Filter(YourTaskList, LookUpColumn.ID = SharePointIntegration.Selected.ID) 

Note: You could also consider take a try to add extra Edit forms in your app to new/edit/delete reocrds from your Task SP list.

Best regards,

[vtamas]

Hello,

Thanks for sharing this, exactely what I was looking for. However, I have an issue. I cannot figure out how to add a different (=other than the list that the form customization is connected) data source to the Gallery. I can only select the existing datasource which is in the SharePointIntegration, and I have no option the add a new data source. @marcmoe and @v-xida-msft How did you add YourTaskList as datasource to your Gallery when the form is on YourProjectList?

Any help would be appreciated.

Regards