web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collect data from drop...

Power Apps

Answered

Collect data from dropdowns to SharePoint list

(0) Share

Report

Report

Posted on by IvenSch

376

Hi together,

I have an app that collects input data from users and inserts it in a SP list. Within the app I have two dropdowns with projects that are from another SP list, so the users can only choose between these projects.

The two dropdowns have the following formulas:

Sort(Distinct('RnD project WBS';'Project Name');Value)

and

Filter('RnD project WBS';'Project Name'=ddl_ProjectName.SelectedText.Value)

My question is:

How can I get these inputs insert in my SP list where all the other data of the Power App is collected.

Thanks for supporting!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @IvenSch ,

Do you have a form in your App? Are the two dropdowns in the form?

I assume the two columns in the SP list are both LookUp columns. If they are in an edit form, Update of the two fields/Data Cards would be:

LookUp(Choices(ListName.Project); Value = ddl_ProjectName.Selected.Value)
LookUp(Choices(ListName.ColumnName1); Value = Dropdown2.Selected.ColumnName2) //ColumnName1 is the column for Dropdown2 //ColumnName2 is the column in 'RnD project WBS' list

Best regards,

Was this reply helpful? Yes No

Join the conversation