Questions tagged [formula]
The formula tag has no usage guidance.
70
questions
1
vote
1
answer
16
views
After submit, PowerApps field blank when viewing/editing
I am kind of new to PowerApps and will try to explain my situation below.
I have a field that is being populated on button click. The way I did this was to put VarFormStatus under text for the field ...
1
vote
1
answer
12
views
Calculated column to show negative number as zero
I have the below formula in a calculated column, which in some instances will return the number as a negative number (eg. -1234) how do get the formula to show the negative number as 0.
=IF(ISBLANK([...
2
votes
2
answers
60
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, ...
0
votes
0
answers
13
views
Add multiples formulas to validate columns in sharepoint online
I have several formulas that I need to join in a single formula to add it in the SharePoint column validation but at the list level, I can't join them to make them work.
I have these three formulas:
=...
0
votes
0
answers
30
views
SharePoint JSON formula for "Contains" value from another Column
I am trying to JSON format my SharePoint list updated by Power apps, my issues is while two columns appear exact that are not due to differing column types and the way the data is created. I would ...
0
votes
0
answers
16
views
Evaluate SharePoint Formula within a custom web part
I am building a custom web part and want to honor the conditional formula set to determine if the list field should be shown. The value I am interested in evaluating is set by selecting edit ...
0
votes
0
answers
22
views
SPOL Calculated Column Formula Help - Working Days
I’m trying to find the solution to 2 calculated column requirements. I have searched quite extensively and have only found partial, or partially working answers.
The two requirements are:
Work out the ...
0
votes
1
answer
15
views
extract characters from documents in sharepoint library
I have a sharepoint online library where I have some files which are names liked: AG_11-08-2021 or CE_11-08-2021 etc or FLASH_08-11-2022. It is always the same type of name, the first letters are here ...
0
votes
1
answer
44
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 ...
0
votes
1
answer
25
views
Send Rest API's Post Query which should be Sorted by formula
I am trying to send a request using SharePoint 2013 Rest API (POSTQUERY)
and my sort-list is a formula. When I am sending a GET request, it works fine as mentioned in below example:
http://localhost/...
1
vote
1
answer
109
views
IF statement in Dropdown
I'm trying to fill the blank label with a phrase when the dropdown is equal to SI, but it doesn't work and I don't understand why?
I put If(Dropdown1.SelectedText="SI";"¿Desde cuándo se ...
0
votes
1
answer
18
views
If Statment ( [DateTime in a Sharepoint Column] = Now (), Yes,No )
Curious to know if this is possible, i wish to create an if statment in a sharepoint calculated column where if the date in that row is equal to the time now than mark the column as yes.
The datetime ...
0
votes
0
answers
7
views
Search doesn't work in Browser Gallery
SortByColumns(Filter(Search(AddColumns(Journals,"FlatClientName", Text('Client Name'.Value),"FlatTrainerName", Text(Trainer.DisplayName)),TextSearchBox1.Text, "FlatClientName&...
0
votes
0
answers
33
views
Excel is reference by the Sharepoint Site name instead of Site URL
Recently migrated files into SharePoint Online via ShareGate tool.
There is an excel, which has many formula referencing to different excels. All hosted in same site (but different libraries) in ...
1
vote
1
answer
142
views
Check if a time is between two other times including minutes
I have a PowerApps form which contains an adjustable "Submission Date" field. Here is a screenshot to show what I mean:
I am trying to come up with a formula for a calculated column in ...
0
votes
1
answer
17
views
Power app formula
I am trying to disable the button, if two text fields are not completed.
I am using formula:
If( IsBlank(TextInput7.Text) or IsBlank(TextInput1_4.Text) , Disabled, Edit)
This is giving me error. Any ...
0
votes
1
answer
111
views
Power apps visible text
I'd like to make text disappear when dropdown selection is not equal to "Please Select".
Using formula:
IsBlank(if(Dropdown1_1.Selected.Site <> "Please Select"))
This is ...
1
vote
1
answer
13
views
How can I set a special format in a column or leave the field blank
I have a column that is called APC Standard. In this column I want to set the following format APCxxxx (APC + 4 numbers). I also want to have the possibility to leave the column blank.
I have already ...
0
votes
1
answer
1k
views
How to hide a SharePoint list column if its own value is empty?
Is there a way with SharePoint online lists, to hide a column if the user did not fill in a value for it? If so, how can I setup this conditional logic for the column to check against itself?
I have ...
0
votes
1
answer
467
views
How to copy single list attachment (as image) into the thumbnail/image column
I have SharePoint records in a list that are dynamically created with Power Automate. Once the record is created in my SharePoint Online list, how can I say...
Once the record is created, take the ...
0
votes
2
answers
36
views
Calculated field column
I am trying to compare two date columns in SharePoint. I need to update the created date field to a different date, but only on documents that have a scan date less than the created date. So I have a ...
0
votes
2
answers
408
views
Power apps button & dropdown
I need to set up a dropdown selection based on a button trigger. If button not selected, dropdown must remain empty.
Could anyone assist?
Using following syntax on the dropdown:
If(button1.selected, ...
0
votes
1
answer
139
views
Calculate SharePoint Column for unique expiry dates
I am building document library on SharePoint Online to store employee training certificates that can monitor their issued and expiry dates. The validity period for each certificate is different ...
0
votes
0
answers
23
views
Calculated (calculation based on other columns) IF OR ISBLANK AND Sharepoint Lists error formula
Can anyone help? I can't work out why this is erroring. this section =IF(OR(ISBLANK[Tech £]),"", at the start in bold makes it error.
=IF(OR(ISBLANK([Tech £])),"",IF(AND([Tech Pay ...
0
votes
1
answer
319
views
Extract the Name of the uploaded file into another columns with a flow
I want to extract the name of the file to another 6 columns.
For example, you want to put the "D" in the file name in the first column and the word "Berlin" in the second column, ...
1
vote
1
answer
37
views
My Calculated Field with a nested IF(OR) statement is returning error
I am trying to input an email address into a calculated field with the following formula (I have replaced proprietary information with generic information in this formula):
=IF(OR([Customer Name]=&...
0
votes
2
answers
1k
views
How to launch home page on Power Apps Forms submit button Click in same tab?
I have a list and we have customized the edit form in Power Apps. We have set this forms link in Email that we send to manager when new entry is added. He must review it and change status choice to ...
0
votes
1
answer
41
views
Validation for 2nd monday from today
I am new to SharePoint and I'm trying to do a validation for greater than or equal to the 2nd Monday from today.
I'm creating a work request form and I want to make sure they can't make a due date ...
1
vote
3
answers
115
views
Validation IF Column
I am stuck on a validation column, I need Date Effective From mandatory if Approval Status is equal to Approved and vice versa I need Approval Status mandatory if Date Effective From is not blank.
I ...
0
votes
1
answer
123
views
Assessment Calculator in Power Apps
I need to build an assessment calculator that will perform the following:
POINTS: 0.0 - 3.0
COST: $0.00 - $1000
ASSESSMENT RATING: LOW, MEDIUM, HIGH
Assessment logic:
If POINTS between 0.0 and 1.0, ...
0
votes
1
answer
5k
views
Multiple Or conditions with If - PowerApps
I have 3 individual checkboxes on my Power Apps form and would like to retrieve one value of the 3 checkboxes.
Currently I'm doing the below:
If('chkAll_1'.Value = true,'chkAll_1'.Text,"") ...
0
votes
1
answer
266
views
Dropdown sum powerapps
I would like to make a sum of all dropdown values into a label text box.
I am using following formula, but I do not understand where am I going wrong.
Can anyone assist?
I have also added a screenshot ...
0
votes
2
answers
33
views
SharePoint Validation Formula help needed
I need assistance with a validation formula for a list with 5 content types and 5 different outcome columns and I want to force the user to choose and outcome when the outcome date is chosen and vise ...
0
votes
1
answer
129
views
Calculate the difference between two dates in hours and minutes
In SP online in a list, I have a formula that calculates the difference between two dates and outputs the result in Days+Hours+Min.
I was wondering if it's possible to obtain the results only in Hours ...
0
votes
1
answer
20
views
Fomular to automate project final status
Please i need help. I need a formula on share-point online list. I have 3 columns namely: Child care status, Education status, Micro business status. Each of the columns above have (Completed, ...
0
votes
1
answer
22
views
Sharepoint List Column Calculation Nested Formula Failing
I have a column in my Sharepoint list that for some reason doesn't seem to be calculating properly, it does however work in Excel. I am trying to get the result to put a zero if the choice column is &...
0
votes
1
answer
29
views
Help with SharePoint List
I'm stuck here with this SharePoint List columns formula.
Probably there is a easier way of doing this.
I have a column with two choices, one for phone and other for laptop.
I created the columns but ...
0
votes
1
answer
19
views
Category and Subcategory formula in Sharepoint list and no coding
I am trying to create a calculated formula in Sharepoint List.
I like to create 2 columns(continent and country) with default country.
E.g. Continents are North America and South America. When you ...
1
vote
1
answer
45
views
Using AND function in SharePoint
I am trying to create relatively simple conditional column formatting in a SharePoint Online list.
This works (the conditions 1==1 and 2==2 are placeholders to simplify the example here):
{
"$...
0
votes
1
answer
499
views
Column Validation/Validation Settings, How can I add a formula where if one answers YES to one column it will require them to fill out certain columns
I have a sharepoint list where I have a series of questions.
The first question in the series is a YES/NO question, and it states if the answer is no, there is no need to answer the next few ...
0
votes
0
answers
59
views
Simple Scoring Setup for List
I am trying to set up a list with a scoring system that I currently use in Excel. I use the Excel sheet as a form with a series of yes/no questions. 100 points is the maximum amount and each question ...
0
votes
0
answers
65
views
Creating a sequential number on a SP online list
I thought this would a fairly straight forward problem to solve. My client needs a unique identify number for a list item and it has to be seven digits long and sequential. I thought there would be a ...
1
vote
1
answer
14
views
How do I dynamically choose the view form
I've got a SharePoint Online list that I want to use as a ticketing system. Users can submit a few different types of tickets. The various ticket types contain different fields, validation, etc. All ...
1
vote
1
answer
49
views
Formula for swapping the choice in a drop down with a numerical value
I've got a SP drop down column which contains options like:
Doesn't align to current priorities
Somewhat aligns to current priorities
Aligns strongly with current priorities
I want to assign all of ...
0
votes
2
answers
83
views
Format numberfield to currency
I have a SharePoint list and created a powerapp.
In the SharePoint list there is a field Kosten and the value 20 in powerapps looks like 20.0000000000000.
How can I change this to € 20,00 ?
1
vote
2
answers
45
views
How to enforce to input value from another column?
I've created 3 columns:
Choice:
Banana
Apple
Orange
2.Start date
3.End date
If you select "banana", then he/she must input value for "start date" and "end date".
I tried to input the formula ...
3
votes
2
answers
294
views
Percentage formula showing extra numbers
I'm trying to get a SharePoint formula to show a percentage of time remaining on a contract. I'm nearly there but it's showing a lot of numbers to the right of the decimal point. I've tried a few ...
2
votes
1
answer
44
views
Showing the time remaining between two Date columns as a perentage
I've got two columns 'Contract Commencement Date' and 'Contract End Date' and I'm trying to show the time remaining as a percentage in a third column.
Using Flow I've got a field to show todays date,...
1
vote
1
answer
59
views
SharePoint list validation formula
I need help with the following: I have 2 columns in a list and when "Yes" is selected in column 1, then "Yes" must be selected in column 2 also
What I need is:
If [column 1]="Yes", then [column 2] ...
1
vote
0
answers
22
views
I am trying to make a value limited RSVP System
I have been tasked with creating a list in SharePoint to let users pick one of three training sessions. Each training session must be limited to 50 users.
I've been leaning towards a list with a ...