Answered

SharePoint List and power apps enter a Value on a drop down

(0) Share

Report

Posted on by Dive1

169

Hello I have a empty list share point and a apps on power apps where I want that the user fill is immat of cars in the drop down then submit the form and the other time that he return and create a new form he don't have to re enter is immat just select it
I've take the dropdow where we can write in it but it don't seem to work do you have any idea how to do it ?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dive1

Is my understanding here correct that you want the user's input for a car make to be stored for re-use as an available option in a dropdown?

So you essentially want to dynamically adjust the dropdown contents as the app gets used?

Was this reply helpful? Yes No
Dive1 169 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes The users enter the immat of his cars in the dropdown, enter all the data that the form need then submit the form and when he return on the app and create a new form I want that he don't need to re enter the immat of his cars because normaly it's save in the list in sharepoint like this he just have to selected it in the dropdow.

Was this reply helpful? Yes No
Dive1 169 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't kow how to do that so I was thinking to make the user write is data cars in a form alone and that will fill another sharepoint list (now I have to two share point list so, one whith just the data of the cars, and one with all the data that need to be submit by the form and the immat of the cars is in it too) but when I do that and connect the list, it's work it show the immat of the cars but when I submit the form he don't fill the collums of the immat of the cars on my share point list with the data of the form

Was this reply helpful? Yes No
Dive1 169 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I'll try something that should be possible because I have my list who work where I can select the data so how do I enter the data selected in the list in a text field or a label that will send the data to the right collum in my share point ?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Dive1,

Let me make it easy for you, you just want to save the previously input car immat as the dropdown list, right?

Not sure what is the column type you select to save the car immat, Choice or Text?

If it is a Choice, please edit the column setting as below to make it add values manually.

Then in your form, please modify the Update property corresponding to the car immat data card as below:

If( !IsBlank(ComboBox.SearchText), { Value: ComboBox.SearchText }, ComboBox.Selected )

If it is a Text column, please check as below.

I set the ComboBox Items property as below:

Distinct(List,CarImmat)

Modify the Update property corresponding to the car immat data card as below:

If( !IsBlank(ComboBox.SearchText), ComboBox.SearchText, ComboBox.Selected.Result )

Was this reply helpful? Yes No
Dive1 169 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks a lot man it worked

Was this reply helpful? Yes No