cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thanasis
Helper IV
Helper IV

Galley dropdown issue saving in a collection

Hello I am having the below issue. Trying to make when clicking the save button all my info gets saved and create a new entry for me to fill. All my data are being saved except my dropdowns, is there a way I can make it also hold my dropdown values 

Thanasis_0-1657219513272.png

As you can see when I click save everything stays on except my dropdowns

Thanasis_1-1657219570059.png

 

I have a collection that everything gets saves too once I click save but for some reason I cant see the dorpdown values. If I go in the collection I can see them 

Thanasis_2-1657219641001.png

This is what my Disk Save icon does 

 

Patch(
    ExpenseCollection,
    ThisItem,
    {
        LineItem: InputItem.Text,
        LineCost: Value(InputCost.Text),
        LineVendorName:VendorName.Text,
        LineDate:DatePicker1.SelectedDate,
        LineGiftsThank:Text(DataCardValue37.Selected.Value),
        LineNumberItems:Value(DataCardValue42.Text),
        LineTypegift: Text(DataCardValue36.Selected.Value),
        LinenumberAttend:Value(DataCardValue35.Text),
        LineNameAttend:DataCardValue3.Text,
        LineBusinessProp:DataCardValue33.Text,
        LinetypeExpense:Text(DataCardValue24.Selected.Value),
        LineGLAccount:DataCardValue41.Text,
        
        ShowSaveButtons: false
    }
);
If(
    EditPressed,
    false,
    Collect(
        ExpenseCollection,
        {
            LineItem: "",
            LineCost: 0,
            LineVendorName:"",
            LineDate: "",
            LineGiftsThank: "",
            LineNumberItems: "",
            LineTypegift: "",
            LinenumberAttend: "",
            LineNameAttend: "",
            LineBusinessProp: "",
            LinetypeExpense: "",
            LineGLAccount: "",
            ShowSaveButtons: true
        }
    )
);
UpdateContext({EditPressed: false});
Set(
    NeedsSaved,
    false
)

 

 and this is what my galleries data look like

Thanasis_3-1657219768225.png

All my 3 dropdowns get their data from a choice column in SharePoint. 

 

Is there a way to link my Type of expense dropdown once I click the save button to take the value of the type of expense that has been saves to the collection that I have ?

 

I would really appreciate all the help I can get. 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Thanasis ,

 

Could you please check the place where this collection is created? Those columns are of type text when it was getting created.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

3 REPLIES 3
v-jefferni
Community Support
Community Support

Hi @Thanasis ,

 

Please try and modify your Patch function:

Patch(
    ExpenseCollection,
    ThisItem,
    {
        LineItem: InputItem.Text,
        LineCost: Value(InputCost.Text),
        LineVendorName:VendorName.Text,
        LineDate:DatePicker1.SelectedDate,
        LineGiftsThank:DataCardValue37.Selected,
        LineNumberItems:Value(DataCardValue42.Text),
        LineTypegift: DataCardValue36.Selected,
        LinenumberAttend:Value(DataCardValue35.Text),
        LineNameAttend:DataCardValue3.Text,
        LineBusinessProp:DataCardValue33.Text,
        LinetypeExpense:DataCardValue24.Selected,
        LineGLAccount:DataCardValue41.Text,
        
        ShowSaveButtons: false
    }
);

 

So, you will need the selected RECORD of dropdowns so that the dropdowns will be able to have it as the default selected item.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Thanasis
Helper IV
Helper IV

hello @v-jefferni  I did try that but was giving me this error 

Thanasis_0-1657631867431.png

 

Hi @Thanasis ,

 

Could you please check the place where this collection is created? Those columns are of type text when it was getting created.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,516)