Questions tagged [formula]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
24 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
16 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
19 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
10 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
54 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
83 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
1 answer
111 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
37 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
121 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
71 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
114 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
431 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
  • 101
0 votes
1 answer
1k 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
409 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
321 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
1k 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
50 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
132 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
119 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
41 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
0 answers
357 views

Get Jira issue id and description from power automate http json response of Jira query

Get Jira issue id and description from power automate http json response of Jira query. Trying to extract two values Jira Issue and Description from below JSON Jira query response using power automate....
user3754136's user avatar
0 votes
2 answers
22 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
191 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
21 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
3k 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
1k 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
  • 363
1 vote
1 answer
459 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
180 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
  • 121
1 vote
2 answers
1k 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
  • 101
1 vote
2 answers
151 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
290 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
3k 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
  • 101
0 votes
1 answer
25 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
  • 363
0 votes
1 answer
111 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
525 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
339 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
55 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
210 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
1k 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,014
0 votes
1 answer
875 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
601 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
303 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
275 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
  • 165
1 vote
1 answer
3k 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
241 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
2 votes
2 answers
2k 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, ...
Chris's user avatar
  • 363
2 votes
1 answer
14 views

SharePoint Validation Settings

I have a drop down with Not Started, In Progress, Completed, No Longer Needed as different options. I want to require In Progress Comments to be filled in when In Progress is selected. When Completed ...
user103408's user avatar
0 votes
0 answers
46 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 ...
MJI's user avatar
  • 1