655 questions
0
votes
0
answers
44
views
Access nested table in ForAll loop
I have a collection colPendingChanges and it has multiple rows. Each row has multiple fields and one of them is AttributeTable which is a nested table.
colPendingChanges =
[
{fieldA: 'foo',
filedB:'...
0
votes
0
answers
54
views
Clicking on a button inside a Power Apps gallery will referecne the row below on published app at certain stage of my code execution
I have 2 SharePoint online lists:-
SpareParts
SparePartIndividual which store the spare part Id for parent item inside a column named "Spare Part ID".
The Power Apps canvas's gallery has a ...
0
votes
0
answers
28
views
Power Automate to pick up URL of site it is run from
I am developing a SharePoint online permissions app so people can request and approve permissions to document libraires. I have everything working but the request part it currently picking up the ...
0
votes
1
answer
61
views
Using PowerApps trying to populate a dropdown with SQL Server
I have connected to my SQL Server, but I can't see to get the formula to work. I am trying to get the names of the people who have the specific skill codes and are not terminated. Also, trying to sort ...
0
votes
0
answers
224
views
How do I set the selected value of a radio button in PowerApps?
I am using Power Apps to create a form. The default Form control is not great and does not give you the flexibility to separate questions with a banner, for example. Additionally, forms don't do well ...
0
votes
0
answers
119
views
Expense_ClaimMileage failed target table DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause
I am creating two identical applications, one is authored in PowerApps and the other is a Blazor server application. I created a common stored procedure for both.
Everything is working fine in the ...
1
vote
0
answers
53
views
Patching a person column from a single select combobox in power apps
I'm trying to patch person column on click of a button using the below code
Patch(
evListDriverLicence,
Defaults(evListDriverLicence),
{
Driver: {
'@odata.type':"#...
0
votes
1
answer
148
views
The multi-attachment file upload in Power Apps is not working on iPad, but it is working correctly on Android devices
I have created a Power Apps application where users can upload multiple attachments using the Add Attachment control. The functionality works perfectly on Android devices—I’m able to select and upload ...
0
votes
1
answer
214
views
The multi-select Dependent ComboBox fails to retain or correctly patch defaultSelectedItems values to the SharePoint list, unlike other controls
I’ve built a form in Power Apps that includes 10 different types of controls, all of which receive their default values from a SharePoint list. This setup allows users to review the pre-filled details ...
3
votes
1
answer
224
views
PowerApps: how to display real value from table in Canvas app
I'm working with my first Canvas App to display filtered data from Dataverse table. I decided to go with Canvas tape as I need to add more functionality to this view.
Can see on the pic my structure, ...
1
vote
1
answer
170
views
Why Patch() doesn't work when trying to write data back to SQL Database?
I work in Fabric environment (Premium) and also have premium PowerApps license. I have a table in Fabric SQL Database. I created PowerApp which main purpose is to write data back to SQL db table (in ...
0
votes
0
answers
38
views
How to delete a folder in Azure Blob Storage container, from PowerApps
Using my PowerApps, canvas app, users are able to upload files to Azure Blob Storage in a container called "Container".
The way I make this happen is using the following code.
AzureBlobID: ...
0
votes
1
answer
95
views
Power Apps Component - Table Property Issue
I have a component for Sidebar Menu, which has a MenuItems property of type 'Table'. When assigning a Table object directly to this property, the component works fine in a Screen. But when the Table ...
0
votes
1
answer
290
views
Column doesn't exist – but it clearly does in collection and SharePoint
I'm having issues with everything inside the ForAll function for my buttons onSelect. Every line throws an error saying "The specified column 'RowNumber' doesn't exist," even though all ...
0
votes
0
answers
38
views
Cannot Add powerpagecomponent_mspp_webrole_contact Table as Data Source in Power Apps Canvas App
I'm working on a Power Apps Canvas app connected to Dataverse, and I need to show all contacts without web roles and assign roles to them. According to Microsoft documentation and various blogs, the ...
0
votes
2
answers
190
views
Can I open an App in the PowerApps Studio in ReadOnly mode?
I know if I leave the PowerApps Studio open for to long or open it in another browser window for an App it will switch from "Editing" to a read only mode in the PowerApps Studio.
Is there ...
0
votes
1
answer
97
views
How to combine two data tables in PowerApps via Salesforce API (left join)
Table Opportunity Product does not have the product that corresponds with the Product Code in table Product.
How how do I combine these tables in PowerApps via the Salesforce API (left join)?
...
0
votes
0
answers
84
views
lookup with addcolumns and filter not working properly
In my canvas app I have one combobox and it has items query as
With(
{
matchingPlacements: Filter(
'Placement Details',
Year = ComboboxCanvas2_10.Selected.Value &&
...
1
vote
1
answer
96
views
Power Apps Suggested Values for Text Box
I am working on building a Dataverse/Power Apps/ Power Automate solution for managing projects and reporting in a research environment. I am currently building a New Project form, and would like for ...
0
votes
0
answers
29
views
PowerApps ComboBox on Collection
I have a gallery from which I load all items into a collection when any value changes. One of the items is a Person ComboBox. I have gotten the record into the Collection. Eventually, I need to save ...
0
votes
1
answer
117
views
PowerApps - Office365Outlook.SendMailwithOptions Not getting response
I am using the Office365Outlook connector SendMailwithOptions and using Microsoft Power Platform Help page was able to set it up as such:
Office365Outlook.SendMailWithOptions(NotificationURL,
{
...
0
votes
1
answer
127
views
How to limit the amount of selections an end user can make in a dropdown
Have a Canvas App with a dropdown selection (SelectMultiple = true) that retrieves its data from a SharePoint List, works perfectly except for one thing: An external resource will only accept X number ...
0
votes
0
answers
42
views
Power Apps – How do I assign the next available “floor” row to each CL / CR scan (door pair) in a repeating production order?
Context: this logic runs in the OnScan of a barcode input.
scanOP = 8-digit production order (e.g. 12345678)
scanIZ = door side being scanned: "CL", "CR", "DFL", "...
0
votes
0
answers
96
views
PowerApps.MSBuild.Solution.targets(137,5): error : Value cannot be null while running msbuild
I am trying to push pcf control to dev environment. while running msbuild it is throwing below error.
C:\Users\manojmalagouda.p.nuget\packages\microsoft.powerapps.msbuild.solution\1.42.1\build\...
0
votes
1
answer
91
views
Sliders and containers to move the first container left and right and the second container will adjust
How can I create a dynamic layout where two containers adjust their widths based on a slider's value? The first container's width should be customizable, ranging between proportions like 20% to 50%, ...
0
votes
2
answers
185
views
How to get all messages from teams channel in powerapps to reply to them from powerapps?
I want to get all the messages subject from teams channel with messages Id, So that I can reply to those specific post from powerapps. Is there any way to get all the messages ?
I have tried with ...
0
votes
1
answer
195
views
Is it Possible To Use A Variable in a LookUp Function in PowerApps?
I'm attempting to use a combination of an input box and dropdown field to give my users two ways to search their request: request # (RIT) and their ID. (Ignore/Replace R# for RIT# in the screenshots, ...
0
votes
0
answers
78
views
Can I create and/or modify and/or refer to controls in a Power App programmatically?
I am building a people-picker app where the number of people to be picked is dynamic (dependent on app state), and I would like to have each person in a separate control (ideally a combobox). I only ...
1
vote
1
answer
396
views
Screen Navigation Issue in Power Apps (ScreenLoad Not Working After Update)
I am encountering an issue with screen navigation in my Power Apps app. After updating the app to version 3.25034.13, when I use the Navigate(Mypage) command on a screen, the action does not seem to ...
0
votes
1
answer
152
views
How can I create a visually distinct double border around focused input controls in a PowerApps canvas app?
I have canvas PowerApps wherein I have text input, dropdown, and calendar control present on the form. We have default control focus border available for these controls. But I need an additional ...
0
votes
1
answer
784
views
Person combobox in Power Apps - Default selection display issues
I have a SharePoint Online list with a Person column. I have created a Power Apps form to enter the data because I would like to be able to set up a default value for the field (the user should be ...
0
votes
1
answer
327
views
PowerApps - ClearCollect / Collect deletes rows or creates blank rows in Collection
IDK if this is something very basic escaping my understanding, or if PowerApps is just acting weird:
In a canvas app, on the click of a button, I'm creating a collection of 5 rows, each with an index ...
0
votes
0
answers
271
views
PowerApps 3rd nested gallery not working - nested filter not working
I have a nested structure like this:
REPAIR ORDER 1 / John Doe / 2024 Charger
INTERVENTION 1 / Engine Noise
POSITION 1 / Labor
POSITION 2 / Bearing
INTERVENTION 2 / Tyre Change
...
0
votes
1
answer
98
views
PowerApp - not sending contents of form on email submission
I have created an attendance register PowerApp for a youth group.
The app pull in a list of names from a SharePoint list, although I can also add new users within the app.
The app is correctly ...
0
votes
1
answer
135
views
Power Apps and SQL - make text field visible based on drop-down selection
I have a SQL table that has two rows in it which are choice options for a drop-down list in a fairly huge SQL database (there are eight columns, but that's probably not relevant). I'm also using that ...
0
votes
0
answers
77
views
Not getting FileContent of Attachments in canvas app collection?
I have one form in my canvas app which has fome feilds and a attachment. On submit button I have this code
If(Connection.Connected,
//Online Mode: Save to SharePoint
SubmitForm(EditForm1)
,
//Offline ...
0
votes
0
answers
53
views
How to store attachments for offline mode?
I have one canvas app form and it uses SharePoint list as a data source and has attachments that stored in the attachments of Sharepoint list. I want to work it as offline also. So, I have update the ...
0
votes
0
answers
171
views
How to connect to OneDrive on PowerApps?
I am trying to connect my OneDrive library to PowerApps. I want to create a dropdown that lists all the folders within my specified path. I tried the SharePoint Document Library approach, but this is ...
0
votes
0
answers
116
views
Barcode reader - automatically scan - Powerapps
I'm working with the Barcode Reader control in a Canvas App using the "Automatically Scan" feature. Sometimes, the scanner registers the same QR code twice, leading to unintended duplicate ...
0
votes
1
answer
516
views
How do I generate an OpenAPI definition for an existing application?
I am trying to build a custom connector for Power Apps. I need an OpenAPI definition (a json file) to create the connector. If I have an Azure AI resource, like Computer Vision, how do I generate or ...
1
vote
1
answer
801
views
Power apps cannot use barcode scanner function
I have tried using barcode scanner in power apps to store barcodes in a collection. I used this following formula onScan
Collect(colBarcodes,Self.Barcodes)
Then, I show the collection in a gallery by ...
0
votes
0
answers
652
views
Add Tooltip on Hover text in PowerApps DropDown
I want to add custom tooltip in PowerApps dropdown control based on the Hover text. Is it possible to add?
On the DropDown1's Item property I have a collection:colSubmitActions that includes: ["...
0
votes
0
answers
143
views
PowerApps(CanvasApp) ForAll with collections
I am trying to filter a table based on the reocrds of a column of another table. For example here the values of the column ID of the RequestIDsTest are the same as some of the values of the ...
0
votes
1
answer
461
views
How do I maintain scroll bar location in a gallery after a form has been submitted and the data set refreshed in Microsoft Power Apps?
I have an interview guide that I built in Power Apps using submitform. It works when there's only one interviewer since they can save and then simply scroll back down to where they were in their ...
0
votes
1
answer
380
views
Power Platform Canvas App value is blank when playing the app, but visible in the editor
I have a canvas app that has a gallery of a dataverse table. This table, has a lookup column of another table called "Course", and that course has a lookup column of another table "...
0
votes
0
answers
184
views
Sharing Power Apps Application on Teams
I’m trying to create an application in Power Apps directly from Teams, but I’m facing an issue with data visualization. The data is taken as input from an Excel file stored on SharePoint online. The ...
0
votes
0
answers
72
views
Oracle: ORA-22816: unsupported feature with RETURNING clause performing Patch function in PowerApps
I have an app that has two patch functions. The first patch runs fine, no issues.
So now time for the second patch. When I run this, I constantly get the message:
message": "Oracle: ORA-...
1
vote
1
answer
507
views
How do I get the Substitute function in PowerFX to apply the substitute to every instance of the substring using the Match function?
I need to pull every instance of the substring "Whisper from.• \d{1,2}:\d{2}:\d{2} (AM|PM) \n" from a larger string variable and convert it to "Whisper from.• \d{1,2}:\d{2}:\d{2} (AM|PM)...
0
votes
1
answer
863
views
Power Apps Form not pulling from Datasource
So I am building a power app and I have 2 data sources linked which are both distinctly named. I started by creating a screen that was a gallery of the first data source and then a second screen that ...
0
votes
1
answer
95
views
Disable combobox/dropdown/datacardvalue control in powerapps sharepoint list form
On combobox data card value selected disable combobox control in powerapps sharepoint list form.
In Powerapp designer we can see that DisplayMode property is disable.
I also add screenshot, which ...