Questions tagged [powerapps-collection]
108 questions
1
vote
1 answer
How to extract sections from a string to create a collection
I've got a string from a gallery field (galMyData.Selected.People) in the format-
lastName1, firstName1 (email@somedomain.com) - Dept1 Dept2 Dept3 ; lastName2, firstName2 (email2@somedomain.com) - Dept1 Dept3 ; lastName3, firstName3…

Chris G.
- 329
- 4
- 17
1
vote
1 answer
combine 2 data sources and display data on single table in power apps
work environment : power apps
data source : employee table and department table in sql server.
the problem scenario :
please, have a look on the diagram :
as per the diagram I want to display a table on the simple canvas app
which is a…

ajinkya
- 334
- 3
- 15
1
vote
1 answer
retrieve Value from SQL Table using powerapp
I have 3 form inside the screen which are
Period form
It display a period
(that table have a field 'aphid')
Activity form
It display the Activity Sequence and Description
(that table have a field 'actid')
Week Form
I want to retrieve the…

Desmond Sim
- 211
- 2
- 19
1
vote
1 answer
Prepopulate the ComboBox using comma-seperated String
The string looks like:
teststring = "Sunday,Monday"
In combobox's DefaultSelectedItems when I write like this, it works.
How can I make this kind of format dynamically using the above teststring (even when teststring changes to something else)??

Prakhar Gupta
- 71
- 6
1
vote
1 answer
Expanding Record columns containing SharePoint person/group info
I'm trying to create a collection that contains information from a SharePoint person/group column. So far, I have a few columns of interest added to a column, one of them being the person/group:
What I would like to do is get the DisplayName from…

Zach H
- 130
- 1
- 14
1
vote
2 answers
If function with multiple conditions doesn't return proper value
I recently started with Power Apps and one of the very first app I am building is a Body Mass Index (BMI) calculator. I was able to set it to automatically convert from Kg to pounds and cm to feet.
The problem I am facing now is outputting the…

Babatunde Victor
- 91
- 9
1
vote
0 answers
Selenium with Power Apps
We have a client requirement to implement a test automation in Power apps.
Power apps has its own Testing framework but that is still in Experimental mode and not recommended to use for production environment.
I've experience around Selenium but I'm…

Sayali
- 51
- 1
- 1
- 7
1
vote
1 answer
How to update color change of TemplateFill in a Gallery in PowerApps?
I have 2 screens and DataSource is Excel Table. Screen 1 contains Gallery of Systems, and the TemplateFill property of Gallery is set to below code.Below code is filling System tile according to their previous status. Now, in Screen 2 I have signup…

biggboss2019
- 220
- 3
- 8
- 30
1
vote
0 answers
Merging two similar records in powerApps
I've a collection as shown in the Image:
Now i have to merge both Sharepoint;Nintex and Nintex;Sharepoint into one record in final collection i.e as SharePoint;Nintex by removing the duplicate Nintex;SharePoint one

Radhakrishna .T
- 63
- 1
- 7
1
vote
1 answer
Converting concatenated text to columns in a table
So, I've inherited this beast of a PowerApp that does something relatively simple, collects responses to dynamic quizzes created in the app. The operator creates questions (which adds items to a SPO list) and then sends the quiz out to folks who…

ChrisPEditor
- 215
- 2
- 12
1
vote
2 answers
Fetching large data from SQL server using Powerapps and writing to Azure blob storage
I am trying to fetch data from a view in SQL Server using PowerApps. However, the gallery is not showing more than 100 rows and my view has almost 100000 rows. I found out that the gallery uses lazy loading and so will load only a few items at a…

antony.ouseph.k
- 907
- 2
- 15
- 28
1
vote
1 answer
How can we set permissions in Powerapps such that the creator of an application only can access the application within the enivironment?
In Microsoft PowerApps within a environment there will be many users. each one create their own application. in that case i need that , a single user should only see the application created by him within the environment.How can we set that…

Cyril Cereaic Joseph
- 268
- 5
- 14
1
vote
0 answers
Gallery with multiple listboxes automatically generated from a Collection
I am trying to create a Gallery that contains multiple Listboxes from a Collection. I have a collection called Ideas, and it encompasses ideas from different participants. I am able to create a Listbox out of each participant with their ideas.…

Jonathan Budez
- 226
- 1
- 3
- 12
1
vote
0 answers
PowerApps - Code Affects Performance of the Application because of Duplication of If else Loops
I have a piece of code that saves the Item only when needed.
Here is the Code,
//identify the required organization and Dropdown value
Set(requiredOrganization,Organization.Selected.OrganizationName.Text);
Set(DropdownValue,…

Student of the Digital World
- 2,971
- 16
- 62
- 116
1
vote
1 answer
Power Apps - Send Email To the List of Users from Collection Using Flow
I have a collection called as requiredCol_1 like this,
Name ID ToAddress Status
Abc 123 asdfg@example.com,koldef@example.com,asdasdasfda@example.com A
Def …

Student of the Digital World
- 2,971
- 16
- 62
- 116