Hi, everyone
I got this problem that I would expect to be easy to solve but has been impossible for me to do for the past two days.
I want to add the column of another table to my main table such that:
{
MainTable: [
{
"Names": "John Doe",
"loginName":"john.doe",
},
{
"Names": "Jane Doe",
"loginName":"jane.doe",
}
]
}
{
Hours: [
{
"WorkedHours": 120.00
},
{
"WorkedHours": 115.50
}
]
}
becomes a single collection like this:
{
MainTable: [
{
"Names": "John Doe",
"loginName":"john.doe",
"WorkedHours": 120.00
},
{
"Names": "Jane Doe",
"loginName":"jane.doe",
"WorkedHours": 115.50
}
]
}
Collect will just add the rows. AddColumns seems incapable of taking data from other tables. Update writes over the whole row. I read that Patch could do it but that I needed an anchor column so I went to the trouble of creating a Index for those two tables with this guide http://powerappsguide.com/blog/post/generating-row-numbers.
But Patch doensn't add them. I honestly don't know what to do.
