web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Answered

Collections Issue

(0) ShareShare
ReportReport
Posted on by 166

Hi All ,

 

I have used a blank gallery with some inputs , whose values are stored in a collection. I want to create multiple records to add so i' using patch and collect but the drop down values are getting reflected back to 100 , i'd Like it to be set to blank.

 

Here are some screenshots to better understand my issue , please check the below ones to check the formula's i've used.

The dropdown contains items from a sharepoint column , the text fields are just lookup values and the other 2 are textinput fields.

 

Everytime i hit the "save" button , i want it to create a row(record in the collection) which is working , but the values are repeating and i'd want it to be blank or with no selection so the user can select it. Also , everytime i try to add a record using the save button , the existing values get changed to 100.

 

Case Scenario : I select "759" in the dropdown , and hit Save. But the gallery adds a new record while resetting both dropdown to "100".

 

I think the issue is in the dependencies part , check the 2nd image. I'm not sure how to solve this , gladly appreciate any help! Thanks!

 mart4.PNG

mart3.PNGmart1.PNGmart2.PNG

 

Categories:
  • Gautham001 Profile Picture
    166 on at

    Can anybody share some help? Is there any way to avoid the dependencies , I just want the drop-down column to show items from a SharePoint column.

     

    @Shanescows maybe you might have some insight on this , I learnt quite a bit from your video.

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Gautham001 :

    Do you want the dropdown control in the new record to select 'none'?

    Firstly, let me explain why you encounted this problem.

    The key lies in the dropdown control's items property.The dropdown control cannot select the options it does not have, which means that if you want dropdown to select none, you must have none options to choose.

    In addition,If the default option of the dropdown control does not exist, it selects the first option by default.This is why your dropdown control always chooses 100.

    Secondly,I suggest you modify the data source of the dropdown control to solve this problem.

    For example:

    Add a record to the data source of the dropdown control, and set ItemName to none.

    or

    Set the ItemName of the first record in the data source of the dropdown control to none.

    Best Regards,

    Bof

     

  • Gautham001 Profile Picture
    166 on at

    Hi ,  @v-bofeng-msft ,

     

    I did the changes you suggested but i still face the main issue that is :

     

    After I fill out a row , and try to save a new record  , values of both row's get reset to the default option. I'd like to only reset the new record in the collection to be reset to default.

     

    mart5.PNG          -------------->       mart6.PNG

     

    I'd like to have the values that i select in the first row and not reset to default on addition of a new record.

     

    Is this possible?  

    Thank you.

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Gautham001 :

    Please set the dropdown control‘s default property.

    For example:

     

    ThisItem.ItemName

     

    1.jpg

    Best Regards,

    Bof

     

  • Gautham001 Profile Picture
    166 on at

    @v-bofeng-msft  , Thanks a lot , i think it's working now.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard