Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Need help in Patch gallery item to dataverse

Am working on planning app. Each day has 2 shift and each shift has no.of room



Item property of gallery is : Sequences(7).


I have columns in dataverse 
No.of room planned for Monday in Day shift:

No.of room planned for Monday in Night shift:

No.of room planned for Tuesday in Day shift : 

And so on for all 7 days in a week


I have gallery with drop down to select no.of rooms

How to patch the value from gallery to dataverse?

For example: I would like to see the value 

No.of room planned for Monday in Day shift:2

No.of room planned for Monday in Night shift:1

No.of room planned for Tuesday in Day shift : 2
No.of room planned for Tuesday in Nightshift : 3


How can i achieve this. I have tried with 
LookUp(Choices(Weeklyplanning.No.of room planned for Monday in Day shift'), Value in Text(DD_DayShiftRoom.Selected.Value)).Value


Column is updated with the Value 1, not the selected value from dropdown.

Community Support
Community Support

Hi @PapithaSekar1 :

  • Could you show me the complete patch formula?
  • Could you tell me what DD_DayShiftRoom is?
  • Could you show me the data structure of the data source?

If you need to get the value selected by dropdown in the item you selected in the gallery. You must use Gallery.AllItems to get all the items in the Gallery and then filter them.Because Gallery.AllItems contains the properties of all controls in the Gallery.

Best Regards,



Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (38,386)