Hi All,
I'm trying to get the user input and save it as collection and then when there are 5 records or more collected, I want to save them to my SharePoint list.
I have tried this using collect function put seems like not working.
Can anyone help or suggest any idea?
Please see the work i have done so far to get this.
On add collection Button:
OnSelect Property:
Collect(
Records,
{
'Catering&HouseKeeping': DataCardValue49_2.Text,
'Casual_Transport': DataCardValue50_2.Text,
EquipmentShortLife: DataCardValue51_2.Text,
ProgrammeLifeSkills: DataCardValue52_2.Text,
'Cleaning&Household': DataCardValue59_2.Text,
'Medical&FirstAid': DataCardValue61_2.Text,
Heat: DataCardValue62_2.Text,
Total: DataCardValue12_1.Text
}
);ResetForm(GLForm_1);
On Save Button:
OnSelect Property:
Collect('Description and GL Code', Records);
On Clear button:
OnSelect:
Clear(Records)
Also please see the below screenshot as an example to detail .
Any advice or suggestion is much appreciated by you all.
THanks
Solved! Go to Solution.
Am not sure of your columns names now after you corrected them, the this is the structure:
I can see single quotes where there are no spaces in the column names, remove them. Also & is reserved so if yo can avoid using it in your column name. You can replace it with _
@Tapesh did you manage to resolve your challenge?
In your query you had something about number of records equals or greater than to enable option to submit data - do you need help with this part of your app?
Regards
Dawid
Hi, Yes please would liek to know where im wrong so that i do not repeat the same mistake again and how will this be avoided
Sounds great will give it a try and see if this works or not. Thansk Sir
Collect('DescriptionandGLCode',Records);
This thing worked well and there is no error but when i click on SAVE collection to sharepoint list why is this not able to save to the given list? you have any idea how can this be done or what is the issue here?
Hi @eka24
No Change the result is same, i still can not see details on the my sharepoint list.
Also as you said try to avoid quotation mark as much as i can i changed the whole list name and rename the columns in my SPList and also the list name.
Please see the screen shot of SPList and also of current Powerapps where the collection is used.
Am not sure of your columns names now after you corrected them, the this is the structure:
I assume this will work, but just want to clear something with you, is it compulsory to add all the columns which are present in the patch function?
or it is okay that only what i want i can update?
i m actually confused on how this patch works, cause many times i want to use this but i feel that we must have to pass all the column names and value. which i feel is **bleep**. sometimes i only use a few of them.
what is your suggestion on this?
User | Count |
---|---|
119 | |
86 | |
83 | |
74 | |
69 |
User | Count |
---|---|
215 | |
179 | |
141 | |
109 | |
83 |