Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
 View Only
  • 1.  Split data into a SharePoint from a Concat field within a form

    Gold Contributor
    Posted Apr 11, 2022 04:20 AM

    Hi,

    I'm using a Combobox for a people picker search (Office365Users)

    From the search criteria I'm using Concat in my form but I then want to save the data into SP on separate rows.  As i need to send Email out to these people and get approvals from each one that a task has been completed. At the moment its displaying the data in one row

    Is this possible??

    Regards

    Chris

     



    ------------------------------
    Chris Clark
    Application Support Developer / Analyst
    ------------------------------



  • 2.  RE: Split data into a SharePoint from a Concat field within a form

    Posted Apr 12, 2022 08:43 AM
    Did you want to create separate submissions or just 1 with multiple approvals? If different submissions, then you could use a Patch to the system to create new tasks from the 1 task. I am trying to think of a way for you to un-concat the field but it might be best if you just did not concat at all. How many emails will be selected? Is it a set number? If just 2-3 then it might be better to have different fields for those items and then patch the system using those unique fields. Maybe others can figure out a better way on that.

    If 1 with multiple approvals then I would recommend doing something like a repeating table - https://wonderlaura.com/2016/12/21/powerapp-galleries-repeating-tables/
    It is technically not a table but a separate list that is able to create multiple rows for 1 submission. I use this for comments on our task system since I want the user to only interact with 1 task but see all the comments entered.

    ------------------------------
    Marie Castine
    Web Developer
    McDonough
    ------------------------------



  • 3.  RE: Split data into a SharePoint from a Concat field within a form

    Gold Contributor
    Posted Apr 13, 2022 05:00 AM

    Hi,

    Thank for your reply.  

    I've rectified the issue by using the Split, For all, Patch process but the solution you have provided for repeating tables will assist with another issue I have 





    ------------------------------
    Chris Clark
    Application Support Developer / Analyst
    ------------------------------



  • 4.  RE: Split data into a SharePoint from a Concat field within a form

    Posted Apr 13, 2022 01:32 AM

    Hello 

    I am using patch  Use the split to make new rows direcly 

    No1

    ForAll(
    Split(
    Concat(ComboColor.SelectedItems;Value;";");";");
    Collect(BoxColors;Result) ;;

    //Split cut it up in small values
    //dividing with semicolon

    Patch(tblMultipelRows; Defaults(tblMultipelRows);
    {

    Color: Result

    }

    )
    )

    No2 if the data is already in the SP list , this will take out multiple color choises and puit it in new columns but no dynamic cols

    And i patch it to a new sp list , where i use Powerautomate to run flows 

    tblSingelColorMultiCols;
    ForAll(
    tblMultiColorCol As wXL;
    With(
    {wColor: Split(wXL.Color;";")};
    {

    Color1: First(wColor).Result;
    Color2:
    With(
    {wCol2: Last(FirstN(wColor;2)).Result};
    If(!IsBlank(wCol2);wCol2)
    );
    Color3:
    With(
    {wCol3: Last(FirstN(wColor;3)).Result};
    If(!IsBlank(wCol3);wCol3)
    );
    Color4:
    With(
    {wCol4: Last(FirstN(wColor;4)).Result};
    If(!IsBlank(wCol4);wCol4)
    )
    }
    )
    )
    )



    ------------------------------
    Peter Eriksson
    Staff
    Gävle
    ------------------------------