Stack Overflow
Stack Overflow

Questions tagged [powerapps-canvas]

PowerApps Canvas allows creating Microsoft PowerApps visually on a canvas via drag & drop. Also add the general [powerapps] tag to your question.

PowerApps Canvas allows creating Microsoft PowerApps visually on a canvas via drag & drop.

525 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

Can a Azure function write back data to synapse database

I am new to azure stack, so my please bear with my question. I have a synapse database and I have a powerapp that reads data from synapse database. So, powerapps cannot writeback to synapse database. So I am thinking of developing a azure function…
Suel Ahmed
  • 63
  • 5
1
vote
1 answer

Filter formula: "The requested operation is invalid"

I am starting with PA and I am following several tutorials and the docs. Currently I get this error in my OnStart event of the app: The requested operation is invalid. Server Response: LocalizedTexts failed: Expression "locale eq null" is not…
Oliver Busse
  • 3,375
  • 1
  • 16
  • 26
1
vote
2 answers

SharePoint document library not showing actual user's name in 'Modified By' on Custom List's meta-data

I have created an utility for browsing and uploading file from user's machine (OS is Windows10) to a SharePoint site's document library. This utility is created using 1. a canvas form created in Power App, 2. a workflow created in Power Automate and…
Chetna S
  • 11
  • 4
1
vote
1 answer

How to SWITCH Power Apps Data Connection in Canvas App

I have a canvas app that uses a SQL Server Data Source connection. In my Power Apps environment, I have created a second SQL Server Data Source connction. How do I update my canvas app to use the second SQL Connection instead of the original one it…
Tim T
  • 140
  • 2
  • 11
1
vote
0 answers

Add filter conditions in PowerApps Filter dynamically

I have a combo box and in the filter formula one of my conditions is to filter records from a SQL data source where the column value is same as the one selected in the combo box. I have implemented that. Then the requirement changed to make it the…
Yash Tamakuwala
  • 1,789
  • 1
  • 24
  • 33
1
vote
1 answer

Powerapps: Edit form of related record

This is an overview of the data model. I have one table fo Course slots, one Table with Participants and one Table where I book the Participants to a Course slot. On the canvas app, the user enters to see the list of courses in a gallery, using the…
Sara de Hond
  • 21
  • 2
1
vote
1 answer

Store a manipulated collection in Power Apps

(1) In my Canvas App I create a collection like this: Collect(colShoppingBasket; {Category: varCategoryTitle ; Supplier: lblSupplier.Text ; ProductNumber: lblProductNumber.Text });; It works - I get a collection. And whenever I push my "Add to…
ToFo
  • 1,643
  • 1
  • 19
  • 34
1
vote
2 answers

PowerApps collection function results in [object Object]

I have a Text input as: 'Topic', 'Date'. and dropdown as: 'EmployeeID', 'EmployeeName' these values Distinct(employee_table,EmployeeID) and Distinct(employee_table,EmployeeName) using a generic Collect function Collect(List, {Topic: topic.Text,…
spartan123
  • 49
  • 8
1
vote
1 answer

PowerApps Filter Items from Last Week

I'm trying to filter a PowerApps gallery to only return SharePoint items that have a date field with a value equal to last week. My formula is returning an error so I was hoping if someone could kindly help? Filter…
alexthannah
  • 109
  • 2
  • 8
1
vote
0 answers

How to Handle SQL connection reference in Power Apps ALM using Azure Devops CICD?

I have developed a power app which has Azure SQL Database as the Data Source. I want to move this app to higher Environment using Azure Devops. I am able to successfully import the App using Azure Devops but I am unable to handle the SQL Connector…
Robinhood
  • 92
  • 2
  • 10
1
vote
0 answers

How to pass current opportunity in which I am working into canvas app Gallery

I have developed one canvas app for searching reference Accounts and add them to opportunity. I have connected my canvas app to opportunity form but it is not automatically selecting the current opportunity rather showing all my opportunity in the…
Amandeep Singh
  • 11
  • 4
1
vote
0 answers

I'm trying to turn lookup function outcome into text in powerapps

this is the code LookUp(database, 'id-code' = scannerRes, level).Value and I want the outcome to be a text format. note level is a choice column in a SharePoint list and scannerRes is a var set in a scanner. plz, let me know what you think.
Haz-MatPLz
  • 31
  • 6
1
vote
0 answers

Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown

I am creating custom connector in PowerApps to connect to SharePoint Online (not allowed to use default connectors). I created an registered an app in Azure AD, gave it "Have full control of all site collections" permissions to SharePoint…
gokulnath
  • 23
  • 4
1 2 3
…
34 35