Powerapps forms default value

(0) Share

Report

Posted on by AshishJaiswal

776

Hello Experts

I have sharepoint List 1 displaying data in Form 1 (in view mode)

On the next screen I have form 2 (in new mode) which on submitform will patch data to sharepoint list 2

I would like that product field in form2 to have default value from FORM 1 (or from List 1 either ways)

Example if someone select 'Exchange' in form1

'Exchange' should be the default value in Form 2 when the user is redirect to form2 screen.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @AshishJaiswal

Set the Items property of the dropdown to
Choices(SPList2, ChoiceColumn)

Set the Default Property of the dropdown to
ControlDropdownName.Selected.Value

Where ControlName is from the previous screen dropdown

Thanks, Stalin
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@StalinPonnusamy

Does not work

Default value in form2 should be from1 or SP list 1

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

I assume you have product selected from the previous screen. You mentioned from 1 is view only. So we can't select anything.

The default value should come from the previous screen where you made a product selection from the dropdown.

Let me know where you are selecting the product from List 2?

Thanks, Stalin
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report

@StalinPonnusamy

My mistake

Let me clarify everthing

Screen 1 - Gallery showing items from List A
Next Button
Screen 2 - Form1(view mode) showing selected item from gallery
Next Button
Screen3 - Form2(new mode) which will patch data from form2 to ListB

Now when user is in screen 3 on form2 - he should see default value in dropdown which he selected in screen1

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @AshishJaiswal

NO worries. Thanks for the clarification.

Set the Default property to Form2 dropdown
GalleryName.Selected.ProductColumnName

Make sure to set the Items property which has values.

If the default value for Edit and New mode then we need to set
Coalesce(ThisItem.ProductColumnName.Value, GalleryName.Selected.ProductColumnName)

Thanks, Stalin
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Was this reply helpful? Yes No
AshishJaiswal 776 on at

Like (0)

Report
@StalinPonnusamy

Sorry, I think I am not able to follow

On form2 in the default property of the dropdown i need to use this -
GalleryName.Selected.ProductColumnName

and where do i need to use this
Coalesce(ThisItem.ProductColumnName.Value, GalleryName.Selected.ProductColumnName)

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @AshishJaiswal

Set the default property of the dropdown to

If your form2 is always in new mode (Newform) then
GalleryName.Selected.ProductColumnName

If the form is used as newform and edit form then use
Coalesce(ThisItem.ProductColumnName.Value, GalleryName.Selected.ProductColumnName)

Thanks, Stalin
Blog - Learn To Illuminate Blog
YouTube - Learn To Illuminate Videos

Was this reply helpful? Yes No