Questions tagged [formula]
The formula tag has no usage guidance.
112
questions
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 ...
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” -...
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 ...
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 ...
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) - ...
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 ...
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 ...
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 ...
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()...
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(...
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.
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(...
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 ...
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'),'#;')))
...
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;
...
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 ...
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 ...
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 ...
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 ...
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(...
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....
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.
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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(...
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]),&...
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 ...
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 ...
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 ...
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)
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 ...
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 ...
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 ...
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 ...
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',
...
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 ...
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(...
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 ...
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 ...
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([...
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, ...
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 ...
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 ...