Editform not working - Type of DataValue card cannot change from Text input to Drop down menu

(0) Share

Report

Posted on by AT_AlanTse123

181

Hi all,

I am beginner for develop power apps for retrieve the information from sharepoint list - "Cable" and let user to view detail and enable to edit . It has 3 screens, browse screen, detail view screen and edit screen.

In browse screen, there has the drop down menu for user to choose the cable type. It will filter and shown, user can press to view the detail information( detail view screen).

In Detail view screen, it has the edit button that redirect to edit screen for user to edit screen.

I want to change the location datavalue card from textinput to Drop down menu (yellow highlighted in edit screen photo)for user to choose and then update the list. Is it able?

If OK , how to set the drop down menu?

Browse screen:

detail view screen:

edit screen:

Thank you very much for your help.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@AT_AlanTse123

Unlock the location card on the Edit form.

Hide the textinput box inside.

Add a dropdown control that contains the locations, for example named, Dropdown1

You can use either of 3 options for the Items property of Dropdown1

Make a separate list of locations, (I prefer this one as you can then easily add new locations to the list)

Hard code it ["Location1","Location2", etc], or

if you already have all the locations in your list, Sort(Distinct(Cable,Location)).

Make its Default property: Parent.Default

Click on the Card itself and go to its Update Property.

Delete the reference to the textinput box in the Update Property

Replace it with: Dropdown1.Selected.Value or if you have used option3 above, use Dropdown1.Selected.Result

Your form will now save the selected value in the dropdown to your list when you submit the form.
AT_AlanTse123 181 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Drrickryp,

Thank you very much for your help. It is work.

May i know that when i submit the form, it update the value successfully and back to detail view screen but it will always show that the detail of first item of browse screen, how to fix it? Can i refresh the detail view screen after the form edited?

Thank you very much.
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@AT_AlanTse123

If you want the gallery to always show the newest record make its Default property

First(Sort(Cable,ID, Descending))
AT_AlanTse123 181 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, thank you very much for your help.