Stack Overflow
Stack Overflow

Questions tagged [powerapps-formula]

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

Official documentation
Formula reference index

338 questions
4
votes
2 answers

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
  • 2,146
  • 2
  • 13
  • 19
3
votes
2 answers

How to find integer and text values (Filter & Search)

I have my data source connected to database in SQL Server through an application in Power Apps, I am making use of Gallery to display the data and I have a text entry to search for specific data in that gallery. I would like to perform the search…
user15500092
3
votes
2 answers

Can we get Active Directory property named Employee ID using Office365Users connector inside Power App

Inside our active directory we have a property named "Employee ID" as follow:- so inside our PowerApp form i want to get the value of this property,,, but i checked the Office365Users connector @…
John John
  • 1
  • 72
  • 238
  • 501
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
3
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…
J_Y
  • 143
  • 4
  • 16
2
votes
2 answers

Why is my conditionally required field required, even when the condition is false?

I have an "On/Off" field (default is Off). I have a text field, which is Hidden when my On/Off is Off. When it is On, the text field is visible and mandatory. However when I try to submit form, with On/Off being Off, the form returns error saying…
Jens-Emil
  • 56
  • 8
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
  • 67
  • 9
2
votes
1 answer

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
  • 220
  • 3
  • 8
  • 30
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
  • 220
  • 3
  • 8
  • 30
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 …
Student of the Digital World
  • 2,971
  • 16
  • 62
  • 116
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
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
  • 3,725
  • 6
  • 31
  • 68
1
vote
1 answer

How to show combo box values to textbox with next line

I have one ComboBox in which there are multiple values are selected I want to show that values in TexBox with next line like AAA BBB CCC Currently its show in one line AAA | BBB | CCC I use bellow code DataCardValue4.Selected.Value on Default…
Abdul Farhan Muhammed
  • 23
  • 3
1
vote
1 answer

How do I submit a SharePoint form, at the same time I want to upsert the description of a hyperlink column of it that I wrote inside a textbox in PA?

This question is a follow up of How do I get the display name of a hyperlink that comes from SharePoint in Power Apps? Here is the code I used at the On Start of the App: Set(AllFavorites;…
Marcelo Marcolino
  • 13
  • 5
1
vote
1 answer

How do I change the default value of a dropdown field based on a button in Power Apps?

On my home screen in Powerapps, I have 8 buttons. Each button states a category. What I want is that by selecting a certain button it makes the value automatically be filled in on the dropdown field of categories on the next page. I have already…
Luke Coopman
  • 21
  • 2
1
2 3
…
22 23