Edit each record in Powerapps - SharePoint

(0) Share

Report

Posted on by Kumar9024021

195

Hi,

I am developing a powerapps screen which should show SharePoint list items, similar as a datatable format. However, I would like to have a Edit icon inside each record of datatable, which allows me to edit the particular record through EditForm.

I understand we can't add any icon inside datatable. May I know is there anyway to achieve similar functionality in Powerapps ?

Also, would like to have filter,sort, search functionality on top of the datatable.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

Hi,
An editable gallery is exactly what you need for all of the functions you have specified.

Let me know if you need more details.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Kumar9024021 195 on at

Like (0)

Report

Hi @PowerAddict ,

Yes please. I am new to powerapps. More details would be much helpful. Thanks.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Yss I completely understand. There are 2 ways you can get a label. One is you could have a series of labels outside the gallery serving as headers. Or within your gallery, you could have each control have a label and value, something like "Label: " & ThisItem.Title

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
Kumar9024021 195 on at

Like (0)

Report

Thanks for your response @PowerAddict .

If there are 40+ SharePoint list items, showing in a single screen would look weird right. Does gallery support filter/sort/search functionality ?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Yes it does. You can find info about search and filter here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup#delegation

Information on sort can be found here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-sort

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
MasterOffice365 184 on at

Like (0)

Report

You can add a column in the Data Table set to any field really in your SharePoint List / Document Library.
For example: ID

Then on the Properties pane for that column, set the IsHyperlink property to true.
Set the Text property to whatever you want.
Finally add whatever code you need to execute for the selected item in the OnSelect property for that column.
On the OnSelect property you can utilize and column or field in the SharePoint data source using the following syntax:
DocumentLibraryItems_DataTable.Selected.{ColumnName}

In action, as per the demo video on YouTube: https://youtu.be/poKsDNYm9Jw
Source code for demo app showcased: https://masteroffice365.com/powerapps/9/#DownloadSolution

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (1)

Report

Hi @Kumar9024021 ,

Based on your description, I think what you want is a combination of gallery, editform and display form.

Firstly, in gallery form, you could view all the items of the list.

You could set the arrow button to navigate to edit form screen.

Then when you click the arrow button, you will jump to the edit form and linked with the item that you selected in gallery.

Also, you could also filter,sort, search in the gallery.

Key points:

use gallery to display, set gallery's Items to filter,sort, search formula, set arrow button's OnSelect to navigate function.

Secondly, in edit form screen.

Set the edit form's Item to gallery1.Selected.

Then the edit form will display the item that you selected in the gallery.

Insert a submit button, set its OnSelect: SubmitForm(Form1);Back()

Then after you click the button, the data will be submitted and you will come back to gallery screen.

Thirdly, in display screem.

Set the display form's Item to gallery1.Selected.

Then you could view the item that you selected in the gallery in details.

The app will look like this:

Here's a doc about this kind of app in details for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-forms

Best regards,

Was this reply helpful? Yes No