Stack Overflow
Stack Overflow

Questions tagged [powerapps-collection]

108 questions
1
vote
1 answer

Power Apps - Create a collection

I have 4 labels defined like this, Cat10 Cat21 Cat32 Cat45 and I have 4 corresponding text inputs defined as, TextInput 10 (Takes only a number) TextInput 21 (Takes only a number) TextInput 32 (Takes only a number) TextInput 45 (Takes only a…
Student of the Digital World
  • 2,971
  • 16
  • 62
  • 116
1
vote
1 answer

PowerApps: Inserting range of numbers into SQL

I'm trying to insert a range of serial numbers into the SQL Server table. I'm using the following code but it inserts only one record: Patch('[dbo].[SerialNos]', Defaults('[dbo].[SerialNos]'), {Equipment: varEquipNo, SerialNumber: "123456", …
Mr.KLD
  • 2,632
  • 2
  • 16
  • 26
1
vote
3 answers

How do I use collect and if functions together in Powerapps?

Below is the sample canvas-app functions that I have tried, however I would like to convert the below canvas-app functions that can access collection data to use it: If("EC - Empire Complex" in BuildingDropdown.Selected.Value, Distinct(Filter(Area,…
J_Y
  • 143
  • 4
  • 16
1
vote
1 answer

PowerApps datatable lookup column won't show choices

We are building a PowerApps screen with a data table using a collection as the data source for the Items property. In our onVisible event of the screen we create the collection like this: ClearCollect( collTrackedSales, Filter( …
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
0
votes
1 answer

Power Apps Collection: How to access nested table items from collection?

What I am trying to do is paste a list of user IDs, and resolve the list to the people and then save their info to a collection and eventually write them to SharePoint. I have a multiline text input control (txtPastedText) that accepts a pasted…
U53R777
  • 3
  • 2
0
votes
1 answer

Power Apps Form Development

I want to develop a App in that many screens will be there in one of the screen one textbox will be there by clicking that box will navigate to another screen in that some options questions will be there and confirm button also there after answering…
Shiva Sai
  • 1
  • 1
0
votes
0 answers

I have a requirement in powerapps to collect all days in a month based on year and specific month

I have a requirement in powerapps to collect all days in a month based on year and specific month and i tried below…
Midhun
  • 1
0
votes
1 answer

How to convert the collection data into HTML format

I'm trying to save a collection as PDF but i can't do it directly i've been searching ways to do it and the solution i've seen most is to transform the collection into HTML and then save it as a PDF but i don't know how to do it. In Powerapps As I…
eperez
  • 1
0
votes
0 answers

How to reorder tasks marked with checkboxes in PowerApps?

in PowerApps, I am trying to move tasks that are marked with a checkbox in the gallery to the last position. Currently, my project is structured as follows: In the OnStart property of the app, I am creating a collection to add users who are divided…
Lucas Abrantes
  • 31
  • 1
  • 6
0
votes
0 answers

Create a Column to Count the Number of Occurances of Each Item in a Power Apps Collection

I am trying to count the number of occurrences of each item in a PowerApps Collection. SharePoint List Name: Product Desired Result Fruit Number of Occurrences Apple 1 Orange 1 Apple 2 Banana 1 Orange …
Kendall Outlaw
  • 13
  • 6
0
votes
0 answers

Power apps substitute for a column in a collection

I have created a powerapp logic that takes input from a textinput control and then compares the content with a collection and when matched it substitues the text with the value in the 2nd column of the collection i.e. if textinput1.text =…
Artosu
  • 23
  • 5
0
votes
1 answer

Summarization (Aggrgeate Sum) on a Grouped datasource on Power Apps, returning blanks for sum

I have done multiple examples found online, but still I get a null record for the aggregated sum variable. The code makes sense. But for some reason, when I add the collection to the gallery visual, I get the correct groups (the item number), but…
sabukaru
  • 5
  • 4
0
votes
1 answer

Count Number of Occurrences in PowerApps Collection

I am trying to count the number of occurrences of each item in a PowerApps Collection. SharePoint List Name: Product Desired Result Fruit Number of Occurrences Apple 1 Orange 1 Apple 2 Banana 1 Orange …
Kendall Outlaw
  • 13
  • 6
0
votes
1 answer

Duplicate records being added unexpectedly to my collection in Powerapps?

I am very new to PowerApps so hopefully my question is clear. I have a collection that I created called colGridData which patches new records that I create in colGridData to an online Sharepoint list. In general, this works great when the records…
Chris2015
  • 1,030
  • 7
  • 28
  • 42
0
votes
1 answer

Collect and validate text input in a gallery control in power apps

I have a gallery control in a power apps canvas application. which looks like this: and the items which I am passing to this gallery is a collection as follows: Collect( QAInputCollection, { srNo: 1, Question: "What is your…
ajinkya
  • 334
  • 3
  • 15
1 2
3
4 5 6 7 8