Stack Overflow
Stack Overflow

Questions tagged [powerapps-formula]

Use this tag for questions related to Canvas PowerApps formula, about the syntax, facing issues, etc

Official documentation
Formula reference index

170 questions
4
votes
1 answer

How to load all Managed Metadata values from a Term Set

Short version: How can I load all the available options for a Managed Metadata field in PowerApps? Long version: I have a PowerApps app that is working properly, but the users want to be able to add data while offline and for it to sync back when…
Pedro Lorentz
  • 1,566
  • 2
  • 10
  • 17
3
votes
1 answer

Powerapps: Splitting search text into individual strings, now I need to display on the gallery only items that include one of the strings

I have created a table in powerapps that collects the individual strings from a text input box. The table is working and as users type in the text box it creates new items down the column. Now I am trying to Filter a Gallery to only display items…
RyanS27
  • 33
  • 1
  • 3
2
votes
2 answers

Powerapps - Using a Toggle Switch with Integer Data

I'm VERY new to Powerapps. My data has integer values that are being used for 0 or 1 (no other values.) The toggle switch wants a binary value. How can i convert the reading and writing to binary to be able to work with this data type? Looking for…
jimerb
  • 47
  • 7
2
votes
0 answers

GroupBy Function NOT displaying Gallery Tiles in PowerApps

This Question is an Extension of my previous question, located here. When I use the Filter code mention in my Question. The Gallery is displaying System Names. However, when I try to wrap my Filter code with Groypby Function as mention by…
biggboss2019
  • 240
  • 4
  • 18
2
votes
1 answer

Submit button overwrites previously populated rows in excel table in PowerApps?

I am creating a form where end user can submit their form entries by clicking Submit button. The Datasource for this task is Excel table. I created 2 screens.[SEE BELOW FOR MORE UPDATE] Screen1 contains Summary of many systems (Sys1,Sys2,Sys3...) in…
biggboss2019
  • 240
  • 4
  • 18
2
votes
1 answer

Power Apps - Create Unique List of Collection

I have a collection called as TestCol and it looks like this. Name ID ToAddress Status Abc 123 asdfg@example.com,koldef@example.com,asdasdasfda@example.com A …
CodingDawg
  • 2,598
  • 7
  • 49
  • 94
2
votes
2 answers

Single Gallery from multiple sharepoint list (all same fields)

Currently my powerapp is having a Gallery which is based on a single sharepoint list but i would like to implement a gallery on my app which should show items from 3 different sharepoint lists (all have same columns/fields) and i am using a filter…
Vishnu
  • 21
  • 1
  • 3
2
votes
1 answer

How do I select a dropdown value and display other value on the label in Powerapp?

I would like to select a dropdown value and then show some other values extracted from the excel datatable on a label. For instance, if I select "Jonathan Soh" in the dropdown list, the text label will show "a". Else if I select "Peter" in the…
Jae Ying
  • 93
  • 3
  • 12
2
votes
2 answers

PowerApps: How to Patch multiple SQL tables with foreign keys?

I get a SQL INSERT error when trying to use the Patch function in PowerApps on a table, which has a foreign key that relies on the primary key of a second table that hasn't been Patched yet. Which makes sense. How could I be allowed Patch a table…
SeaDude
  • 1,647
  • 9
  • 31
1
vote
1 answer

Edit Form displaying the same id from the first row in the Gallery

I am trying to pre-populate my EditForm1 by passing on my > button via OnSelect: Set(varSelectedRecord, ThisItem);Navigate(Screen2) that sits within the Gallery1 The EditForm1 has Item: varSelectedRecord The result is the following. As you can see,…
Shoaib Maroof
  • 197
  • 1
  • 1
  • 9
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
  • 21
  • 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
  • 240
  • 4
  • 18
1
vote
1 answer

How to display only certain column values from a sharepoint list when pressed on a button tab in Power Apps?

I am creating an app in Power apps based on a Sharepoint List. Consider it has two pages.In page 1 I have 2 buttons b1 & b2. When i click on b1 it should go to page 2 & display only some of the column values in my Sharepoint list.And the rest of the…
Cyril Cereaic Joseph
  • 156
  • 1
  • 11
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
  • 61
  • 6
1
vote
1 answer

Update ForeignKey Sharepoint List using onSelect button with Patch() - PowerApps

My problem is what I describe in the title. I want to update a foreign key on my sharepoint list with a button. I have two List with OneToMany relation: User{ ID, Name, Surname} Book{ID, Title, Author, ID_User} When I go one user, with a gallery, …
ATA
  • 31
  • 7
1
2 3
…
11 12