cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RKnighton88
Advocate II
Advocate II

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

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

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
v-yuxima-msft
Community Support
Community Support

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

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. 

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

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.

Users online (1,547)