@LNeaga_Next
I'm not entirely sure what your collection is based off of in regard to the gallery as none of your formulas indicate how you are collecting information into it.
Your Gallery already is a table/collection of the values you need, but since you're duplicating the data into another collection, please consider changing your Formula to the following:
Collect('Timesheet Details',
ForAll(CollectionTimesheetDetails,
{'Employee Email': varUserName.Email,
'NUME ANGAJAT': varUserName.FullName,
DATA: DatePicker.SelectedDate,
'TASK BY COMPANY': 'Task_ Dropdown'.Selected.Value,
'TIME ALLOCATED(hours)': 'Time_txt input'.Text,
OBSERVATII: 'Observatii_txt input'.Text
}
)
)
Now, even in this replacement formula, you will only get the first value of the gallery if you are referencing the controls of the gallery in the above. Again, I am not clear on what is what in your app as I don't have a clear picture of everything you have.
Again though, your formula should be based on the Gallery and it would go like this:
Collect('Timesheet Details',
ForAll(YourGallery.AllItems,
{'Employee Email': varUserName.Email,
'NUME ANGAJAT': varUserName.FullName,
DATA: DatePicker.SelectedDate,
'TASK BY COMPANY': 'Task_ Dropdown'.Selected.Value,
'TIME ALLOCATED(hours)': 'Time_txt input'.Text,
OBSERVATII: 'Observatii_txt input'.Text
}
)
)
Also, in both of the above, I replaced the SelectedText property you had on the dropdown with Selected.Value. Now Value may not be correct based on your Items property of the dropdown, but you should replace that with the appropriate column from the dropdown items table. The reason is that you should avoid the use of SelectedText as it is a deprecated property at this point.
I hope this is helpful for you.
