Questions tagged [powerapps-canvas]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
8 views

In PowerApps column chart, how ow do you deselect a selected column

I am using PowerApps charts to control a gallery. The Pie chart works fine I can select a wedge in the pie and it filters the gallery - to clear the selection all i have to do is click outside the ...
user111836's user avatar
0 votes
1 answer
14 views

Struggling to Filter & Sort

In PowerApps, I have a Screen that displays a few SharePoint lists depending on the selection from the prior screen. On the Gallery in question, the only formula I have in the Items box is this: ...
Will's user avatar
  • 1
0 votes
0 answers
7 views

How i can get the login user Business Unit and Cost Center from active directory?

Is it possible to get the login user Business Unit and Cost Center from active directory inside our canvas app?
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
34 views

Does the Power Apps with SQL Connector will use Connection Reference while connecting to SQL Database/Table in Canvas App?

I have a canvas app using SQL as data source connector, currently I am using connection. But while moving from one environment to another as a managed solution I am unable to change the SQL connection ...
sai abhinav's user avatar
0 votes
0 answers
9 views

Better way to customize tables in Power App?

I have a table to be customized in Power App to use in SharePoint site. The table look like this: This table should be customizable for users to add new rows or update already available data in the ...
luhar's user avatar
  • 11
0 votes
1 answer
44 views

[Object][Object] Error Sharepoint Power App Table

I have the following error when inserting a Table into Power App. The reason is that Composition is a choices Column and so is effectively a table within a cell. However looking online there do ...
Nick's user avatar
  • 105
0 votes
1 answer
22 views

Displaying the details (first name, surname ,email etc.) of the user currently logged into my power app

I'm just wondering if it is possible to display the personal information of the user currently logged in an my 'User Profile' section of my app? The first image attached is the current list I have ...
E56's user avatar
  • 1
0 votes
0 answers
22 views

I am trying to recreate this view in power apps in a screen

I have a list in SharePoint that stores the user as a text field. The task is a drop down selection of projects A, B, C, etc., they will also need to have start and end dates for each project. and I ...
Newb's user avatar
  • 51
0 votes
0 answers
15 views

Canvas Calendar Template with Multiple Calendars

I'm in a SPO environment I have a requirement to make 3 training room scheduling calendars. 121A, 121B, 121C, rolled into calendar, with a Canvas Apps look. I have a couple of options, I can create a ...
user79745's user avatar
0 votes
0 answers
16 views

Is using GroupBy and Sum inside the Items property of a chart consider a delegable operation in power apps

I am viewing this video on YouTube @ https://youtu.be/b8iz1ar1I4E?t=1932 on how to build charts in power apps by grouping date and show sum, the videos shows how to build a chart with this formula ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
9 views

How can I learn the Power App Studio?

Please recommend a good or official resource for learning Power App Studio. Is there an official documentation?  Is there a recommended training guide?  Is there an official YouTube channel and video ...
xarzu's user avatar
  • 101
0 votes
1 answer
71 views

Power Apps Customized Form - Auto populate selected User's Phone numbers

I have a Power Apps Customized SP form, and I have a requirement to auto-populate a selected user's mobile and business phone numbers. Basically I have a Project Manager people picker field, then two ...
Chris's user avatar
  • 403
0 votes
0 answers
16 views

Patch not picking up updates

I have a multi-screen app that connects to a SharePoint list which works pretty well when a new item is being created but when I am trying to update an item, my patch function does not pick up the ...
badsalvarado's user avatar
0 votes
1 answer
42 views

Is using RemoveIF() against SharePoint list consider a delegable operation or not

I did not enable this experimental feature: and at the same time I am using RemoveIf() on many scenarios such as: and none of the RemoveIf() is raising delegation warning? so will the RemoveIf() in ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
46 views

Error in formula

I am trying to create a "Text Input" with this property: Value(TextInput7_4.Text) + Value(TextInput7_8.Text) + Value(TextInput7_11.Text) It is giving me error: This rule creates a ...
Jose1978's user avatar
  • 103
0 votes
1 answer
32 views

PowerApps Canvas Form - Date Picker error *IF* Selected date is not a Sunday

Good morning, I have a Power Apps Canvas form (connected to a SharePoint list) where I have a date picker field with a weird requirement. I need the Datacard's error message to read "Must be a ...
Chris's user avatar
  • 403
0 votes
0 answers
21 views

AddColumns is raising delegation warning although i am filtering based on ID numeric field

I have this formula: Clear(colWOSPD); ForAll( colWOSP As wosp, Collect( colWOSPD, Filter( 'Work Orders Spare Part Details', 'Work Order Spare Part ID' = ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
434 views

PowerApps Canvas app - Email format validation in text field

I have a canvas app with a text field for a user to enter their personal email address. Is there a way I can throw an error if they didn't enter in the correct format? Try to force them to use correct ...
Chris's user avatar
  • 403
0 votes
1 answer
56 views

Power APPS- Disabling button in the gallery

I need to disable a button inside a gallery. Trying these two expressions, both giving error. Thoughts please! Thank you. I tried: If(Value(TextInput7_2.Text) > Value(TextInput7.Text), DisplayMode....
Jose1978's user avatar
  • 103
0 votes
1 answer
27 views

Attaching the generated PDF to the list item is no longer working

The below scenario was working well yesterday but stopped working today. I have a submit button to generate a PDF for a container >> then add the generated PDF inside the list item attachment ...
microsoftdeveloperdesigner's user avatar
1 vote
1 answer
60 views

Power Apps Image referencing

I have an app that I have uploaded several small images into. What I am trying to accomplish is by use of a drop down with the selection option of we will say: Cat Dog Turtle I would like with the ...
Kody's user avatar
  • 11
0 votes
1 answer
90 views

Using IsBlank() & <> will cause my filter to raise this error "Error when trying to retrieve data from network:

I have this formula to filter SharePoint list: ForAll(relatedNetworkIDsFortheCurrentBookingCalendar, Collect(colDelegableresults, Filter(BookingCalendarNetwork, ActiveStatus.Value = &...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
294 views

Error handling for a Patch and SubmitForm()

I have this formula inside the Submit Button:- Patch('Printing Orders Details', ForAll(PrintOrderDetailsGallery.AllItems, { ID: ID, Quantity: Value(PrintOrderQuantity.Text), ...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
332 views

Hide Visibility of PowerApps Form Container Based on Name in Field

I have an approval flow that updates a field after an outcome with the name of the approver. The field name is Approver. Its a single line text field. What I'm trying to do is check to see if the name ...
Mile T.'s user avatar
  • 155
0 votes
1 answer
598 views

Patch new record with lookup column Power Apps

How to create a new record in SharePoint list with a lookup column from a button? SharePoint list "tbl-one" has a lookup column "Contract" and other columns "Title" and &...
Bra Tabs's user avatar
0 votes
1 answer
78 views

OnSelect Formula Switch to Other Screens Not Working

Pretty sure this belongs to the Power Apps forum but I'm gonna try my luck here as well: I have been encountering a simple issue about switching screens depending on the value of the dropdown data ...
badsalvarado's user avatar
0 votes
1 answer
396 views

Remove-Clear-the-selected-value-from-a-combobox-upon-changing

I have 2 combo boxes named; Street & Location inside a Power Canvas App. Now I want to clear the selected value of the Location combo box when the Street combo box is changed. How I can do so? I ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
13 views

Relation between SharePoint lists in a way that is aligned with Power apps recommendations

We have those SharePoint 4 SharePoint lists: Asset Medium Asset Spare Parts. Each item inside this list will be related to an Asset + a Medium + a Payment Category Payment Category Now I got lost ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
22 views

Replace a ID field with a combo box field

I have 2 SharePoint lists; Assets & Media.. Inside the Assets list I am storing the MediumID inside a number field.. now inside the Assets form i want to replace the MediumID with the combo box ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
160 views

Build a combo box for the sharepoint people/group field

I have a SharePoint list named Technicians which contain a field name "Technician Name" of type people/group, as follow: Now I want to build a combo box field which shows the Technicians' ...
microsoftdeveloperdesigner's user avatar
1 vote
2 answers
64 views

Minimize the Height of the Vertical Gallery items? Gallery "Templatesize" property Vs Gallery item "Height" property

We have a Vertical Gallery inside containers, as follow: now each gallery's item is occupying a lot of vertical space, as follow: so how I can minimize this space in a dynamic way? now there are 2 ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
10 views

Canvas App Export Error

I am fairly new to canvas apps and I am facing an error there. I want to migrate Canvas apps so trying to export it. But I am running into an error : Has any one come across this? Kindly help me if ...
Prajakta Agte's user avatar
0 votes
0 answers
39 views

How to use http Call or REST enabled API in PowerApps form to do Post Call

I have a PowerApps form. I want to do Post operation through external API call upon one button click over the PowerApps Form. I don't want to use the PowerApps triggered Power Automate for this. So, ...
Kailash Sahoo's user avatar
0 votes
1 answer
229 views

Can guest users access Power Apps or Power Pages? What are the options available

We have a project that requires guest users to have access to use Power Apps or Power Pages. My question is do they need to be licensed for them to be able to use it at all. There are so many ...
naijacoder's user avatar
  • 4,272
0 votes
0 answers
19 views

I can edit and save the powerapp in the solution but can not run/play in the sandbox environment

Hi I need to work on Power App part of Solution in the Sandbox environment. I can edit and save the app, however when I play I get the error message for request access below. I have Microsoft Power ...
Viral's user avatar
  • 131
1 vote
1 answer
911 views

Unable to submit attachments from Power Apps form to SharePoint list, for users other than Owner

I have a Power Apps application, containing a form, which submits to a SharePoint list. The form has an attachments field, and the list has an attachments column. When I run the application with the ...
the common starling's user avatar
0 votes
1 answer
216 views

I'm trying sort in powerapps but it's giving me errors

I'm using this onChange in fluent UI creatorkit detailsList connected with sharepoint list, ClearCollect( MyDataSource, SortByColumns(MyDataSource, If(SortAsc, SortColumn, SortColumn & &...
Karthick's user avatar
1 vote
1 answer
2k views

Using IsBlank in formula for Date Time Picker field on Power Apps

Pretty new to SharePoint and Power Apps so would like to ask if what I am trying to do is feasible. I have a Date Time Picker field in my formula in Power Apps and currently, its default value is set ...
badsalvarado's user avatar
0 votes
1 answer
606 views

Is it possible to use environment variable in canvas Power Apps for SQL data source

Is it possible to use environment variable in canvas Power Apps for SQL server data source? If not, any work around so that we can update the SQL server name and database name in a managed solution? I ...
Mark L's user avatar
  • 4,065
0 votes
0 answers
42 views

Patch function adding new rows to my SharePoint list instead of updating the targeted columns

The code below looks for the ID and then updates the number of items in the columns (No. Boots Distribution, No. Hats Distribution and No.Coverall Distribution) the data is updated by selecting a ...
Lukes's user avatar
  • 1
0 votes
0 answers
871 views

Error in Power Apps: Expression "XXX eq null" is not supported

I get an error in Power Apps when starting the app but it dissappears later. The error displays: Error when trying to retrieve data from the network: Expression "homeTeam eq null" is not ...
pomaaa's user avatar
  • 103
0 votes
2 answers
22 views

Issue with If statement

I am having an issue creating an if statement in Power Apps. What I am trying to achieve is when there is no selection from the drop down, the button stays disabled or grayed out, and then when there ...
Harris's user avatar
  • 593
0 votes
1 answer
821 views

Dynamically displaying images in Power Apps Gallery

I am reading data about countries from Excel online to my Power Apps application. There is a column in excel is called countryImage and has a string for example "UK". I have uploaded all ...
pomaaa's user avatar
  • 103
0 votes
0 answers
134 views

Power Apps ComboBox won't allow user to add a new option

I have a ComboBox in my powerapp that populates using data from a sharepoint list, using Distinct(ListName, Application), with Application being a column of type 'Choice' from the List. This works ...
Jeff Aubé's user avatar
1 vote
1 answer
3k views

Can't submit 'people' data from power apps to SharePoint List

I have a Microsoft Power App that I'm currently developing for my company to keep track of contacts for different projects. One thing that's crucial to this is being able to input new contacts to the ...
Jeff Aubé's user avatar
0 votes
0 answers
87 views

Power platform Center of excellence (CoE) - remove solution layers

I am in the process of upgrading the Centre of Excellence (CoE) core component solution. As we know, before upgrading, we need to remove the solution layers, if any, from the solutions, as per ...
SP 2022's user avatar
  • 4,074
0 votes
0 answers
41 views

Urgent help need on sharepoint list update with Power Automate

I am creating a Leave Request Form in PowerApps, added Power Automate flow. Everything working fine. Now, I need to update my LeaveBalance List (AppliedLeave Column) with the data from Leave List(...
Santosh Kumar Ghosh's user avatar
0 votes
1 answer
427 views

Multiple IF statements - PowerApps

I am looking to filter a drop down list from 2 other drop down lists. I currently have it working from just one of the lists as follows: If(IsBlank(('ComboBox1'.SelectedItems)) || IsEmpty('ComboBox1'....
PA_Novice's user avatar
0 votes
1 answer
57 views

Prevent submitting a form and show error message if 2 combo boxes contain the same value

I have 2 combo-boxes inside a canvas app form named Approver1 & Approver2 >> where both fields represents a SharePoint "People/Group" field Now I want to make sure that the ...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
470 views

what are the best options in embedding power app in SharePoint page

I have been playing around how to best embed power apps to look nice on SharePoint pages but have had no luck so far. When I embed it using any of this ways below (I get all sort of grayish borders ...
naijacoder's user avatar
  • 4,272