Unanswered

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

(0) Share

Report

Posted on by broooooock

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!

Categories:

GCC, GCCH, DoD - Federal App Makers (FAM)

I have the same question (0)

All responses (3)

Answers (0)

Sort by

JW-02101845-0 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
broooooock 18 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
FocusRach 63 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No