Merging a collection with SP list

(0) Share

Report

Posted on by JimJim

289

Hi Guys,

I have a challenge that is a bit beyond my capabilities, firstly, let me explain what I have built so far:

I have an app that allows users to submit approval requests. Each request can have one or many items associated with it. In order to utilise a repeating table I have a gallery in my form with a collection as source. Once the user submits the form, the OnSuccess property of the form calls a patch function to write the collection contents to a SP list.

The challenge I have is the user may recall requests to the app to edit them, this also includes editing the items associated with each request, they may edit existing items, delete items and add new items.

What I need to be able to do is sync the data between my collection and SP list. I need to be able to do 3 things:

1. Add new items to my SP list (where exists in collection but not my list)

2. Remove items from my SP list (where exists in list but not collection)

3. Update items in my SP list (where exists in both collection and SP list)

I really don't know where to start with this.

Any help would be greatly appreciated 😊

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JimJim

Of you are using a single list that contains a one to many relationship between requests and items, then your design is flawed and you will have problems. You will need at least 2 tables to accomplish your goal.

Was this reply helpful? Yes No
JimJim 289 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp
I have 2 table, one master and one for the items. The ID from Master is being written into the items table to allow me to join them up

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JimJim

I don't have any idea what your app looks like but it seems to follow something like this one.

The parent table is on the left, The details of that order are in the upper right and the Child table (The product items of the order are in the lower right. In this design, a new order can be entered and then the products ordered are submitted using a patch for the product. No collections are necessary to execute the necessary functions for the two tables. I'm not saying your design is incorrect but my preference is to avoid using collections unless there isn't another way to manage the data.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JimJim

I don't have any idea what your app looks like but it seems to follow something like this one.

The parent table is on the left, The details of that order are in the upper right and the Child table (The product items of the order are in the lower right. In this design, a new order can be entered and then the products ordered are submitted using a patch for the product. No collections are necessary to execute the necessary functions for the two tables. I'm not saying your design is incorrect but my preference is to avoid using collections unless there isn't another way to manage the data.

Was this reply helpful? Yes No
JimJim 289 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp , Thanks for replying. I decided to use a collection so that all updates could be made at the same time. I think I'm too far down that path to change it now

Was this reply helpful? Yes No