Questions tagged [powerapps-collection]
The powerapps-collection tag has no usage guidance.
powerapps-collection
118
questions
0
votes
2
answers
26
views
PowerApps ClearCollect with GroupBy not working OnVisible
I have a primary SharePoint list (Over-Rides) and a secondary SharePoint list (Over-ride Authorisations) which can contain multiple lines relating to the primary list ID (Called OverrideLogNo in the ...
0
votes
0
answers
30
views
Power Apps Patch truncating at 55 rows
Power app patch issue.
Have a gallery with 3 fields with a simple patch to SharePoint list:
ForAll(
Filter(
IS2_Gallery1.AllItems,
!(IS2_Checkbox_Delete.Checked)
),
Patch(
...
0
votes
0
answers
53
views
In Power Apps, is there a way to use the PATCH function for updating time in a hh:mm AM/PM format?
I'm trying to create a Power App for updating the hours of operations for a business. The app is connected to an excel sheet on Onedrive. Things seemed to be coming along very well until I tried to ...
0
votes
0
answers
285
views
How to manually add a value to data source with combo box in Power Apps
The items in my Combo Box are being fetched from my data source. But how do I allow the user to manually enter an option in my Combo Box?
This option should then be saved in my data source.
I've ...
1
vote
0
answers
166
views
Advice using patch within a FORALL in power apps
I am developing a power app with a collection containing 2 columns(ID, Choice) I also have a SharePoint list holding more columns including those 2. On a button press, I want to iterate through the ...
0
votes
1
answer
17
views
How to rearrange dependent dropdowns in power apps
How to rearrange dependent dropdowns in power apps?
I have tried to rearrange through the fields option. I could not find any formula to align the dependent dropdowns.
0
votes
0
answers
151
views
How can I format a label or text box to receive currency values using decimal places correctly?
How can I correctly format a label or text box to receive currency values using decimal places?
I have an Excel spreadsheet that acts as a database with financial values for a series of costs.
From ...
0
votes
2
answers
447
views
[Object][Object] Error Sharepoint Power App Table
I have the following error when inserting a Table into Power App.
The reason is that Composition is a choices Column and so is effectively a table within a cell.
Looking online there do appear to be ...
0
votes
0
answers
52
views
Collections disappearing values when changing values in dropdown
I have a collection with 40+ columns. Everything works like it should except when I modify the values. When I change the Risk value, the other dropdowns may lose its value.
The screenshot is showing ...
0
votes
2
answers
452
views
How to know if a value has been changed in a collection in PowerApps?
I have built an editable gallery which is populated and jandled by a collection - MyDataCollection. How can I check if any changes are made into the gallery, as I want to restrict the users from ...
2
votes
2
answers
66
views
Power Apps, need Key field during merge of 2 collections
Currently I have 2 collections that are merged together into 1:
ClearCollect(
colCombined,
ForAll(
Sequence(CountRows(colSource)),
Patch(
Index(
...
0
votes
1
answer
863
views
Filter many to many relationship in Canvas app using Power fx
I have two tables 'Vehicle' and 'Vehicle Features' which has N:N relationship. I have a combobox to select multiple 'Vehicle Features'Combo box to select multiple Vehicle Features.
I want to filter ...
0
votes
0
answers
70
views
Filter a share point list by another list in power apps
I've organized a list that includes a 'Person' column with details such as 'Employee' and 'EmployeeId'
Additionally, I have another list that captures 'EmployeeId' and their corresponding ...
0
votes
2
answers
2k
views
How to change attachment file name in Power Apps?
I'm trying to change the file name of an attachment in an attachment control. So far, I've followed a solution from online thread.
I used this script in the OnAddFile of the Attachment DataCardValue ...
0
votes
1
answer
958
views
Using collection and lookup in PowerApps
Attempting to better my coding ability here as I have used ineffective code that made sense to me instead of efficient code that I couldn't make sense of. I'm doing this retrospectively and I've ...