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

Sharepoint + Repeated tables

Hi, 

 

I want to make a PowerApp and I'm having trouble on how to do it. 

 

So what I need is a view form of a couple of items from a SharePoint list, no edit here I can pull the data from a already present and populated SharePoint list. 

 

[ item title - searchable]   [code]  [date created] 

 

Under this information, I would need a repeated table section with a + to add new rows.

 

[Name]   [Cost]  +

[Name1] [Cost1] + (etc)

 

What I'm having trouble with is that the new rows from the repeated table section, after saving, should go to another SharePoint list as individual list items (every new row a new item), but all having also info taken from [ item title]   [code]  [date created].


Any ideas? 

5 REPLIES 5
BCLS776
Super User
Super User

From your description, I picture an app with two forms: a View form that displays information from the first Sharepoint list, and a second New/Edit form that allows you to create or edit records in a second Sharepoint list. You can use functionality within Power Apps to pull specific pieces of info from the first list to include as part of the record in the second list. 

 

Is that what you are after?

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Yes, exactly 

indhaa
Impactful Individual
Impactful Individual

Hi

 

Just have a look at this video on how to create a repeating table on SharePoint so you will get some idea

https://www.youtube.com/watch?v=xgznk4XlPCo

 

 

 

 

 

hey @BCLS776 , any idea on how to do this?

BCLS776
Super User
Super User

Yes, check out this reference on working with form controls in Power Apps to start.

When you're building your app, put a Display form on one page and connect it to the SP list you want to read-only from.

 

Then, put an Edit form on another page and connect it to the SP list you want to write records to.

Next, add the fields to the Edit form that you want to work with. At the minimum, you will need any required fields for your SP list. Now, edit the Default property of any card on your form so that it references a control from the Display form that contains the data you want to capture on the Edit form.

 

That's a high-level description anyways. Check out the reference provided earlier and do some searches on here related to Edit forms for more ideas. If you're stuck, ask another question in the community.

Hope that helps!

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

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.

Top Solution Authors
Top Kudoed Authors
Users online (2,001)