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:...
- 42.9k
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, ...
- 42.9k
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 ...
- 42.9k
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)
...
- 42.9k
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.
...
- 42.9k
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 ...
- 42.9k
1
vote
Accepted
Unable to submit attachments from Power Apps form to SharePoint list, for users other than Owner
Uploading attachments to SharePoint list items is considered as the "update/edit" operation in SharePoint.
Hence you will need permissions to update/edit list items.
Here are two options you ...
- 42.9k
1
vote
Accepted
Dynamically displaying images in Power Apps Gallery
Image control is displaying blank because your are passing ThisItem.countryImage (which is of type text/string) to Image property.
Instead of it, try using Switch function like below for Image ...
- 42.9k
1
vote
Accepted
Navigate Screen Power Apps
Try using:
RequestHide()
Instead of:
Navigate('FormScreen1, Fade)
If you want to reset complete form, you can use ResetForm() function and use Reset() function to reset individual fields as per ...
- 42.9k
1
vote
Accepted
How i can show a thumbnail of a SharePoint list item attachment
You can use following formula to set image to achieve your both requirement (Assuming that you are customizing SharePoint List Form):
First(Attachments_DataCard1.Attachments).Value
See output below:
- 2,180
1
vote
Accepted
Make our PowerApps Canvas form look similar to SharePoint classic UI form (where the label & Input are on the same line and have space between them)
It should be as simple as selecting your form and change the layout from Vertical to Horizontal. You can then tweak the settings from there.
- 945
1
vote
Accepted
Prevent submitting a form and show error message if 2 combo boxes contain the same value
For single selection combo box controls in Power Apps, you can compare values using their properties via .Selected property.
For example:
For combo box with person or group column, you can compare ...
- 42.9k
1
vote
Accepted
PowerApps - How to write a "Contains" statement
Try using formula in below format:
If("Advisory" in DatacardValue37.Selected.Value, true, false)
Microsoft official documentation: Power Apps in Operator
- 42.9k
1
vote
Accepted
Is there a way to show the SharePoint fields' Descriptions automatically inside the Power App forms
As per my knowledge, there is no native Power Apps way supported for showing SharePoint fields' Descriptions automatically inside the Power Apps forms.
Similar threads:
Power Apps connected form does ...
- 42.9k
1
vote
Accepted
Is there a way to make our SharePoint Lookup fields delegable inside Power Apps
Power Apps delegation supports SharePoint lookup columns with the primary lookup value (column selected under In this column option in lookup settings).
The additional (extended) columns/fields under ...
- 42.9k
1
vote
Accepted
Power Apps display mode all conditions must apply to enable drop down
If you want to enable drop down only when all conditions met, use below formula:
If(
Dropdown1_3.Selected.Value = "OK" &&
Dropdown1_4.Selected.Value = "OK" &&...
- 42.9k
1
vote
Is there any restriction on the number of "=" inside the Filter?
There is no restriction/limitation on using multiple conditions inside Filter function in Power Apps.
I just tried using same formula on SharePoint list with more than 35000 items and it is working ...
- 42.9k
1
vote
Accepted
Power Apps - replace position of First name and Last name in User().DisplayName
Set Text property of label control to:
Last(Split(User().FullName, " ")).Value & " " & First(Split(User().FullName, " ")).Value
Output:
- 42.9k
1
vote
Accepted
How we can move a Power App from DEV to PROD using exsisting solution
You have redeploy whole solution, follow below steps:
Go to solutions menu in DEV
Select your solution > select Export Solution option from top menu
Publish your changes
Export solution as managed ...
- 42.9k
1
vote
Accepted
Building a customized form in Teams site collection
Try following this steps:
Go to your list tab inside Microsoft Teams
Click on ellipses (...) at top and select Open in SharePoint:
When you open list in SharePoint, click on Integrate from top ...
- 42.9k
1
vote
Accepted
Sharepoint custom list with multiple content types, why the fileds will not be changed if we change the content type choice
When you are using SharePoint list forms in Power apps, fields will not change automatically based on selection of content type.
You have to use custom business logic to show/hide fields in Power Apps ...
- 42.9k
1
vote
Accepted
Power Apps, button to change required data cards to false
Create one variable in onStart of App object or in onVisible of screen control like:
Set(isRequired, true);
You can set initial value to true or false as per your requirements.
Then use this variable ...
- 42.9k
1
vote
Accepted
Power Apps, Patch and Lookup ID to update record
You are facing this issue because you are using SubmitForm function after Patch function.
SubmitForm is overriding the value you set using Patch function.
So, try using this:
SubmitForm(EditForm1_1);
...
- 42.9k
1
vote
Connect columns in SharePoint/relating columns from 2 lists on Power Apps/SharePoint
You can add a Text field and then apply the following formula to the control that reading a data from List1 :
LookUp(List2, RecordID = ThisItem.RecordID).ProjectName
That's it !
- 1,236
1
vote
Accepted
PowerApps, Update ThisItem value based on click of button
Try using formula like below in OnSuccess property of EditForm1_1 control:
Patch(
SPListDataSourceName,
EditForm1_1.LastSubmit.ID,
{
Status: VarProgress
}
)
Or use formula ...
- 42.9k
1
vote
Accepted
PowerApps Form Validation - Not on Submit
For your app, I suggest you create a separate "Validation Screen".
About Validation Screen
Here, get all the variables as output text (skip colors and formats, barebone minimal is the best) ...
- 36
1
vote
How do I detect if a SharePoint field is required in Power Apps?
Each field Card, in a Form control has a Required property.
This is an example of how you can take advantage of this property in a child control within a card:
Click on your control, for example, a ...
- 9,572
1
vote
Accepted
Set SP list column visibility in Power Apps
Use formula like below:
If(User().Email = "[email protected]", true, false)
OR:
User().Email = "[email protected]"
For multiple users:
User().Email = "[email protected]" || User()...
- 42.9k
1
vote
Accepted
How to check visibility for multiselect person field for feedback icon
To show/Hide icon/button based on if current user is part of multiple selection person or group column in SharePoint, you can use formula like below in Visible property of icon/button control:
User()....
- 42.9k
1
vote
Accepted
Sharepoint Customize Form substitute string in HTML text
Use formula like below for HTMLText property of HTMLText control:
Concat(Split(DataCardValue12.Text, " | "), "<a href='"&ThisRecord.Result&"'>"&...
- 42.9k
Only top scored, non community-wiki answers of a minimum length are eligible