6
votes
Accepted
Percentage formula showing extra numbers
Try to use Round function to rounds a number to a specified number of digits.
Round Syntax = ROUND(number,num_digits)
Where the num_digits the number of digits to which you want to round the number.
...
- 45.4k
3
votes
Accepted
Power Apps change Image based on field value
You have to nest the If statements. What that does is, if the criteria for the first condition evaluates to false, instead of having a value for a false result, you have another If statement to ...
- 12.6k
3
votes
3
votes
Accepted
PowerApps - Hide a Button if current user = created by
If you want to show the button based on condition, set "Visible" property of button control to:
User().Email = ThisItem.'Created By'.Email
OR
User().Email = datacardvalue49.Selected.Email
...
- 42.8k
2
votes
SPO Calculate the difference between two dates
This question might help. The accepted answer says to just put your current column formula inside ROUND:
=ROUND([your formula here],0)
- 268
2
votes
Accepted
How to launch home page on Power Apps Forms submit button Click in same tab?
The mentioned methods do not work for SharePoint custom forms, as is shown in the UserVoice post.
And also quoting the community announcement post:
LaunchTarget does not work in embedded apps, such ...
- 4,502
2
votes
Accepted
Power apps visible text
Set visible property of label control to:
Not(Dropdown1_1.Selected.Site <> "Please Select")
Update from comments:
As @RobertLindgren suggested, below should also work for you:
...
- 42.8k
1
vote
Accepted
Power Apps, Dropdown choice for column, Ascend/Descend based on Column choice
Use formula like below in items property of gallery control:
If(
Toggle2.Value = false,
SortByColumns(
Filter(
[@'Documentation Tracker'],
Or(Lower(...
- 42.8k
1
vote
Accepted
Power Apps, TextSearchBox not searching for my String + integer field
Try using this formula in items property of your gallery control:
If(
Toggle2.Value = false,
SortByColumns(
Filter(
[@'Documentation Tracker'],
Or(Lower(...
- 42.8k
1
vote
After submit, PowerApps field blank when viewing/editing
You have two choices to do :
Either you apply for each new load for the new form the following function :
OnVisible : NewForm('YourFormName')
Either you apply OnSuccess Property of your form the ...
- 1,236
1
vote
Accepted
Fill gallery rectangle based on value power apps
Try using below formula:
If(ThisItem.'Risk Status'.Value = "OPEN", RGBA(235, 130, 125, 1), ThisItem.'Risk Status'.Value = "CLOSED", RGBA(115, 205, 170, 1), ThisItem.'Risk Status'....
- 42.8k
1
vote
Accepted
Power app formula
Use below:
If(IsBlank(TextInput7.Text) || IsBlank(TextInput1_4.Text), Disabled, Edit)
OR
If(Or(IsBlank(TextInput7.Text), IsBlank(TextInput1_4.Text)), Disabled, Edit)
- 42.8k
1
vote
Validation on column between 2 values
SharePoint Column Validation Examples for your reference:
https://techtrainingnotes.blogspot.com/2015/10/sharepoint-column-validation-examples.html
- 3,267
1
vote
Accepted
SPO Calculate the difference between two dates
Use the formula.
int(triggerBody()?['DateDif'])
- 4,271
1
vote
Accepted
How to hide a SharePoint list column if its own value is empty?
Please the following steps:
Step1: Select an item in the list to open the "Edit Form" panel
Step2: On the "Edit Form" panel, click on "Edit columns" link
Step3: On the &...
- 2,827
1
vote
Accepted
How to copy single list attachment (as image) into the thumbnail/image column
Neither the new Image column or the Hyperlink or Picture column can be directly updated using flow.
A workaround is to use Send HTTP request to SharePoint action to update Hyperlink or Picture field.
...
- 4,502
1
vote
Power apps button & dropdown
A few things you should notice:
There is no Selected property for Button control.
As far as I know, you can only configure one-way action on one button control, there is no “release” or “unselect” ...
- 4,502
1
vote
Accepted
Power apps button & dropdown
Add this formula on OnVisible property of Screen:
UpdateContext({ddDefaultValue: ""})
Then set Default property of dropdown control to:
ddDefaultValue
Add below formula on OnSelect ...
- 42.8k
1
vote
Validation for 2nd monday from today
Here is the Form validation formula:
=IF(NOT(ISBLANK(DueDate)),IF(DueDate>(TODAY()+(7-WEEKDAY(TODAY(),2)+1+7)),TRUE,FALSE),TRUE)
Find days from TODAY() to the first Monday using WEEKDAY(date,...
- 2,142
1
vote
Assessment Calculator in Power Apps
The logic would be a lot easier to achieve in a SharePoint list - using Calculated column.
Although I do not recommend writing the logic all in PowerApps since it increases the loading time ...
- 4,502
1
vote
Accepted
Formula for swapping the choice in a drop down with a numerical value
Try below formula in your calculated column:
=IF([Choice]="Doesn't align to current priorities","0",IF([Choice]="Somewhat aligns to current priorities","5",IF([Choice]="Aligns strongly with current ...
- 6,748
1
vote
Accepted
How to enforce to input value from another column?
Try below formula:
=IF([Choice]="Banana",IF(OR(ISBLANK([Start date]),ISBLANK(End date)),false,true),true)
This satisfy the condition: If [Choice] is equal to "Banana" then user cannot leave Start ...
- 42.8k
1
vote
Formula IF time between ranges (Calculated column)
"9:35:00 AM" is not a date or a time. It is just text. In any case using ">" will have issues with one and two digit times. ("12" is less than "9" when compared as text.) The TIME function creates a ...
- 6,807
1
vote
Accepted
SP Online Flow add() syntax
The syntax for add function is like below:
add(<summand_1>, <summand_2>)
Where, <summand_1>, <summand_2> should of type Integer, Float, or mixed.
Reference: Flow - add() ...
- 42.8k
1
vote
Accepted
Help with Traffic Light SharePoint Calculated Formula
Use below formula:
="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Review Status]="Approaching","Green",IF([Review Status]="OverDue","...
- 42.8k
1
vote
Accepted
Calculated Column Depending on Different Column Value
Try using below formula:
=IF([ChoiceField]="New York","Person1",IF([ChoiceField]="Florida","Person2",[ChoiceField]))
This formula is similar to:
if(ChoiceField === "New York") {
CalculatedValue ...
- 42.8k
1
vote
Remove all commas from single line of text field
SharePoint JSON formatting now supports replaceAll operator which you can use to remove all commas from a single line of text.
Example:
{
"$schema": "https://developer.microsoft.com/...
- 42.8k
1
vote
Date validation to specific year for list Column in view
You need change the validation formula to this:
=TEXT([Data documento],"yyyy")="2018"
Try to use this in list validation. Go to list settings-> validation settings:
- 5,181
1
vote
Accepted
List Validation settings Error in Formula
I don't know all your requirements. But I guess you want "Billing Status" field to be mandatory if "A La Carte" is equal to "Yes"(Correct me if I am wrong).
In this case you need to use below formula:...
- 42.8k
1
vote
Accepted
InfoPath If Statement
Make sure you've got the appropriate spaces between terms. So between any [Field] or any operator (+,*,/), and I think your parenthesis, too?
Your syntax looks correct to me. If the spaces doesn't ...
- 1,745
Only top scored, non community-wiki answers of a minimum length are eligible