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

All responses (6)

Answers (0)

jithubalan 6 on at

Like (0)

Report

Re: Power app - custom connector response

Thanks timl. is there a way that we can flatten json responses and keep it in one table.
timl 35,193 Super User 2025 Season 1 on at

Like (0)

Report

Re: Power app - custom connector response

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.
jithubalan 6 on at

Like (0)

Report

Re: Power app - custom connector response

Hi timl,
Thanks for looking into it. yes I could see the field in the collection.
timl 35,193 Super User 2025 Season 1 on at

Like (0)

Report

Re: Power app - custom connector response

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?
jithubalan 6 on at

Like (0)

Report

Re: Power app - custom connector response

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.
timl 35,193 Super User 2025 Season 1 on at

Like (1)

Report
Re: Power app - custom connector response

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