UK PowerApps and Flow User Group

Expand all | Collapse all

Splitting 1 submitted form into 2 records in Common Data Service

  • 1.  Splitting 1 submitted form into 2 records in Common Data Service

    Posted 7 days ago
    Hi all,

    Looking for some help guidance on how to split out 1 submitted form in my Powerapp, into 2 records in my entity in my common data service environment.

    To explain in a little more detail, I've listed the steps below:

    1. Create a 'Lead' where my sales rep selects 2 instrument products (each instrument product has it's own column in my common data service entity)
    2. When the record is submitted, it will only submit one record but with 2 products marked as 'TRUE'

    What I'm wondering is there anything we can do in PowerApps/Flow where it will basically 'Split' the one submitted record into 2 records?.

    Any help is much appreciated.

    Thank you.

    Jamie

    ------------------------------
    Jamie Stephen
    Business Analyst
    Alexandria SC
    7846021055
    ------------------------------


  • 2.  RE: Splitting 1 submitted form into 2 records in Common Data Service

    Posted 7 days ago
    Hello,

    customize the submit button or add the new one and remove the old one. OnClick run two separate flow to create to separate records.

    Cheers
    "Keep it simple, keep it faster"





  • 3.  RE: Splitting 1 submitted form into 2 records in Common Data Service

    Posted 3 hours ago
    Hi

    if you use a Patch command you can amend the on select rule of the submit button to patch to your data source multiple times on a single click. You could wrap your patch in a forall function set against the products field and it will patch a single entry for each product.

    Patch
    Patch function - PowerApps

    ForAll
    ForAll function - PowerApps

    ForAll - Patch - example
    How to bulk update with ForAll or Patch




    ------------------------------
    Sergio Giusti
    TSG - Office 365 Consultant
    ------------------------------