Load SharePointList Columns into existing collection

[Sgalle]

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?

[mdevaney · Accepted solution]

@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."

[Sgalle]

Great! That worked. Thanks!

[mdevaney]

@Sgalle 

Awesome.  I am glad we solved the issue 🙂