Unanswered

Using Gallery data as table from PowerApps

(2) Share

Report

Posted on by WorkingRicardo

818

For my sharepoint list form I'm using a Gallery to display an Excel table. In powerapps you can choose an option to filter the table, with the table remaining to be like 10-20 rows and 6 columns. I'm trying to then use that filtered table to add rows into an Excel table. Is it possible?
So far, I have this code to start the Automate flow:

'Condiciones:pruebarecibirtabla'.Run(
    Concat(
        ExportData2;
        'Ref.' & Char(9) & Modelo & Char(9) & 
        Switch(
            DataCardValue2.Selected.Value;
            "A"; Substitute('Neto UD LOTEA'; "."; ",");
            "B"; Substitute('Neto Ud LOTEB'; "."; ",");
            "C"; Substitute('Neto Ud LOTEC'; "."; ",");
            ""
        );
        Char(13)
    )
)

Ref., Modelo, Neto UD LOTEA and so on are the required columns. In my flow I then added this to a string variable called TablaDatos. I get something like this:

Ref1	Modelo1	NetoUDLOTEA1
Ref2	Modelo2	NetoUDLOTEA2
Ref3	Modelo3	NetoUDLOTEA3
Ref4	Modelo4	NetoUDLOTEA4
Ref5	Modelo5	NetoUDLOTEA5

But for the life of me I don't know now how to let Automate know that this are 5 different rows and do stuff with this.

Is this even possible? Really appreciate your input in advance!
Kind regards,

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
To help Power Automate identify rows more clearly, you can use a delimiter (like a pipe | or semi-colon ;) between each row, and tabs (\t) between columns. e.g.

'Condiciones:pruebarecibirtabla'.Run( Concat( ExportData2; 'Ref.' & Char(9) & Modelo & Char(9) & Switch( DataCardValue2.Selected.Value; "A"; Substitute('Neto UD LOTEA'; "."; ","); "B"; Substitute('Neto Ud LOTEB'; "."; ","); "C"; Substitute('Neto Ud LOTEC'; "."; ","); "" ); "|" ) )

In Power Automate,

Use split to split the incoming string by |, which separates the rows:

split(triggerBody()['TablaDatos'], '|')

Use the output of the "Compose" action (the array of rows) in an "Apply to each" action.

Inside the loop, use another "Compose" action to split each row into columns based on the tab delimiter \t:

split(items('Apply_to_each'), '\t')

You can then retrieve the values as

Ref → outputs('Compose')[0] Modelo → outputs('Compose')[1] Neto UD LOTEA → outputs('Compose')[2]

Let me know if you run into issues

Was this reply helpful? Yes No
WorkingRicardo 818 on at

Like (0)

Report

Yes! That helped. Altough sometimes the second compose didn't go as intended, so I opted to split things with a "/" isntead: "split(items('Apply_to_each'), '/')"

Was this reply helpful? Yes No