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…
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…
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)??
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…
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…
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…
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
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…
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…
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,…
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 …