I have created custom connector to call rest api end point and storing the response in the collection. collection is having multiple table inside it like nested tables. I am able to pull the fields by using "." but this is not working when I use it inside the grouping.
,input_Search_Store_2.Text in store.address.streetAddress),"store.address.streetAddress","completionStatus","storeLocation","name"),"sumTotal",Sum(name,opportunityDollarSizeRetail)),"sumTotal",Descending)
getting message that "specified column store.address.streetAddress does not exist. the column with most similar name is "store"
any help here is appreciated
Since store is a child table, it isn't possible to reference it using syntax that looks like this:
Instead, to reference the first record in the store table, you would use this syntax:
If address is also a table, you would use this to reference the first address address in the table.
thanks for the reply. I tried this solution but not working. Problem is only in groupby. in normal statement store.address.streetAddress is working.
The error message is saying that the column divisionRepresentative doesn't exist.
If in the collection's view, you click into the store cell, can you confirm what you see? Can you see a result set that includes the column divisionRepresentative?
The issue here is that it's not possible to group data using the syntax "(First)store...".
The argument to the GroupBy function expects a column name, whereas First is a function.
Perhaps you could describe what you want to sum, and the full data structure of your custom connector response.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!