share point list with Power app

[Berihun1]

In share point and power app how to create a List that will contain the below table information?

[v-qiaqi-msft · Accepted solution]

Hi @Berihun1,

Clearly, we could not create a SP list as described in your screeshot.

As a workaround, if you could accept a similar format in a Gallery, we could try something different.

First of all, you should have a SP list like below:

FullName	Sex	Age	Item	Quantity
XXX	F	23	X	3
XXX	F	23	Y	1
XXX	F	23	Z	4
YYY	M	45	A	4
YYY	M	45	D	1
YYY	M	45	S	65

Then in a Gallery, set the Items property as below:

GroupBy(ColList,"FullName","NameG")//ColList is my data source

Then set the Text property of each Label as below:

ThisItem.FullName
Concat(Distinct(ThisItem.NameG,Sex),Result,"")
Concat(Distinct(ThisItem.NameG,Age),Result,"")
Concat(ThisItem.NameG.Item,Item,Char(10)&"")
Concat(ThisItem.NameG.Quantity,Quantity,Char(10)&"")

[SebS]

@Berihun1 

To achieve this, You need two tables related to the One-To-Many relationships. SharePoint is not Relationship Database means You need to Create two Lists and relate them using power apps.

You do not have an employee number means you need to relate them by SharePoint ID FullName may not be Unique enough.

Create a List called Employee With FullName, Sex, and Age column, Single Text, Single Text and Number

now. Create another List called Clothes or PPE. I'm assuming it has something to do with ordering clothes.

In that table, Title Column can play as ForenKay, which will relate both lists.

It will look like this Title FK, Item, Quantity.

In power apps, You will create two forms one to add new employees and set them up in the system and one for ordering Clothes.

The Employee form will be straightforward the Order Form will be more complex. You will need to change the textInput of Title to a dropdown and create Items feed directly from List Employee, picking FullName. but in the update, You will use ID to update to that column.

That will allow You to order one Item at a Time to order many Items for one person complicating things more. You will need to know how to add Items to a collection and then Patch them all in one go to provide an experience like they have a Shopping Cart.

This Blog can help You to understand one of methods you could use

https://www.matthewdevaney.com/build-a-shopping-cart-in-power-apps/