cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Berihun1
Frequent Visitor

share point list with Power app

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

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)&"")

vqiaqimsft_2-1670403755899.png

 

 

Best Regards,
Qi

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

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)&"")

vqiaqimsft_2-1670403755899.png

 

 

Best Regards,
Qi
SebS
Memorable Member
Memorable Member

@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/

 

 


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,582)