Answered

If someone answers a certain question with a specific answer it automatically fills in another answer

(0) Share

Report

Posted on by Evan_S1

341

I have list that I would like to have an answer automatically filled in when another question gets answered with a particular response.

For example I have a list column named "issues" selected by drop down with choices Quality, Part Missing, and Vendor Issues. Also, I have list column named "Responsible" that has choices ORE, Quality, Purchasing as the choices. If someone selects Quality I want it to fill in the list column named "Responsible" with Quality automatically, if someone selects Vendor Issue I want it to fill in the list coulumn named "Responsible" with Purchasing. How do I add this to my power app?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Ygor 44 on at

Like (0)

Report

Hi @Evan_S1,

Maybe you can use switch function to resolve this. In "Text" property of your list column named "Responsible", use a code like this:
Switch(
Dropdown1.SelectedText.Value,
"Quality", "Quality",
"Part Missing", "ORE",
"Vendor Issues", "Purchasing"
)

Where the DropsDown1 is the drop down of your list column named "Issues"
If this solves your question, would you be so kind as to accept it as a solution.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

@Ygor This isn't working. Also, I forgot to mention in power apps these questions are being answered on a form generated from list.

Code shows: Choices([@'Production Stoppage - DRAFT 1'].Responsible);
Switch(
Issue.SelectedText.Value;
"Quality Issue"; "Quality";
"Missing Stock Part"; "ORE";
"Vendor Error"; "Purchasing")

Error Shows:

Was this reply helpful? Yes No
Ygor 44 on at

Like (0)

Report

Oh sorry, i was thinking you wanted to show it on a label. But you can resolve your problem changing column type from your list. Instead you use choice column, prefer to use single line of text, so you can record in list the option according by issue column drop down, using your code:
Switch(
Issue.SelectedText.Value;
"Quality Issue", "Quality",
"Missing Stock Part", "ORE",
"Vendor Error", "Purchasing"
)

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

Current Form:

Issue function:

Responsible Function:

When I put this function in either function, I get the error below:

Choices([@'Production Stoppage - DRAFT 1'].Responsible); Switch(
Issue.SelectedText.Value;
"Quality Issue", "Quality",
"Missing Stock Part", "ORE",
"Vendor Error", "Purchasing"
)

Was this reply helpful? Yes No
Ygor 44 on at

Like (0)

Report

Yes, this error occurs because the column type is set to "Choice". Your available options are stored in [@'Production Stoppage - DRAFT 1'].Responsible. However, as I proviously mentioned, you don't necessarily need to use this approach. Instead, you can simply set your "Responsible" column to "Single line of text" and record the field based on the issue column.

I'm not sure if I was clear in my answer, but by using "single line of text" you have the freedom to fill in this field based on the person's choice. Are you using SharePoint list, Dataverse or other database?

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

SharePoint.

I changed the SharePoint List column "Responsible" to single line of text instead of Choice.
Still seeing the same error.

Was this reply helpful? Yes No
Ygor 44 on at

Like (0)

Report

It shouldn't be giving this error still, maybe you're using the old code or you need to update the list in Power Apps. Now you can use this code with the condition:

Switch(
Issue.SelectedText.Value;
"Quality Issue", "Quality",
"Missing Stock Part", "ORE",
"Vendor Error", "Purchasing"
)

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report

I changed it to single line of text but it threw off all the other formulas I had already put within the app. Also, I would prefer to keep it as a drop down in case the "Responsible" choice needs to be changed based on the actions and delegation of the problems the app is capturing.

Is there a formula by chance that can auto populate it based on both being columns set up as choices?

Was this reply helpful? Yes No
Ygor 44 on at

Like (0)

Report

Hi again @Evan_S1,

Unfortunately, I don't have a solution for your problem, perhaps someone knows a way to solve this. Personally, I don't use the form editing component because the fields are fixed and do not allow for much flexibility in terms of customization.

I use simple components like text input and dropdowns to build a form, so that I can manipulate them in the app according to my business rules, and then recording in SharePoint with a button. So, I can automatically populate the dropdown and still leave it open for the user to select another option.

Was this reply helpful? Yes No
Verified answer

Evan_S1 341 on at

Like (0)

Report

Changed it from a drop down to a text label and had the text label auto fill based on the drop down selection.

Was this reply helpful? Yes No