Answered

Name isn't valid. This identifier isn't recognized

Like (0) Share

Report

Posted on 6 Jul 2020 04:46:04 by Community Power Pla...

Hi All,
I want to get data from nested collection but there is an error "Name isn't valid. This identifier isn't recognized".

But if I try the solution on this link(Understanding Nested Collections) there are no error

Any help is appreciated. Thanks in advance.

Categories:

General Questions

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-yutliu-msft on 07 Jul 2020 at 03:10:02

Like (0)

Report

Re: Name isn't valid. This identifier isn't recognized

Hi @Anonymous ,

Please notice the collection structure in the link that you provided.

Every level only has one record.

That's the reason why he could connect so many level relationship by using "table.field.field.field.field".

Please distinguish whether there's nested record or nested table.

For nested record, you could directly use tablename.fieldname to get all nested value.

For nested table, you need to use ForAll function to get all nested value.

In your issue, some levels are not nested record.

I will answer your question more detailed here:https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-get-data-from-nasted-collection/td-p/615887

Let us discuss there. Please change your this issue's status to "Answered".

Thanks!

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on 07 Jul 2020 at 02:51:13

Like (0)

Report

Re: Name isn't valid. This identifier isn't recognized

Hi @v-yutliu-msft,
ya, In my case I could not 3 or more relationship. but why the solution on this link ( Understanding Nested Collections ) can be up to 3 or more relations?

Was this reply helpful? Yes No
v-yutliu-msft on 06 Jul 2020 at 09:50:18

Like (0)

Report

Re: Name isn't valid. This identifier isn't recognized

Hi @Anonymous ,

The reason why you met this problem is that:
it's not supported to connect too many relationship by using "fieldname.fieldname.fieldname".

Usually, at most 3 level relationship.

Your issue need other solution to get value from 5 level nested table.

I notice that you've posted another same issue, please check my answer there:

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-get-data-from-nasted-collection/td-p/615887

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on 06 Jul 2020 at 05:28:07

Like (0)

Report

Re: Name isn't valid. This identifier isn't recognized

Hi@eka24
yes I checked again and the spelling is correct.
By the way I got this nested collections from the Office365.FindMeetingTimes() function.

Was this reply helpful? Yes No
eka24 20,921 on 06 Jul 2020 at 05:12:56

Like (0)

Report

Re: Name isn't valid. This identifier isn't recognized

Please recheck if Availability column is rightly spelt or the column exist or was recently added.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No