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?
Solved! Go to Solution.
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."
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."
Great! That worked. Thanks!
User | Count |
---|---|
247 | |
103 | |
82 | |
49 | |
43 |