How to use Addcolumn with lookup field in the SharePoint List

[OsmandFernando]

Hi

I have a salesdetails_1 Sharepoint list and I am trying to create a collection using it. 

What I am trying is to get the Brand Name and Total Invoice Value to a collection. The Brand name is a lookup coming from Item master to the Salesdetails_1 list. When I try it says Band Name does nor exist

How can I overcome this?

Osmand

[Anonymous]

@OsmandFernando try some of the solutions from here

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/How-to-use-clear-collection-to-get-...

My first guess would be "Brand Name" is your "Title" column in SP so try using that instead?

Also, I think LookUp columns need a .Value added when using them

eg yourLookUpColumn.Value

Not 100% sure because I deliberately avoid using special column types in SP as they tend to cause issues in PowerApps ... although, these issues aren't unsolvable, just time consuming to find solutions.

[OsmandFernando]

@Anonymous Thanks for your reply. I am sorry for the delay as I was notified since it was not @ at me. 

Brand Name is not the Title, you can see from my screen shot earlier, the title field is also there. 

On the othehand, I can not do .value in the clear collection. How can I do that?

Thank you again

Osmand

[PowerAddict]

First use AddColumns to add a column that populates the Brand Name and then use that in GroupBy. Let me know if this doesnt help and I can give you an example.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[OsmandFernando]

@PowerAddict 

Thank you so much for replying

ClearCollect(SalesforAnalysis,AddColumns(GroupBy(SalesDetails_1,"Band Name")

I am lost after that.....

Osmand

[PowerAddict]

You need to add that AddColumns inside of GroupBy. Give me sometime and I will give you the exact formula if you dont get it by then.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[OsmandFernando]

Thank you @PowerAddict  I will wait for you

Osmand

[OsmandFernando]

@PowerAddict , I tried the following,

Did not find any error but collection output is not what I want. 

Because when I am trying to create a chart using the SalesbyBranNameFinal collection, Band is not available yo select as labe

ClearCollect(SalesbyBrandName,AddColumns(GroupBy(SalesDetails_1,"Total_x0020_Value","Grouped"),"Brand Name",Grouped.'Brand Name',"TotalSales",Sum(Grouped,Total_x0020_Value)));ClearCollect(SalesbyBranNameFinal,ShowColumns(SalesbyBrandName,"Brand Name","TotalSales"));

Osmand

[PowerAddict]

Apologies for the late reply. The easiest way to check is to view the collection. If you go into the collection, what records do you see? More importantly what columns do you see in your SalesbyBrandName and SalesbyBranNameFinal collections?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://www.thepoweraddict.com

[OsmandFernando]

@PowerAddict , Thank you for your reply, 

This is how I see,