Answered

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:

Tables

Microsoft Dataverse

Business Rules

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Combine rows with the same column value in Dataverse

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

Drew Poggemann 9,278 Most Valuable Professional on at

Like (1)

Report

Re: Combine rows with the same column value in Dataverse

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.