Power Platform Community Forum Thread Details

Hi.

I have a 2 SharePoint lists.

List A

I need an Excel Type interface, where a user can go in and update items in bulk like they would in Excel or Datasheet view in SharePoint.

I have created a gallery to show all items in List A.

I have a new column they need to update called 'Cost'.

When they update the cost and click add or save, i want List B to copy all the values from List A, including the new Cost Value and store this data in List B.

E.g. List A

Name | Employee ID | Manager Name |

List B

Name | Employee ID | Manager Name | Cost

I need to app to show items from List A in a gallery. I beleive i then need to add another gallery to first gallery and somehow connect the two a user can add a Cost to each item.

Please can someone help?

Thanks

Categories:

Building Power Apps

Hi @Vstar19 ,

You can create a collection to include all items of List A as well as adding an additional column using AddColumn function to include a blank column.

ClearCollect(colLA, AddColumns(ListA, "Cost", Blank()))

In the Gallery, set Items to this collection colLA, and then you will be able to use a TextInput box that bounds to the blank column:

ThisItem.Cost

Now in the Gallery, you will be able to type in numbers in the blank text inputs, so, you need to save the input values into the collection. OnChange of the text input box:

Update(colLA, ThisItem, {Cost: Value(Self.Text)})

To save/add to List b, you can leverage the Collect function, it can add multiple records to the data source if they have the same list structure:

Collect(ListB, colLA)

Best regards,

Community site session details

Create SharePoint list items from Power Apps

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates