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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to save user galle...
Power Apps
Unanswered

How to save user gallery input into dataverse

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

I've got a vertical gallery pulling data from a source

The gallery looks like the attached picture, and there are 2 text boxes where users can manually enter data. Currently there are two 'patients' within my gallery

 

How do I save the data they entered in the gallery, into a column within dataverse (named clinical comments) for each respective patient

 

Power1231_0-1690252525704.png

 

Categories:
Building Power Apps
  • Sundeep_Malik Profile Picture
    Sundeep_Malik 6,501 on at

    Hey @Anonymous 

     

    For this you will have to use a Patch function on save button's on select property. The function should look something like below:

     

     

     

    ForAll(
    Gallery1.AllItems, // Replace 'Gallery1' with the name of your gallery
    Patch(
    'YourDataverseTableName', // Replace 'YourDataverseTableName' with the name of the table in Dataverse
    LookUp('YourDataverseTableName', PatientID = ThisItem.PatientID), // Find the record to update based on the PatientID
    {
    ClinicalComments: TextInputComments.Text,
    OtherDataField: TextInputOtherData.Text // Add more fields as needed
    }
    )
    )

     

    I hope this helps 🙂

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    The formula looks great, however the lookup section is causing difficulty, specifically PatientID=ThisItem.PatientID

    The data im pulling (lets call it AUData) cannot be changed or amended, so i had to make a new dataverse (lets call it clinical comments) where i can store any new data coming in

     

    I'm assuming to satisfy the formula above I need to pull some data such as Patient ID or visit number into a column within the Clinical comments source. As data flows in from the external source (AUData), how could i pull items from it (such as patient ID/visit number) into my new dataverse table (clinical comments) in order to satisfy the  formula you provided

     

    Cheers for any help you can give

     

    Power1231_0-1690270202466.png

     

     

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

News and Announcements

Welcome to the Power Platform Communities

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans