Showing 2 lists in one view

[Kamozzi]

Hi I am working on a risk register app that  will have a risk area which can have multiple actions. Actions will be saved separately than risk. So risk will go to one list and actions to another. 

how can a combine both the lists (show them on a screen) and connect them together so when the actions are completed, risk owner can update the risk accordingly. 

please advise? Happy to add screenshots if needed. 

[MayankP]

what is relationship between risk area and actions? is risk area is parent and if this is for model driven app, may you can configure nested grid like this https://d365goddess.com/nested-grids-in-dynamics-365/

[rampprakash]

Hello @Kamozzi,

As said by @MayankP, if you have relationship available you can show the Related Table Value in the View.

1. Navigate to https://make.powerapps.com

2. Click Dataverse --> Select Table --> Select View 

3. Click + to Add View in Select Columns and Select Related Record Values

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[Kamozzi]

Sorry for the late reply. There are 2 lists in SharePoint and I’m working on a canvas app. 

[rampprakash]

Hello @Kamozzi 

As per my knowledge, it is not possible to show as a View, but we can show as a Filed in Form.

Eg

if we are having form, we can directly show one View and Based on Another Relationship with the Another list, we can populate data over there.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com