Questions tagged [formula]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

SharePoint list validation formula based on created and modified dates no longer evaluates as FALSE ever

To clarify, the formula below is for list validation and not field validation: =IF(OR(NOW()<[Created]+(1/1440),NOW()<=[Modified]+(10/86400)),TRUE,FALSE) This checks for the following conditions:...
Scott Olson's user avatar
1 vote
2 answers
35 views

Not sure I am doing this right and need help. If Column B is blank Column A should multiply by Column C. If Column B has info B need to multiply by C

Not sure I am doing this right and need help. If Column B is blank Column A should multiply by Column C. If Column B has info B need to multiply by C =IF([Column B]="IsBlank" AND, ([Column A]...
user110949's user avatar
0 votes
1 answer
24 views

SharePoint to show 'Working days left' and blank if other column is marked 'Complete'

I've been looking on this page and others can't seem to get exactly what I'm looking for, not sure if it is possible but I will ask. One column shows 'Delivery Date' so I've used the following to show ...
Adam Richardson's user avatar
1 vote
1 answer
19 views

SharePoint Lists - edit columns not hiding/showing

I have a choice column named "Catalogue". one of the choices is Digital. I have another choice column named Digital Strategy Areas that I only want to show when Digital is selected from ...
knowlec's user avatar
  • 13
0 votes
0 answers
446 views

Adding bold and underline in a Power Apps formula

I have a formula (see below) to append comments in Power Apps. It is under "default" in the card. I am struggling to get "User().FullName & " " & Now()" of the ...
Ulcsmarine001's user avatar
0 votes
0 answers
27 views

Formula Help Needed: Calculating Dates to Exclude Weekends

I am trying to set up several dates on a list in SharePoint. The dates all relate to each other, and I want to exclude weekends when calculating these dates. I have three date columns: “Request Date” -...
Sara Lons's user avatar
1 vote
1 answer
22 views

Solution for Creating a Formula that Utilizes Two Separate Columns As Conditions For The Output of a Calculated Column

Hi SharePoint experts, I have two columns in a Sharepoint List, one titled "Budgeted Amount" and the other "Contract Expiration Date". What I'm trying to do is create a calculated ...
Ryan's user avatar
  • 13
1 vote
1 answer
24 views

Calculated Column: Nested If

I am new to SharePoint and I'm trying to enable a calculated column in a SharePoint list with the following formula but it's not working quite well. It is not throwing me any Optimize nor Test ...
Mariana's user avatar
  • 11
1 vote
2 answers
194 views

Use variable in expression:

I would like to add a dynamic variable in addDays function named Czasookres his value is equal 14 days. How can I insert this variable and is that possible ? Examples: addDays(utcNow(),Czasookres) - ...
Cutmaster's user avatar
1 vote
1 answer
267 views

Sharepoint Calculated column - not working

The column titled "has submission gone" has a formula, see below: =IF([Date of Submission]<=TODAY(),"Yes","No") The column Submission Gone will have yes or no, so if ...
Wayne's user avatar
  • 13
0 votes
2 answers
424 views

How can I write an Expression to get an Item from an Array using an Array property value?

I have this flow : Where I am building an array which contain those properties: ID SharingLink Password then I am building an HTML table >> so how can I get the Array's SharingLink values ...
microsoftdeveloperdesigner's user avatar
1 vote
2 answers
40 views

Make a column display only when data is in it

I am trying to make a column display only when data is entered in it. If it has no data, then the column should not display on the page. I tried this formula, but it isn't working. I will appreciate ...
erron522's user avatar
0 votes
1 answer
256 views

In Power Apps, how do I refer to the application in code?

Let's say I have an application, "My Power App", in Power Apps. How, in code, do I get the property "My Power App" to put it in a log, for example? Power Automate has the workflow()...
CigarDoug's user avatar
  • 1,063
0 votes
0 answers
94 views

Power Apps - generate days of month and exclude Holidays

I'm creating App in Power Apps for generating Work days in gallery. So I created a collection: ClearCollect(colWorkDays,First('WorkDays')); After that created an array with dates of Holiday: Set(...
Novice's user avatar
  • 139
0 votes
1 answer
188 views

Field A in the Power Apps should be only visible AND required if Field B (Number) starts with 6 or 7 in power app

Field A in the Power Apps should be only visible AND required if Field B (Number) starts with 6 or 7 in power app.
ABC's user avatar
  • 1
0 votes
1 answer
641 views

Power Apps display mode all conditions must apply to enable drop down

I am using below formula to enable/disable drop down. Formula appears to be correct but only works on the first condition. I need all conditions to apply to enable dropdown. Any ideas? Thanks. If(...
Jose1978's user avatar
  • 103
0 votes
1 answer
2k views

Power Apps - replace position of First name and Last name in User().DisplayName

My problem is that my Azure Active Directory show DisplayName attribute as First name + Last name. My goal in Power Apps in Label text, show User().DisplayName as Last name + First name. If i use ...
Novice's user avatar
  • 139
0 votes
1 answer
955 views

How to get the 3rd element after doing a split

I have this formula to concatenation and get the last element after doing a split:- concat(body('GetRootFolder')['d']['ServerRelativeUrl'], '/', 'Closed','/',last(split(items('Apply_to_each'),'#;'))) ...
John John's user avatar
0 votes
1 answer
479 views

Power Apps, button to change required data cards to false

I am trying to switch all required datacards to false with the click of a button. In SharePoint they are NOT required. but I cant seem to get this to work, any tips? Q1_DataCard1.Required=false; ...
Jonnyboi's user avatar
0 votes
1 answer
2k views

How to extract ONLY numbers from string using Power Automate

I have free text column in Dataverse table where alphanumeric values are entered e.g. abc123, 123abc, 1abc23. (numbers can be anywhere in string - no fix pattern) I want to extract ONLY numbers and ...
Guy World's user avatar
1 vote
2 answers
55 views

SharePoint Online - Calculated Column

This is my first attempt at this and I'm getting syntax errors. What I want is a column that has a conditional value based on another column "Probability". I have tried a few variations with ...
Kerry McIlwain's user avatar
0 votes
1 answer
150 views

Set SP list column visibility in Power Apps

I have a column called "Approver" in SP's list and I want to make it only visible to a limited number of people by their Email addresses. I made a custom form in Power Apps and tried to set ...
ruslan88990's user avatar
0 votes
1 answer
163 views

How to check visibility for multiselect person field for feedback icon

HR list schema HRname vacancy Panelmembers Status John Job1 Joy;Josesph;Smith processconclusion My query is when HR modify status Processconclusion and he enter Panelmembers ...
Bzl's user avatar
  • 39
0 votes
1 answer
49 views

copy button should patch when textbox value is entered and attached code

Below is my code when I click copy button Set(varrecord,Gallery2.Selected); ForAll( Filter( Gallery2.AllItems, Checkbox1.Value ), Patch( Roster, Defaults(...
Bzl's user avatar
  • 39
0 votes
2 answers
23 views

How to express this condition in SharePoint Calculated field

How to express this condition in SharePoint Calculated field? A field should have a result of yes or no with below condition: If ALL the fields value is completed answer should be No, else Yes.
jeanggerr's user avatar
1 vote
1 answer
266 views

Hiding the field/data card from everyone but the user who created the item

I would like to hide a data card from everyone but the user who created the item and have been using this code: If(ThisItem.'Created By'.Email = User().Email, true, false) But this doesn't seem to ...
NK711's user avatar
  • 41
0 votes
1 answer
42 views

Power Automate flow - substring Expression with condition

i have big trouble with simple expression with substring. My goal is merge two sharepoint list to one excel table. And problem is when value is empty that flow crash. is possible create expression ...
Novice's user avatar
  • 139
1 vote
1 answer
5k views

Combine Filter with Distinct function

Power Apps question: Input: Our SharePoint list: Team InvoiceNumber Microsoft 2002 Microsoft 2002 Google 2003 Google 2003 There could be few records in the table related to 'InvoiceNumber'. 1st ...
Oleksii Bublikhead's user avatar
0 votes
1 answer
2k views

PowerApps - Hide a Button if current user = created by

I have a PowerApps form (customized from SP list). I need to only have a Submit button visible if the Current User is the creator (created by field in SP). Basically, I only want the person ...
Chris's user avatar
  • 393
1 vote
1 answer
823 views

List validation to make multiple fields mandatory if dropdown meets condition

I've tried a plethora of solutions from other posts, however I am having no luck. I would like to make FieldA, FieldB, and FieldC required if Dropdown1 is set to 'WON' when creating an item in my ...
Ellie's user avatar
  • 13
0 votes
1 answer
371 views

Use Metadata field in formula

It seems that SharePoint didn't allow Managed Metadata columns to be used in calculated fields something like a decade ago. Is there a way to add metadata field/column in a calculated column's formula ...
serge's user avatar
  • 133
1 vote
2 answers
2k views

last record on a gallery

I'd like to display last record value from a gallery. Gallery is filtered by dropdown. Using: Last(Gallery3.AllItems,Quality_score= Dropdown2_2.Selected.Value) Any ideas? Thanks.
Jose1978's user avatar
  • 103
1 vote
2 answers
171 views

SharePoint list calculated column 3 validations for IF statement

I have a SP list that contains software installation data. There is a calculated column that calculates price. There is a column called Installation Date which has 2 choices either Before Sep 30, 2020 ...
Somesh P's user avatar
0 votes
1 answer
351 views

Custom Form problem with formula to check duplicate values which are already in the list

I have problem to solve simple formula. Custom form has many inputs, but I need check three of them if aren't this combination saved in the list already. If yes, need to show text with warning. first ...
Novice's user avatar
  • 139
0 votes
1 answer
4k views

Comparing two text inputs values in Power Apps

I want to compare to text input values. The result shows as "on track" or "off track". Formula: If(Value(TextInput1_1.Text)> Value(TextInput1.Text), "ON TRACK", If(...
Jose1978's user avatar
  • 103
0 votes
1 answer
26 views

Calcualted column is returning "#Name?"

I have the following formula for a single line of text Calculated column named ShowInApp: IF(OR(Status="Inactive",ISBLANK(Status)),"Hide",IF(FIND("Pending",[Category]),&...
John John's user avatar
0 votes
1 answer
4k views

PowerApps Form - Condition for changing value of text field based on drop-down

I have a PowerApps form with a Workflow that keeps firing off multiple emails because of how the fields are set up. I'd like to have one text field that will change its value based on three other ...
Chris's user avatar
  • 393
0 votes
1 answer
152 views

Power Apps, Drop Columns formula help

I am trying to drop columns so I can get my browse gallery working properly. However my formula is not working properly. I get error: There is an error in this formula. Try revising the formula and ...
Jonnyboi's user avatar
1 vote
2 answers
782 views

Adding Calculated Column to List to sum values in columns while ignoring blanks

I have a questionnaire that populates a SharePoint list. There are a number of questions that return answers as picked from a choice column. I have a calculated column that I'm trying to get to return ...
MH5's user avatar
  • 13
1 vote
3 answers
464 views

Calculated column to calculate approved status workflow

How to use calculated column to calculate approved status workflow? I tried this but it doesn't work. IF([Approve status]="Pendding", 1, 0)
Bloom 's user avatar
  • 23
2 votes
1 answer
2k views

Power Apps, SortByColumns, matching Dropdown choice to Column Name

When I try my formula in browsegallery, I am only seeing data for the drop down CAATT ID and Requestor. I cant find out why my other dropdown choices arent working here. Could it be column type? or ...
Jonnyboi's user avatar
1 vote
1 answer
82 views

Create column that is filled automatically (depending on another columns)

I am working with a SharePoint list that contains information about new employees. One column represents the StartDate, another column the EndDate (according the contract). In my company we have two ...
Zeinab Elhad's user avatar
1 vote
1 answer
273 views

List Validation with IF & LEN

SharePoint Guru's please guide me to complete List request. Requirements: I have been creating a List for doing User Audit Manager has to select the Choice either Approved or Rejected under Access ...
kirubakaran J's user avatar
0 votes
1 answer
2k views

Conditionally trigger flow based on the previous value stored in the column

I have an OrderQuantity column in the SharePoint Online list, and I want to trigger the flow on the column value - For example, right now OrderQuantity has a value as '3', now if the user enters other ...
SP 2022's user avatar
  • 4,064
0 votes
1 answer
1k views

Filter on Showcolumn & distinct, inside my Power Apps formula

I have this formula which is working correctly: ClearCollect( colUniqueDates, AddColumns( RenameColumns( Distinct( 'Grant Applications', ...
John John's user avatar
0 votes
1 answer
763 views

Power Apps, Dropdown choice for column, Ascend/Descend based on Column choice

I have a power app, I have listed my columns in the Item Section of a drop down: How can I alter my Browse Gallery to Sort by Ascending/Descending based on my dropdown choice? Current Browse Gallery ...
Jonnyboi's user avatar
0 votes
1 answer
379 views

Power Apps, TextSearchBox not searching for my String + integer field

I am trying to search my field "Title" which contains a combination of string + numbers. I.e. "Stack-1234" is a record in my field "Title". Items in BrowseGallery1: If(...
Jonnyboi's user avatar
0 votes
2 answers
388 views

Contain function with double quotes

I need to find a string which has double quotes (") in it: "userId": "xyz-bdd2-06870916684f" within another string to use it as condition in a filter action. The userId is ...
Der_Fab's user avatar
  • 177
1 vote
1 answer
4k 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 ...
Gui Gomes's user avatar
1 vote
1 answer
336 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([...
Az Hughes-Jackson's user avatar