Unanswered

Combine rows with the same column value in Dataverse

(0) Share

Report

Posted on by Community Power Pla...

So I have a table and the data comes in through 2 different forms. the table has a common column and I wanted to use that as my lookup value to combine the row values.

FORM A fills in the data in columns A B C
FORM B fills in the data in columns A D E

I wanted to combine the rows based on a column - the end result should be in a single row, and all info will be combined in columns A B C D E.

Also, is it possible to add values?

1st entry - COL A = RED, COL B = 2

2nd entry - COL A = RED, COL B = 3

END RESULT = COL A = RED ; COL B = 5

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

There is nothing out of the box in Dataverse that would do this type of combine for you. You could probably create a process in Power Automate or Azure Data Factory to do what you are trying to do.

Overall you might be better off not combining the data in Dataverse and to utilize Power BI to create reporting as you require.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thank you so much @dpoggemann. I'll utilize Power BI instead. 🙂

Was this reply helpful? Yes No