Answered

Name isn't valid. 'Created By' isn't recognized. when combine two SharePoint list source into single collection

(0) Share

Report

Posted on by Community Power Pla...

We have 2 SharePoint lists with similar structure. I decide to combine them into single collection and list in a Power App gallery.

ClearCollect(CombinedReports,ReportA,ReportB);

We know all SharePoint lists have column 'Created By'. In the gallery we use 'Created By' to filter the items so that only the active user's item will be shown.

Below is working:

Filter(ReportA, 'Created By'.Email = varUser.Email)

Filter(ReportB, 'Created By'.Email = varUser.Email)

However below throw me error [Name isn't valid. 'Created By' isn't recognized. ]:

Filter(CombinedReports, 'Created By'.Email = varUser.Email)

Why?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

shoog 2,164 on at

Like (0)

Report
Merging two different lists will only keep the internal SP name of fields. In this case the internal name of the 'Created By' field is Author, you can use that on the collection (or on either of the datasources).

For your collection it would be

Filter(CombinedReports, Author.Email = varUser.Email)

Was this reply helpful? Yes No
rb 835 Super User 2024 Season 1 on at

Like (0)

Report

I find that Collecting a SharePoint list like that will sometimes force you back to using the 'real' system column names. Can you check View -> Collections to see what the column names look like for "CombinedReports"? Post a screenshot here, perhaps.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks it is working.

Was this reply helpful? Yes No