Unanswered

Update power app dropdown value in sharepoint list

(0) Share

Report

Posted on by ameenkvy1

I have loaded the data in sharepoint point list and using the share point list data, i want to create a table in the power app gallery. one of coulmn/field in the table will be dropdown and default value should be from sharepoint list data. whenever user updates the dropdown it should get reflected in sharepoint list.

Eg: In the sharepoint list data, there is a coulmn named month. There are already some values under month coulmn by default in the sharepoint list. How to add month drop down in power app gallery by retaining the already saved values in sharepoint list, also user could change the drop down value and it should get reflected in sharepoint list. Can someone help please?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@ameenkvy1

What is the definition of the column (Month) that you are trying to update? Is it a Choice column, or a Text column?

Was this reply helpful? Yes No
ameenkvy1 10 on at

Like (0)

Report

@RandyHayes its choice column.

Was this reply helpful? Yes No
ameenkvy1 10 on at

Like (0)

Report

Any solution?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@ameenkvy1

So without know any further details on your scenario or requirements, the basic concept is this:

- Set your Gallery Items property to your List

- Add a Dropdown and set the Items property of the Dropdown to: Choices(yourList.yourChoiceColumnName)

- Set the Default property of the Dropdown to: ThisItem.yourChoiceColumnName

- Then set the OnChange action of your dropdown to:

Patch(yourList, {ID: ThisItem.ID, yourChoiceColumn: yourDropdown.Selected } )

Was this reply helpful? Yes No