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 Platform Community / Forums / Power Apps / ForAll dropdown field ...
Power Apps
Unanswered

ForAll dropdown field not patching to the list

(0) ShareShare
ReportReport
Posted on by 25

Hi, 

 

I have produced a collection to capture data entered into certain fields. Now I am trying to submit to a list, but I am having issues with two data fields that are drop-down selections. at first I had issues with the sections being captured in the 'Collection" table, where it was just bringing back [object Object] but resolved that by adding .Selected.Value and that fixed the issue. but now I am trying to send it to the list via a submit button, it does not like any of the parameters for the two drop-down field that I have to pass through. All other fields work. 

 

This is my "onSelect" so far (still needs some final work around the thankyou and navigate, but that will be easy to do)

ForAll(
Equipmentregister2,
Patch(
'Safety-TRAM Equipment Register',
Defaults('Safety-TRAM Equipment Register'),
{
'Equipment Number': Equipment,
'Equipment Type': Type,
'Equipment currently being used': CurrentlyUsed,
'Last Maintenance Date': LastMaintenceDate,
'Maintenance due date': MaintenanceDueDate,
'Property Address': TextInputAddress_1.Text,
State: TextInputState_1.Text,
Program: TextInputProgram_1.Text,
Region: TextInputRegion_1.Text,
'House Email Address': TextInputSiteContactEmail_1.Text,
'Property ID': Value(TextInputpropertyID_1.Text)
},
Form_PersonDetails_1.Updates
)
)

 

The above works, but as soon as I try to bring in the OwnedBy and Maintenancefrequency which is data from a drop down selection, it does not work, no matter what I try. I have tired .Selected  .Selected.Value  Value(OwnedBy.Selected)......

 

CathyCathy_0-1682996307099.png

 

Hope someone can help out, happy to work with someone to see what the issue may be and what I am missing, thanks in advance

 

Categories:
  • CathyCathy Profile Picture
    25 on at

    Sorry should have put a screen shot in for what I am trying to do.

     As you can see the data is captured in the below table via a collection function. Now what I am trying to do is patch the data to the list via the ForAll and Patch feature.

    CathyCathy_0-1682997004639.png

     

  • EddieE Profile Picture
    4,650 Moderator on at

    @CathyCathy 

    In your image, you appear to be missing a comma after OwnedBy?

     

    Also, what field types are you trying to Patch OwnedBy and Maintenancefrequency to? Are these Single Line of Text fields?

  • CathyCathy Profile Picture
    25 on at

    They are a Choice Colums (single choice)  

  • CathyCathy Profile Picture
    25 on at

    Sorry I should have also mentioned, yes there is no comma, as it was to show that as soon as I enter the OwnedBy field it has an error, no matter what I had to i.e. OwnedBy.Selected or OwnedBy.Selected.Value or Value(OwnedBy.selected) I have tried various different ways. I just must be missing something.

  • EddieE Profile Picture
    4,650 Moderator on at

    @CathyCathy 

    Ah ok.

     

    It appears that you are trying to Patch Text to a Choice column, which is difficult to achieve. The simple solution is to capture the correct choices in your collection then it should all work. For example,

     

    Owned by:

    When adding to your collection, use

    Collect(
    ...
    OwnedBy: First(ComboBoxOwnedBy.SelectedItems)
    ...
    )

    To display OwnedBy in your galley, use this on your label

    First(ThisItem.OwnedBy).Value

     

    You can do the same for Maintenancefrequency.

     

    You will need to adjust your column names to suit but the above should be what you need to solve this.

     

  • CathyCathy Profile Picture
    25 on at

    @EddieE 

     

    If I change the formula in the Collection section to the above it gives me back [object Object] 

    CathyCathy_0-1682998854908.png

    CathyCathy_2-1682998892652.png

    But if I have OwnedBy: DataCardValue26.Selected.Value it works. 

    CathyCathy_4-1682999001411.png

    CathyCathy_5-1682999073185.png

    I am so sorry for being difficult 🙂 

     

     

     

  • EddieE Profile Picture
    4,650 Moderator on at

    @CathyCathy 

    Are you displaying your collection using a DataTable or a Gallery? DataTable have some limitations and I'd avoid using them if you can.

  • CathyCathy Profile Picture
    25 on at

    I am displaying them as a data table as the Gallery does not capture all the fields in the one nice display.....

  • EddieE Profile Picture
    4,650 Moderator on at

    @CathyCathy 

    Try using this code for displaying the OwnedBy value

     

    Concat(ThisItem.OwnedBy,Value)
  • CathyCathy Profile Picture
    25 on at

    In the submit to register or the Forall & Patch button? 

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 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

Last 30 days Overall leaderboard