Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - GCC, GCCH, DoD - Federal App Maker... / Migrate specific colum...
Power Apps - GCC, GCCH, DoD - Federal App Maker...
Unanswered

Migrate specific column data from one data source to another (active to retired) ex: laptop make/model/serial/hostname/etc

(0) ShareShare
ReportReport
Posted on by broooooock 18

Looking for some assistance with taking existing gallery column field data from one data source and migrating it (retiring it) into another data source. Essentially it would be an inventory item (like a laptop with it's make/model/sn/hostname/etc information).

[@ACTIVE] data source
OnSelect =  <ACTION TO MIGRATE DATA TO ANOTHER DATA SOURCE>   Remove([@ACTIVE], BrowseGallery1.Selected); If (IsEmpty(Errors([@ACTIVE], BrowseGallery1.Selected)), Back())

Thanks in advance! 

  • FocusRach Profile Picture
    FocusRach 63 on at
    Re: Migrate specific column data from one data source to another (active to retired) ex: laptop make/model/serial/hostname/etc

    Hi @Broo - Depending on the sources you're working with and how many records, I would check out the ForAll() Function too. 

    ForAll() allows you to loop through multiple records with a function such as Patch(), meaning you can create multiple records in a single click. 

    Patch() & ClearCollect() is great if you don't have a lot of fields to link. 

    Submit() uses a Form, so you would have to link the fields from your original datasource to your new one. This might not work in the scenario where you want to loop through many records, it may. I have not tested that. It would work however if you had a Gallery of your old records that allowed you to select each item. 

    And yes, these are in GCC High! 

    Hope this helps! Happy Solutioning! 

  • broooooock Profile Picture
    broooooock 18 on at
    Re: Migrate specific column data from one data source to another (active to retired) ex: laptop make/model/serial/hostname/etc

    Thank you, posting to the general forum instead. I am developing something within the GCC/H realm so wasn't sure if I should post here or not.

  • jwillisrosemsft Profile Picture
    jwillisrosemsft Microsoft Employee on at
    Re: Migrate specific column data from one data source to another (active to retired) ex: laptop make/model/serial/hostname/etc

    Hello,

    I'm not sure this is specific to GCC/H/DoD, so you might get more help if you posted in the general forum: Building Power Apps - Power Platform Community (microsoft.com)

     

    That being said, it sounds like you want to create a new record in another data source and then remove the same data from the original data source.  To add a row to a data source, you can either use Collect() or Patch() functions.  Patch() is generally the preferred method for adding or updating records.  You'll need to add all data sources to the canvas app first.  

     

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
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 770 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 494

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 399

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans