Questions tagged [powerapps-collection]
108 questions
0
votes
1 answer
PowerApps - For All Patch replicating only the last record in the collection (not showing other items on SPO List)
I'm using a simple collection function to collect values for four columns of my list and I'm using a data table to show those values from the collection. This works fine and table shows the values I enter. I'm then using a Submit button to patch the…
Prabhat Singh
- 1
- 1
0
votes
1 answer
PowerApps - Need to combine two collections to a single record
I have multiple columns in my SPO list and I've divided the columns in two collections.
I want to combine both collections so that it creates a single record on my SPO list.
Is there a way to do that? I tried but it created two separate items for…
Prabhat Singh
- 1
- 1
0
votes
0 answers
Power Apps Add Picture Control And Save To SharePoint Library
I have created a demo to capture a photo and upload that into the SharePoint online document library.
I have used Picture Control of PowerApps and the SharePoint document library.
I have taken reference from the below…
thedeepponkiya
- 97
- 1
- 11
0
votes
1 answer
Re-write ShowCollums formula on PowerApps
I have an app based on MS PowerApps connected on a PowerAutomate flow.
My question is: how can re-write this code by showing more than 2 collections using (or not) the formula ShowColumns?
I have to show a collection named "collection_output" and…
Caio
- 1
0
votes
1 answer
powerapps give an error of during saving to SQL database
Patch(
SOP10100,
First(Filter(SOP10100,SOPNUMBE=SOGALLERY.Selected.SOPNUMBE)),
{CUSTNAME:TextInput3.Text},{CUSTNMBR:TextInput4.Text},{SOPTYPE:Value(DataCardValue15.Text)},
…
Desmond Sim
- 211
- 2
- 19
0
votes
1 answer
Power Apps Component
I have started working on components in Power App, and noticed that when you want to create the Component Library I have a (preview) next to it. Also, when I create a component and I tab over to screens screen, the only screen usable is for mobile…
MarkoL
- 1
- 1
0
votes
0 answers
In PowerApps, how can I copy records from a SharePoint list to a collection, edit, then save back to the SharePoint list as new records?
I am trying to copy a set of records filtered from a SharePoint list to a collection so that they can be edited and then saved as new records in the same SharePoint list. My current solution is not creating copies of the original records, but…
0
votes
2 answers
Navigate between screens based on checkbox value on power apps
I want to navigate between screen in my application power app, the first screen is this :
enter image description here
And based on the checkbox selected, i want to navigate to it. And also navigate between the for screens if more than checkbox is…
ZK007
- 1
- 5
0
votes
1 answer
Powerapps - Split Collection into smaller Collections based on SQL lookup data
-=-=-=-=-
Edit #3
Okay, this is just baffling as heck.
I've narrowed this down to one single line...
A sample of my code, with three examples:
ForAll(ScanDataCollection_SmartComm_MasterList,
If(
// line 1 …
Edward Martin III
- 93
- 1
- 13
0
votes
2 answers
Convert Columns to Rows in collection power apps
How to convert from this collection:
to like this:
Imad
- 31
- 1
- 6
0
votes
2 answers
How to add a column filtering data from another collection in power apps?
I have two collections in power apps:
users:
enter image description here
colAppRoles:
enter image description here
And I want to add a column with the displayN of each role from the colAppRoles collection where appRoleId of users is equal to the id…
Imad
- 31
- 1
- 6
0
votes
0 answers
PowerApp Datavserse
Can we create specific rows access in a table for different users?
for example, if we have different departments, can we give access to x department-related entries to one user and y department-related entries to another.
SandyX
- 21
- 1
- 6
0
votes
1 answer
Lazy loading of items from SharePoint instead of Eager loading to avoid delegation warning
I have 2 SharePoint lists:-
Task list .. with these fields:-
ID
Title
PeopleWork list.. with these fields:-
ID
TaskID .. This should store the Task ID from the Task list in numeric format
Single selection people/group field named…
John John
- 1
- 72
- 238
- 501
0
votes
1 answer
How do I add a dropdown column to my collection in PowerApps?
I have a gallery connected to an Excel table. I want to add some of the gallery columns to a collection.
I am doing-
ClearCollect(Attgallery,ShowColumns(Gallery3.AllItems,"Name","Language","Mentor","Type",Dropdownatt.Selected.Value));
The last…
Pete
- 309
- 1
- 4
- 11
0
votes
2 answers
PowerApps Filter gallery based on input text lookup from relational sharpoint list
here I'm working on PowerApps I have 2 SharePoint lists one is challan list and one is challan details and I combine both in one gallery using the lookup function Eg:
LookUp('Challan List',ID=ThisItem.CListID,Title)
so for that I user multi…
Ashit Jadvani
- 11
- 1
- 2