Questions tagged [powerapps-canvas]
The powerapps-canvas tag has no usage guidance.
96
questions
0
votes
0
answers
24
views
How to get Key Value Pair value from valid JSON string in PowerApps?
I am working with the requirement in PowerApps where I have a JSON string like below
{
"Created": "2022-08-29T16:40:19",
"IsCurrentVersion": true,
"VersionId&...
- 8,465
0
votes
1
answer
18
views
Get the email address from SharePoint list and build Table inside Power Apps instead of hard-coding the values
We have the following Collection which contain a Type and Table of Email addresses inside Power App formula, with email addresses been hard coded, as follow:
ClearCollect(
varUserForContracts,
...
- 55
0
votes
0
answers
10
views
Flexible/Responsive horizontal container which looks like a data table
We have the following flexible screen:-
now inside the vertical container (container 6_1) we have 2 horizontal containers (container14 & container15) ..
The container14 contain 4 labels with ...
- 984
0
votes
1
answer
21
views
PowerApps Form - Condition for changing value of text field based on drop-down
I have a PowerApps form with a Workflow that keeps firing off multiple emails because of how the fields are set up. I'd like to have one text field that will change its value based on three other ...
- 197
1
vote
1
answer
22
views
Duplicate emails being sent from Power Automate Flow. Using multiple Selectable column is issue
Hoping to get some insights / direction here. I posted on the community MS forum but no-one really help. I'm not very technical and have been battling for months to build a full solution anyways.
...
1
vote
1
answer
15
views
Page title or URL as a parmeter
I'm trying to pass either the page URL or Title as a parameter in SharePoint online to a Power app.
It has to be dynamic since I am going to be placing a link to the power app in the footer which will ...
- 11
0
votes
1
answer
9
views
Power Apps, Drop Columns formula help
I am trying to drop columns so I can get my browse gallery working properly.
However my formula is not working properly.
I get error:
There is an error in this formula. Try revising the formula and ...
- 173
0
votes
0
answers
30
views
how we can add custom Datacard inside Fluid Grid
We have a Fluid Grid named "canvas_contractform2":-
and we need to copy/paste 2 DataCards (DatacardApprovercontrols + DataCardApproverForm).. but seems there is not any option to copy the ...
- 55
0
votes
1
answer
17
views
Can we force the SharePoint Lookup field to be delegable inside Power Apps
We have a list named Large123, and inside another list we define a lookup field named ll to reference the Large123 list, as follow:
but when we try to do a Lookup formula on the Lookup SharePoint ...
- 55
0
votes
0
answers
10
views
Missing data in collection
I have a collection with 2 sharepoint lists in it. This collections builds up by pressing a button (for now). The problem is that date values are missing after line 515 in the collection. I know the ...
- 101
2
votes
1
answer
52
views
Power Apps, SortByColumns, matching Dropdown choice to Column Name
When I try my formula in browsegallery, I am only seeing data for the drop down CAATT ID and Requestor. I cant find out why my other dropdown choices arent working here.
Could it be column type? or ...
- 173
0
votes
1
answer
13
views
Filter on Showcolumn & distinct, inside my Power Apps formula
I have this formula which is working correctly:
ClearCollect(
colUniqueDates,
AddColumns(
RenameColumns(
Distinct(
'Grant Applications',
...
- 55
0
votes
1
answer
20
views
Power Apps, Dropdown choice for column, Ascend/Descend based on Column choice
I have a power app, I have listed my columns in the Item Section of a drop down:
How can I alter my Browse Gallery to Sort by Ascending/Descending based on my dropdown choice?
Current Browse Gallery ...
- 173
0
votes
1
answer
15
views
Power Apps, TextSearchBox not searching for my String + integer field
I am trying to search my field "Title" which contains a combination of string + numbers.
I.e. "Stack-1234" is a record in my field "Title".
Items in BrowseGallery1:
If(...
- 173
1
vote
2
answers
27
views
Can we scan barcodes when we are using the power apps on the web
We have 2 fields: one which is a free text and the other is a combo-box. we have 2 barcodes, so can we scan the 2 barcodes and add their values inside the text and the combo-box fields?
As I were ...
- 55
1
vote
2
answers
28
views
I need to figure out on how to achieve a show/hide password
I have a login form, everything else works except for the part where I want the View icon to show/hide the password entered. The mode of the input now is TextMode.Password. It's automatically masked ...
- 13
0
votes
1
answer
20
views
PowerApps Studio- Permissions - Premium Plan
I have a co-worker who built an app in PowerApps, but utilized a lot of features in his PowerApps Premium plan. He made me a co-owner of the app, but I don't have a Premium account. In the app I see ...
- 197
0
votes
0
answers
17
views
Custom Security Role cannot create Model driven App
I have created the custom security role copy of "Basic User role", for certain users which can create canvas app but for model driven app users cannot create app and receive follow message &...
- 57
0
votes
0
answers
8
views
Common Data model with PowerApps
We have a requirement to read and write the file data via PowerApps either in Canvas app or model Driven App. But the file was located in the Common data Model in the Data lake. I had gone through ...
- 2,818
1
vote
1
answer
45
views
Branching in Power Apps Form to Hide or Show Fields Based on Any Dropdown Value
In Power Apps, I have created a Form. In one of the DataCards (DataCardValue10), the Form asks a question where the user can select multiple values from a drop down list. The values in DataCardValue10 ...
2
votes
2
answers
358
views
Power Apps change Image based on field value
I have built a weather app in Power Apps. I'm using the MSN weather connector to gather several basic criteria, namely "Precipitation". So I have several images I'd like to use for sunny, ...
- 197
0
votes
1
answer
224
views
Power Apps, If statement for Single Line field
Does my datavaluecard have to be a dropdown for me to do this?
If( ThisItem.Status.Text = 'Submitted', DisplayMode.Disabled, DisplayMode.Edit)
I cant seem to get the "Status" column to = ...
- 173
0
votes
1
answer
9
views
Asset Management App - How do I filter a collection of lists displayed in a PowerApps gallery using a comboBox of people names?
I am trying to find a way to filter a collection of SharePoint Lists displayed in a PowerApps Gallery using a ComboBox dropdown. This ComboBox dropdown gets data from another sharepoint lists for ...
0
votes
0
answers
18
views
Loop thorugh a collection and issue seperate Lookup instead of using one Find and get delegation warning
I have 2 SharePoint lists:-
Task list .. with these fields:-
ID
Title
PeopleWork list.. with these fields:-
ID
TaskID .. this should store the Task ID from the Task list in numeric format
...
- 984
0
votes
0
answers
5
views
CDS for apps table "admin_apps" does not contain data about portal apps
I want to fetch the last date an app was run on. For Model-Driven and Canvas apps I do so by quarrying the data in the CDS table named "admin_apps". But this table only contains data about ...
1
vote
2
answers
348
views
Check if the login user email is inside a SharePoint People/Group column which allow multiple selection
We have a list named Task, with these fields:-
Title
PeopleWork
Where the PeopleWork field is of type People/Group which allow multiple selection, as follow:-
Now inside our Canvas app >> i ...
- 984
0
votes
0
answers
38
views
Using Microsoft PowerApps, how can I use a employee dropdown list to display data from multiple SharePoint Lists with different column names?
I have several SharePoint lists created for asset tracking. I am trying to use a dropdown list for employee names to display data for a particular employee using multiple SharePoint Lists with ...
0
votes
1
answer
200
views
Show all fields inside a Power apps form in a Vertical layout of 1 column instead of 3 columns on small screen sizes (mobile screens),
I am trying to make my Power Apps standalone have a responsive design similar to Bootstrap effect. where if we have a form with 3 columns, as follow:
Now if we view this form using Power Apps mobile ...
- 984
0
votes
1
answer
30
views
Move apps from Test environment to Prod
I am new to the Power Apps, and I need some advice to see the best way to move the apps from test to prod environment is?
- 525
0
votes
1
answer
291
views
Powerapps, Button with If condition
I am trying to make my arrow button have the following logic, If Status = Submitted, do not go into the edit screen.
I pretty much want to lock the record if Status is submitted.
I tried the below and ...
- 173
3
votes
1
answer
1k
views
Power Apps: How do I show/hide a button based on a Text Input's length of its value?
In Power Apps, I would like to hide a button unless a specific Text Input has a value of at least one character.
Example:
if TextInputOne has no value, ButtonOne will be hidden
if TextInputOne's ...
- 33
0
votes
1
answer
19
views
How to check a checkbox inside our canvas Power Apps?
I have a checkbox named Checkbox2 and I want to check it, I tried this formula:(UpdateContext({Checkbox2.Value:true}) & Checkbox2.Value=true) inside the App's OnStart but none of them worked.
I ...
- 55
0
votes
1
answer
128
views
Fill gallery rectangle based on value power apps
Trying to fill a rectangle shape in a gallery based on a selection.
Using formula below, but not working:
If(ThisItem.'Risk Status'.Value="OPEN",RGBA(235, 130, 125, 1), Or(ThisItem.'Risk ...
- 75
0
votes
1
answer
198
views
how to duplicate Text box in Power Apps
I need some help to see if I can duplicate a text box using Button in Power Apps. I have to the Text box and a button in my power apps, and what I am trying to achieve is if the users need more Text ...
- 525
0
votes
0
answers
30
views
Deep linking is not working
I am implementing deep linking inside our custom power apps. where inside the App >> OnStart, we define to read the Id parameter, as follow:-
then on the Form >> we define the parameter ...
- 55
0
votes
1
answer
84
views
Power Apps: After Patch, text field is the only thing visible and no item is selected
I have a gallery on the left to display a filtered list of items. I have a gallery on the right to display the details of the selected item.
Also on the right, I have a text field and a save button. ...
- 131
0
votes
0
answers
28
views
Build a link which reference the Outlook event details using the Office365 Outlook connector inside Power Apps
I have created a blank Canvas app >> inside it i added a Calendar screen which creates Office365Outlook connector, now inside the Gallery >> i added an icon which should redirect the user ...
- 984
1
vote
1
answer
57
views
Why isn't navigate function passing data to new screen?
In PowerApps I am trying to build a function in my inventory app that will transfer data from one data card to another in a new screen when navigating, but I can't seem to get it to work. The user ...
- 23
1
vote
0
answers
21
views
Powerapp component Visibility based on match from Choice (multiple allowed) column in Sharepoint List
I have a SP List that has a column with a Choice selector where the editor can select more than one choice.
In powerapps I am trying to set button visibility based on the choice or choices they make.
...
- 177
0
votes
2
answers
71
views
Transforming Data in PowerApps
Problem Statement
I have a SharePoint List and I am attempting to take that data, pivot it, and apply style/formatting. I determined that PowerApps would be the ideal solution for achieving this, but ...
- 273
1
vote
2
answers
38
views
How to use Numeric Up/Down Control Text Input?
I want this kind of functionality in my PowerApps. Kindly tell me what should I do?
- 11
0
votes
0
answers
198
views
Activate or grey out button on powerapps
I would like show both buttons on Screen1 "Admin" and "User", so if user is admin in SharePoint (Full control or site admin) should have access to enter or navigate to both screens ...
- 57
0
votes
0
answers
164
views
Data table doesn't refresh
I have a canvas app where on one screen I have a data table connected to a SQL server table, which pulls a list of values. When I select a value in that list, it's supposed to take me to another ...
- 101
0
votes
1
answer
30
views
How we can dynamically show Buttons inside Power App, to be equal to the related list items.. is this possible?
We have a SharePoint online communication site, and it contains these 3 custom lists:
Master List
Child-1 List which contain a lookup column to the Master list
Child-2 List which contain a lookup ...
- 984
0
votes
1
answer
123
views
Power Apps, Close opened URL after Launch
I have a button that launches a URL, I do this to give my users access to the SharePoint List backend. I want to close this newly launched tab.
How can I do this?
Here is my button formula:
Navigate(...
- 173
0
votes
1
answer
396
views
Power Apps/Power automate: invalid number of arguments recieved
I am trying to use my flow on a button to create pdfs. It runs fine.
However it seems like my pdf is being named by a concatenation of all my html. ie website_br_br_stackoverflow etc.
So I am trying ...
- 173
0
votes
1
answer
733
views
Power Apps, Save as a PDF
Can't seem to find a button where I can export a power app page as a pdf/csv.
Is there any simple way of adding this?
- 173
0
votes
1
answer
66
views
"HTTP with Azure AD" connection is not available in my tenant
I was exploring on how Microsoft Teams can be provisioned using the PowerApps and Power Automate, where I came across this article Provision Teams using Power Apps and Power Automate. In this article, ...
- 3,859
0
votes
0
answers
43
views
Unable to use collect to populate a child records based on the Master/Parent ID
I have the following formula to add a Parent record (IT Access Form - Submission)>> get its ID >> loop through a child collections >> add the child collection and populate the lookup ...
- 55
0
votes
1
answer
347
views
Sharepoint/Power Apps, user can only see and edit own records within app
I am trying to edit my app in a way such that the user can only see and edit their own records. I am trying to do this within the app itself and not the list.
As I list I am aware I can restrict ...
- 173