Unanswered

I would like to create a row counter inside a Gallery control, that can also reorder the rows using a dropdown control. this should be able to connect to a sharepoint number field, and updates the control choices based on number of rows and save to SP.

(0) Share

Report

Posted on by rsudan_washcorp

Good day.

I would like to implement a Row counter inside Gallery control, which is connected to a sharepoint list, using a dropdown control.

And that control is connected to a regular Number column in Sharepoint Online List, which we name the column Choice ( not to be confused to a Choice Field in sharepoint)

And id like that control to behave like the order reordering that you have when you Edit a view in sharepoint, to order the positions.

I find it very hard on how to implement this, and to have that control populate the order choices programmatically and correctly according to the current number of rows in that list, and to update it back to sharepoint on value change.

I tried to search online and youtube, but i cannot find any correct implementation. This is an important functionality that i need to have on my app, as this is the feature of a previous app deployed in our Sharepoint 2013 site which needs to be updated to powerapps , due to a revamped list structure.

I hope that someone can help me build this control. i am really stuck and my users needs this functionality.

I will attach the photos of my app to describe the functionality that i would like to implement.

Hoping for your soonest help and support.

THank you very much,

Rommel

image 1 - powerapp to create reorder row dropdown control.png Image 2 - number field in sharepoint list.png Image 3 - the list view that i am working it.png Image 4 - the rows order what we want to do in powerapps.png Image 5 - the Old app that contains the custom dropdown column reorder connect to number field in SHarepoint.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rsudan_washcorp ,

What code is in the current Items of the gallery? Also Choice is a bad name for a field, but I am assuming you simply want the rows numbered in the order they are presented in the gallery?

Was this reply helpful? Yes No
rsudan_washcorp 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Good day and thank you for your reply.
Yes, the field name is confusing, it was copied from an older sharepoint list structure. It should be named Order.

And yes, i want that dropdown control to count the row order. So at first if its only 1 record, it will only have 1 choice inside. If there are 2 records, then the choices will be [1,2], If 3 then [1,2,3], which the first row will have 1, second row will have 2, and 3rd row will have 3.

Then that defines the order. For example in the 3rd row, where that dropdown control has [3] value in it, then when i click that control, if i select [1], Then it should reorder that row to be the first row in the gallery, and the other items will be reordered correctly according the number ascending.

The items property of the Gallery is a filtered connection to the Bid Forms list .

Filter('Bid Forms', EmployeeNumber = First(dt_MyCraft).'Employee No' && IsBlank(Submitted) && Deleted = false && Now() < DateTimeValue(Bulletin_x0020_Lookup_x003a_Clos.Value))

Please advise.
Thank you.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rsudan_washcorp ,

Are you asking for dynamic content for the choices of a multi-choice combo box based on the number of rows rather than (as I assumed initially) simply numbering the rows in the gallery?

I can do the first for you, but the second is not possible to my knowledge.

Was this reply helpful? Yes No