Unanswered

Using collection for dropdown does not show results on Edit

(0) Share

Report

Posted on by nor3msti

I have a SP list and canvas app, My data cards have text input and dropdown selection, I only need to see text input in sharepoint list and that works fine but when users edit form I want the selected value of the dropdown to be displayed.

When I submit form here is the code: there is 148 dropdowns total but I shortened it for this example.

SubmitForm(EditForm1) ;
Collect(DropDownSelections, {
SQ1 :sDropdown1_1 .SelectedText, 
SQ2 :sDropdown1_2 .SelectedText})

I've tried on start of application: Thinking this would make a difference

LoadData(DropDownSelections, "DropDownSelections")

The default property of the dropdown I have tried so many scenarios its garbage to post. But here goes.

DropDownSelections(sDropdown1_1.SelectedText)

A simple snapshop of the dataCard.

The application works fine except that when user edits the form I want the previous selected dropdown selection to show also.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

TylerPA 201 on at

Like (0)

Report
@nor3msti ,

What are your Update fields set to for your datacards? Unless I'm misunderstanding why you're collecting the dropdown values / misunderstanding your card setup - please let me know:
Card Update field would be 'Dropdown.Selected.Value'. This would update a text field on sharepoint
The dropdowns Default can be set to 'Parent.Default'. When editing, the dropdown would select the current existing value for that record being edited

Was this reply helpful? Yes No
nor3msti 84 on at

Like (0)

Report
The data card update property is
BrowseGallery1.Selected.'1. DO ALL EMPLOYEES ATTEND AND PARTICIPATE IN THE BEGINNING OF SHIFT SAFETY MEETING?'
When i change it to your option, the textbox displays the text from the drop down menu.
When i save this form to share point, the textbox has text that saves to the sharepoint list, the dropdown is only on the canvas side of the app so i created a collection to store the selected values. However when i return to edit the form the dropdown values are not there, the dropdown resets back to original state.

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report
Ok thanks - as another check:
What are your Items and Default properties of the dropdown set to?
What is the default value of your data card set to?

Was this reply helpful? Yes No
nor3msti 84 on at

Like (0)

Report
Items
["", "Compliant", "Non-Compliant"]
Default property: Well I've tried about every scenario on this site and nothing is working so its "1" for now.
Default datacard:
ThisItem.'1. DO ALL EMPLOYEES ATTEND AND PARTICIPATE IN THE BEGINNING OF SHIFT SAFETY MEETING?'
The text box property is Parent.Default < no issues with the textbox.
and again, dont need the dropdown selection to save to sharepoint, i just want the last option selected to be viewable when editing the form.

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report
@nor3msti thanks - and to confirm:
for your dropdown default property - Parent.Default is not working?
if that's still not, try for default property: First(Filter(["", "Compliant", "Non-Compliant"], Value=Parent.Default)).Value

Was this reply helpful? Yes No
nor3msti 84 on at

Like (0)

Report

no, its not reataining the selected item, Do I need to remind you I added this dropdown to the datacard, its not in the sharepoint list at all so the parent would be the collection correct?

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report

nope, even if you add a new dropdown Parent refers to the source for that data card. it doesn't refer to the Items property of the dropdown

I've been trying both ways (using a Choice field, and collection), and been getting it to work with both those prior suggestions- apologies for what appear redundant questions

Feel free to message an export of the app, and a csv of the list - I can take a deeper look later if you'd like

Was this reply helpful? Yes No
nor3msti 84 on at

Like (0)

Report

I sent you a message with link to program,
thank you for the help

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report
@nor3msti ,

Ok - that helped a bit. I misunderstood how you were using your dropdown/text fields

Since you have ~150 columns, which update on a text field based on the text input. You are trying to also retain separate dropdown values, without adding a separate sharepoint column to do so

I would not recommend your current approach (save data, load data, collecting the dropdown values...). Very complex

I would suggest a different approach to saving your entries. This will simplify things a bit compared to the current approach, but also retain the information to sharepoint

// change your Cards update property to this. you can replace "***" with a different convention if you want, you just don't want it to be text that could appear in an entry Concatenate(sDropdown1_1.Selected.Value, "***", sTextInput1_1.Text) // change your dropdowns default to First(Split(Parent.Default, "***")).Result // text fields default to Last(Split(Parent.Default, "***")).Result

What sharepoint looks like:

What App looks like:

You would need to make some updates to your galleries and display forms accordingly. Otherwise, if you do not prefer this approach - I think the alternate truly is to create a separate sharepoint column for each dropdown

Was this reply helpful? Yes No
nor3msti 84 on at

Like (0)

Report
ok, so this will work with a few exceptions,
would it be better to use radio buttons instead of dropdowns, I assume the same concept,
using this, on a new form the dropdown is already showing the last selection from the previous selection. how to correct that?
This isnt working
If(FormMode.Edit, true, false); First(Split(Parent.Default, "***")).Result

Was this reply helpful? Yes No