Unanswered

SharePoint List to collection issue (What in the id10t did I do wrong)

(0) Share

Report

Posted on by Community Power Pla...

The top table is loaded from my Sharepoint Litst. The bottom table is the collection that the list was loaded into. Im just doing the clearcollect function.

What did I break?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

AsanKani 710 on at

Like (0)

Report

Hi @Anonymous
Let me know the error message and what here you do explain more...

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

Like (0)

Report

The issue is that the content fields aren't matching up.

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

Hi @Anonymous

You are using Bottom table with collection. Let me know the Collection coding where to collect. and where to use clear collect?

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

Like (0)

Report

yes the bottom table is directly showing the collection created by Collect(inspectors1, 'Livestock Inspectors')

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

Hi @Anonymous

Ok. Where to use ClearCollect function?

You can directly use ClearCollect(inspectors1, 'Livestock Inspectors'). What do you say ?

Still you are not give enough data... like below
Collection used data Livestock inspectors from where?
Why/where you used clearcollect function? what is the purpose?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways or you liked the post and want to show some appreciation, please give it a Thumbs

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

Like (0)

Report

Hi @Anonymous ,

Is that a screenshot from DataTable or Gallery control in your application? Wich displays records from the List and Collection respectively?
If yes, then you can't display Author or Editor directly in the Label fields of DataTable or Gallery.
You have to use either Author.DisplayName or (Email, claims, Jobtitle, Department, Picture (in image control), etc. ) of the Author or Editor to display it on the table.
(ex. ThisItem.'Created By'.DisplayName &
ThisItem.Author.DisplayName &
ThisItem.Author.Email &
ThisItem.Author.Department, etc.
).
If there is any Lookup or choice field then append ThisItem.FieldName.Value
Refer screenshot below,
There is no error in "ClearCollect(CollectDemo,TestDemo)" here "CollectDemo" is Collection & "TestDemo" is List.
___________________________________________________________________________________________________________________________________
If this post helps you to resolve your issue, then mark it as an answer/ solution for future reference.

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

Like (0)

Report

The top data table is directly refrencing the sharpoint list

the second is referencing a collection that was built using the clearcollect control and the list.

if you look the bottom table doesn't have the correct field names instead it's feild_1 feild_2 .....

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

Like (0)

Report
Hi @Anonymous ,
Refer to my previous reply.
I suggest you verify column names in the collection (From the view tab => select collections=> verify Fields names in your Collection.)
Consider your Fields name is field_1 (Single or Multiline Text field ) then ThisItem.field_1 will be the text property for the respective column inside your Data Table/ Gallery.
If it is the Person column then ThisItem.field_1.DisplayName or ThisItem.field_1.Email will be the text property for the respective column.
If it is the Choice or Lookup column then ThisItem.field_1.Value will be the text property for the respective column.
___________________________________________________________________________________________________
If this post helps you to resolve your issue 👍, then mark it as an answer/ solution ✔️ for future reference.

Was this reply helpful? Yes No