Unanswered

Power app - custom connector response

(0) Share

Report

Posted on by jithubalan

Hi,

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.

SortByColumns(AddColumns(GroupBy(Filter(opportunitydet
,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

Thanks

Jithesh

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi @jithubalan

Since store is a child table, it isn't possible to reference it using syntax that looks like this:

store.address.streetAddress

Instead, to reference the first record in the store table, you would use this syntax:

First(store).address.streetAddress

If address is also a table, you would use this to reference the first address address in the table.

First(First(store).address).streetAddress

Was this reply helpful? Yes No
jithubalan 6 on at

Like (0)

Report

Hi timl,

thanks for the reply. I tried this solution but not working. Problem is only in groupby. in normal statement store.address.streetAddress is working.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jithubalan

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?

Was this reply helpful? Yes No
jithubalan 6 on at

Like (0)

Report

Hi timl,
Thanks for looking into it. yes I could see the field in the collection.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @jithubalan

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.

Was this reply helpful? Yes No
jithubalan 6 on at

Like (0)

Report

Thanks timl. is there a way that we can flatten json responses and keep it in one table.

Was this reply helpful? Yes No