web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Load SharePointList Co...

Power Apps

Answered

Load SharePointList Columns into existing collection

(0) Share

Report

Report

Posted on by Sgalle

28

Hello,

I have an app with a titlefield, a gallery and two buttons (save, load).

When I want to load the listdata (depending on the titlefield) I use following code:

Clearcollect(HoursCollection; Showcolumns(Filter(SPlistHours; Title = AppTitle.Text); "Title"; "Hours")

In the Collection I already have the columns 'ColTitle' and 'ColHours'. So I want to load the Title and hours in those existing columns.

How can I do that?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Sgalle

If the issue is simply that your column names do not match you can use RENAMECOLUMNS.

ClearCollect( HoursCollection; RenameColumns( Showcolumns( Filter(SPlistHours; Title = AppTitle.Text);"Title"; "Hours" ); "Title","colTitle", "Hours","colHours" )

Please show me a sample of what the collection looks like before the changes and after the changes if my suggestion is not what you wanted.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Sgalle 28 on at

Like (0)

Report
Copy link

Link copied!

Great! That worked. Thanks!

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Sgalle

Awesome. I am glad we solved the issue 🙂

Was this reply helpful? Yes No

Join the conversation