Answered

Merge common rows in SharePoint linked to a PowerApps

(0) Share

Report

Posted on by PatricioH

Hi all,

Recently I got hired at a company that works with PowerApps in their process. They made an application that give us data from 3 different machines and create 3 different rows in SharePoint with a common architecture between them, leaving some cells with no data. Those rows have the same ID and columns.

Is there a way to merge all 3 rows from the different machines into 1?

Here's an example of what I'm saying. The first 2 rows doesn't have info in those columns, but more to the right they do and the last one doesn't.

Sorry for the bad english, not my first language.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @PatricioH ,

It is easy enough to find the ones with data, but what if two have data, which one's fields take preference ?

Was this reply helpful? Yes No
PatricioH 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz , thanks for your reply.
The data is collected from a linear process where each machine that upload the data have their own column, that's why i need to merge the 3 rows.
In the image I uploaded, the third and only with data is the first machine from the process, the second row is the second macine and so. They'll never have data in the columns that don't represent their machine.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @PatricioH ,]

So do you simply want the ones containing data or the most recent one with data ?

Was this reply helpful? Yes No
PatricioH 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

I want to merge the ones containing data, I'll attach an example of what i want to do.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @PatricioH ,

I have to ask again - what if two contain data ?

Was this reply helpful? Yes No
PatricioH 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
There'll be not. But to answer your question I guess I want the one with the most recent data.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @PatricioH ,

Looking at it again as you do not have a date (recent) marker, this should pick up the first non-blank values

AddColumns( GroupBy( TableName, "Fetcha", "Turno", "Folio", "Diamento", "Espesor", "Ancho", "Largo", "Altura de corte", "Data" ), "Matrices1", LookUp( Data, !IsBlank('Matrices a twin 1' ).'Matrices a twin 1', "Matrices2", LookUp( Data, !IsBlank('Matrices a twin 2' ).'Matrices a twin 1', "MatricesTotal", LookUp( Data, !IsBlank('Matrices Totales' ).'Matrices Totales', "Slash", LookUp( Data, !IsBlank('Slash %') ).'Slash %', "SlashM2", LookUp( Data, !IsBlank('Slash m3') ).'Slash m3' )

Also these are based on the field names I can see, so you will need to assure they are correct.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No