Unanswered

Populate last submitted values in a form for text and selection fields

(0) Share

Report

Posted on by he-man-123

I have a form where users will input requests which are then linked to a Sharepoint list. The form has some text columns and some radio button selections. However, users have mentioned how in a batch of requests, only a few inputs change, so it would help to be able to auto-populate the form using their last submission.

Currently, I have managed to partially resolve this issue (for text fields only) using another thread. Thanks @RandyHayes !

However, the radio button selection fields do not auto-populate and I would like to seek help for this.

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @he-man-123 ,

Please try this in the DefalutSelectItems in the DataCardValue for the Choice Column.

If( !IsBlank(Form2.LastSubmit.ID), LookUp(Choices([@'YourDataSource'].ChoiceColumnName),Value = Form2.LastSubmit.ChoiceColumnNam.Value,Form2.LastSubmit.ChoiceColumnNam), ThisItem.ChoiceColumnNam )

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
he-man-123 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tina, thanks for getting back to me.

I don't have DefaultSelectItems so I did as you suggested in Default in the DataCard. However, I receive the following error:

Any idea on how to resolve this?

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @he-man-123,

It is seems that the formula you write mistake in the LookUp of the Second parameter.
If(
!IsBlank(Form2.LastSubmit.ID),
LookUp(Choices([@'YourDataSource'].ChoiceColumnName),
Value = Form2.LastSubmit.ChoiceColumnName.Value,
Form2.LastSubmit.ChoiceColumnName),
ThisItem.ChoiceColumnName
)

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
he-man-123 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tina,

I was looking online and was able to find this fix too. While it shows no errors, when I run the powerapp, it does not remember my last submit choice for the field.

Could I clarify if it is correct to try this in Default of the DataCard?
Alternatively, when I try this in the Default of the RadioButton, I get the following:

Do let me know what I am doing wrong and how to troubleshoot 🙂

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @he-man-123 ,

If you use Radio Control for showing the Choices options.
We made a sample for you.
If( !IsBlank(Form2.LastSubmit.ID), LookUp(Choices('0822-1'.Choice),Value = Form2.LastSubmit.Choice.Value,Form2.LastSubmit.Choice.Value), ThisItem.Choice.Value )
We deduce that you have some formula in the OnSuccess so that the Canvas App cannot remember your last Submitted.

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
he-man-123 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Tina, thanks once again.

The following is my OnSuccess formula, which is working on remembering the LastSubmit text values:
Set(currItem, Form1.LastSubmit); Set(glbCurrentRecord, Self.LastSubmit); Navigate(FirstScreen); Notify("Form submitted successfully",NotificationType.Success)

Your provided formula doesn't seem to work:
If(
!IsBlank(Form1.LastSubmit.ID), LookUp(Choices('DataSource'.Choice), Value = Form1.LastSubmit.Choice.Value, Form1.LastSubmit.Choice.Value),
ThisItem.Choice.Value
)

Appreciate your help.

Was this reply helpful? Yes No