Questions tagged [formula]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
user avatar
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([...
user avatar
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, ...
user avatar
  • 173
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: =...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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/...
user avatar
  • 53
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 ...
user avatar
  • 11
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 ...
user avatar
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&...
user avatar
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 ...
user avatar
  • 1,203
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 ...
user avatar
  • 11
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 11
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 ...
user avatar
  • 1,309
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 ...
user avatar
  • 1,309
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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
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]=&...
user avatar
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 ...
user avatar
  • 1,126
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
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,"") ...
user avatar
  • 4,100
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
  • 21
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 &...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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): { "$...
user avatar
  • 15
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
  • 767
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 ...
user avatar
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 ...
user avatar
  • 767
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 ?
user avatar
  • 143
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 ...
user avatar
  • 13
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 ...
user avatar
  • 767
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,...
user avatar
  • 767
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] ...
user avatar
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 ...
user avatar