cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RKnighton88
Level: Powered On

Combine Lists in PowerApps/ SharePoint, but keeping them separate.

Hi,

Is there anyway I can combine two lists/tables in to the one. Please see attached image for a better explanation. 

I want to combine the data from 'Health Questionnaire' and 'Information Sheet' into one table but keeping the individual lists on SharePoint. Is there a flow I can create or anything like that? It's kind of a PowerApps/SharePoint Question. 

 

Thanks in advance. 

4 REPLIES 4
Super User
Super User

Re: Combine Lists in PowerApps/ SharePoint, but keeping them separate.

You could certainly do it in Flow.  I'm presuming there is a 1-to-1 correspondence between these two lists based on your description.  You could do a GetItems on the Health Information and then do an apply to each which does a GetItems on the Information Sheet with an ODATA filter looking for the matching record for the individual.  Once found then you could do a CreateItem to a new list which writes out the combined data you want from both lists.  Your original lists would remain unaltered.

 

I hope this helps point you in one possible direction

Community Support Team
Community Support Team

Re: Combine Lists in PowerApps/ SharePoint, but keeping them separate.

Hi @RKnighton88 

 

Could you please share more details of your situation?

Do you want to combine two different tables in PowerApps?

Could you please reference this?

https://powerusers.microsoft.com/t5/General-Discussion/Can-I-add-fields-from-multiple-data-sources-i...

 

https://powerusers.microsoft.com/t5/General-Discussion/Syntax-for-joining-tables/td-p/61387

 

More information:

function-table-shaping

 

Best Regards.

Yumia

RKnighton88
Level: Powered On

Re: Combine Lists in PowerApps/ SharePoint, but keeping them separate.

Hi @v-yuxima-msft 

 

Thank you for your response, most helpful. 

So as mentioned, I will try and explain it a little better. 

What I am trying to do is combine the two tables in SharePoint/PowerApps as per the image.

The two tables you can see on the image I want to combine, I am creating this application for a company and I was wanting to streamline the app. 

One table has information regarding health questions and the other is relating to training.

On my app the user has to carry out the following:

 

- App loads 

- Directed to a camera screen 

- Takes photo 

- Then navigates to a 'Training Information' screen

- Submits information, saves to SharePoint

- Then navigates to a 'Health Questionnaire' screen 

- Submits information, saves to SharePoint

 

The data for both tables are stored on two seperate SharePoint locations. Once I have created the final version of the Application it will need to go to the client, for ease of access and data collection I am trying to combine the two tables as mentioned.

I hope thats a little more helpful. 

RKnighton88
Level: Powered On

Re: Combine Lists in PowerApps/ SharePoint, but keeping them separate.

Hi @LRVinNC 

 

That sounds like it would work. Sorry for the late reply. I will give that a  go and let you know of the outcome. 

 

Thank You. 

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,984)