2
votes
Accepted
PowerApps Form - Multi Select People Picker Field - How to split these values into two separate Text Labels
you can use a formula like this (I named the control "MultiPeopleValue"):
First(MultiPeopleValue.SelectedItems).DisplayName
or
Last(MultiPeopleValue.SelectedItems).DisplayName
You can use ...
- 9,044
2
votes
Patch new record with lookup column Power Apps
Ideally you have to pass the item ID from lookup parent list as well in Patch function.
Example:
Patch(
'Site Inspections',
LookUp('Site Inspections', ID=1),
{
BranchLocationLookUp:...
- 45.8k
1
vote
Can I have a hyperlink in a Power Apps table control?
If you are asking about classic data table control, there is an IsHyperlink property available for columns inside the data table control.
You can write formula like below on OnSelect property of ...
- 45.8k
1
vote
Gallery with multiple Sort fields will not show any data
Although it's not directly related, it seems IsBlank() function is not a supported delegable to SharePoint. Could you replace it with Blank() and try it again?
For more info, please refer to MS ...
- 2,512
1
vote
Accepted
How to Auto-Select a Gallery item in a Canvas app based on item's ID
Here is what you can try for your problem:
When user clicks on the column in SharePoint document library, open Canvas Application and redirect user directly to your "Form" screen based on ...
- 45.8k
1
vote
Accepted
How to format User().DisplayName to display the same as People field
I would suggest you to use the Email property instead of display name for comparing users.
Two users in the company may have same display names sometimes.
So, try setting Visible property of controls ...
- 45.8k
1
vote
Accepted
PowerApps SP Form - Referencing List item value in another List
Here is a test for your reference:
Here is listB
Here is list A
Here is newform:
DefaultSelectedItems: LookUp('List B',Project in DataCardValue2.Selected.Value).'Project Director'
1
vote
OnSelect Formula Switch to Other Screens Not Working
If you are using a drop down control in Power Apps, try using formula like below:
Switch(
IssueRequestType_Dropdown.Selected.Value,
"Other",
Navigate(GenericFormScreen, ...
- 45.8k
1
vote
Accepted
Replace a ID field with a combo box field
Try this:
If your combo box control is configured to have single selection only, set DefaultSelectedItems property of combo box control in Power Apps to:
LookUp(Media,ID=ThisItem.MediumID)
Where ...
- 45.8k
1
vote
Accepted
Build a combo box for the sharepoint people/group field
Try this:
Set items property of combo box control to:
Distinct(Technicians, 'Technician Name'.DisplayName)
OR
AddColumns(Technicians, "TechnicianNamePP", 'Technician Name'.DisplayName)
...
- 45.8k
1
vote
Minimize the Height of the Vertical Gallery items? Gallery "Templatesize" property Vs Gallery item "Height" property
You have to change theTemplateSize property of Power Apps gallery control to manage the height of individual item inside the gallery.
And yes, you can define the dynamic formulas for these properties.
...
- 45.8k
1
vote
Accepted
Power Apps customized SharePoint form - Certain fields with variables won't re-populate when opening an existing item
This is happening because you are using a variable as Default value and that variable is blank on form load when you are opening existing SharePoint list item.
The value of varAirCost variable will be ...
- 45.8k
1
vote
How i can get the login user Business Unit and Cost Center from active directory?
You call a SharePoint API to get that for you using Power Automate.
This is part of the URL
_api/SP.UserProfiles.PeopleManager/GetUserProfilePropertyFor(accountName=@v,propertyName='CostCenter')?@v=%...
- 818
1
vote
Accepted
Power Apps Converted Multi-select Checkboxes clear out after an item has been edited
I think you will have to populate the Region5 collection again when opening the SharePoint list form in edit mode.
Try using below formula in SharePointIntegration.OnEdit property:
EditForm(...
- 45.8k
1
vote
Accepted
PowerApp DataCardValue.Text Returning as blank when not blank
To achieve this you need to do the following two steps:
Set the form mode - Whenever you work with the Edit Form component you need to specify in which mode you are going to work. Since you want to ...
- 45.8k
1
vote
PowerApp DataCardValue.Text Returning as blank when not blank
You can try = Blank() instead of IsBlank():
If(DataCardValue1.Text = Blank(), DisplayMode.Disabled, DisplayMode.Edit)
The IsBlank function tests for a blank value or an empty string. The test ...
- 1,238
1
vote
Accepted
PowerApps SP Custom Form - Display fields as currency
Try this:
Set OnChange property of text input control to:
Set(varFormat, Self.Text);
Reset(Self);
Set Default property of text input control to (same as given by you):
If(
!IsBlank(varFormat),
...
- 45.8k
1
vote
Accepted
Power Apps Customized Form - Auto populate selected User's Phone numbers
If you are using single selection person or group field in SharePoint list, try using below solution which worked for me:
Set Default property of Work Phone Data card control to:
If(
...
- 45.8k
1
vote
Accepted
Is using RemoveIF() against SharePoint list consider a delegable operation or not
By default, RemoveIf() function is not delegable with the SharePoint data source. Delegation support is in experimental phase currently.
Here is some information from the documentation:
But, if you ...
- 45.8k
1
vote
Error in formula
I think you are trying to set the Text property of Text Input control (one of these: TextInput7_4, TextInput7_8 or TextInput7_11) based on the Text property of same text input control which is causing ...
- 45.8k
1
vote
Accepted
PowerApps Canvas Form - Date Picker error *IF* Selected date is not a Sunday
You can check the day of selected date using Weekday function like:
Weekday(DateControlName.SelectedDate)
So, try setting Text property of error message label control to:
If(Weekday(DateControlName....
- 45.8k
1
vote
Accepted
PowerApps form - Change fields' error message color - Red is not 508 compliant
If you are using Form control in Power Apps, you have the data card controls for each field inside the form control.
You will have your input field controls (like text input, date, drop down controls) ...
- 45.8k
1
vote
SharePoint Online List Form PowerApp zip file difference between PS5 and PS7
The best practice is to use pack/unpack features of Power Platform CLI.
But, as your initial question is about to zip/unzip, it's better to use tools like 7Zip or tar. Native PowerShell (Compress-...
- 1,238
1
vote
Accepted
Power Automate - Create Document Set with Metadata to SharePoint library
Use the 'Send an HTTP request to SharePoint' action to create the document set from a specific content type.
Use another 'Send an HTTP request to SharePoint' action to set the specific metadata ...
- 525
1
vote
Accepted
Power APPS- Disabling button in the gallery
Is the column/data type of Cost_mitigation_1 and effect_mitigation_1 not "Number", try using formula in Power Apps like this:
If(
Value(ThisItem.Cost_mitigation_1) > Value(ThisItem....
- 45.8k
1
vote
Error handling for a Patch and SubmitForm()
You can use Errors() in Power Apps to to perform Error Handling for Patch function in Power Apps.
Example:
// create a new record in test scores list
Patch(
'Test Scores',
Defaults('Test ...
- 45.8k
1
vote
Hide Visibility of PowerApps Form Container Based on Name in Field
You can use below simplified formula in Visible property of your container or other controls in Power Apps (use latest MyProfileV2 function instead of MyProfile):
DataCardValue.Text = Office365Users....
- 45.8k
Only top scored, non community-wiki answers of a minimum length are eligible