3
votes
Accepted
Power Apps change Image based on field value
You have to nest the If statements. What that does is, if the criteria for the first condition evaluates to false, instead of having a value for a false result, you have another If statement to ...
- 12.6k
3
votes
Accepted
Power Apps: How do I show/hide a button based on a Text Input's length of its value?
Use below formula in Visible property of Button control:
Len(TextInputOne.Text)
Documentation: Len function in Power Apps
- 42.9k
2
votes
Accepted
Power apps visible text
Set visible property of label control to:
Not(Dropdown1_1.Selected.Site <> "Please Select")
Update from comments:
As @RobertLindgren suggested, below should also work for you:
...
- 42.9k
2
votes
Accepted
Embed PowerApp in SharePoint Online page and get URL
You cannot fetch the SharePoint page URL in canvas app directly.
However, while embedding Power app web link on SharePoint page, you can pass the query string parameter (¶metername=...
- 42.9k
2
votes
Accepted
Why Calculated column inside power app show zeros inside the decimal points
Your Parent.Default is possibly considered a Text data type.
Can you please try wrapping it in Value() and see if that helps?
Text(Value(Parent.Default),"[$-en-US]$#,###.00", "en-US&...
- 945
2
votes
Patch new record with lookup column Power Apps
Ideally you have to pass the item ID from lookup parent list as well in Patch function.
Example:
Patch(
'Site Inspections',
LookUp('Site Inspections', ID=1),
{
BranchLocationLookUp:...
- 42.9k
1
vote
Accepted
Branching in Power Apps Form to Hide or Show Fields Based on Any Dropdown Value
Assuming your DataCardValue10 is a multi-select combo box, you can put the below formula for each of your other data cards.
Use the below formula for the Visible property of ConsumerDataCard1:
If(&...
- 2,303
1
vote
Accepted
Power Apps, If statement for Single Line field
Remove the .Text part and use double quotes around the value (Submitted), like this:
If(ThisItem.Title = "Submitted", DisplayMode.Disabled, DisplayMode.Edit)
- 24.5k
1
vote
Accepted
Powerapps, Button with If condition
If Status column is of type "Single line of text", try using formula like:
If(ThisItem.Status = "Submitted", Navigate(BrowseScreen1, None), Navigate(EditScreen1, None))
This ...
- 42.9k
1
vote
Accepted
Disable mode Power Apps
Try using:
If(IsBlank(ComboBox1.Selected.Mail) && Not(IsBlank(TextInput1.Text)), Disabled, Edit)
- 42.9k
1
vote
Accepted
PowerApps Lookup function producing error
Try using this:
LookUp(Desks, DeskID = ThisItem.ReservedDeskID, Building.Value)
- 42.9k
1
vote
Accepted
Power app formula
Use below:
If(IsBlank(TextInput7.Text) || IsBlank(TextInput1_4.Text), Disabled, Edit)
OR
If(Or(IsBlank(TextInput7.Text), IsBlank(TextInput1_4.Text)), Disabled, Edit)
- 42.9k
1
vote
How to check a checkbox inside our canvas Power Apps?
You must assign true or false value to a variable in the OnStart and use that variable in 'Default' property of the checkbox content (It is not possible directly assign a value to PowerApps component)....
- 86
1
vote
Accepted
Fill gallery rectangle based on value power apps
Try using below formula:
If(ThisItem.'Risk Status'.Value = "OPEN", RGBA(235, 130, 125, 1), ThisItem.'Risk Status'.Value = "CLOSED", RGBA(115, 205, 170, 1), ThisItem.'Risk Status'....
- 42.9k
1
vote
Accepted
Power Apps: After Patch, text field is the only thing visible and no item is selected
To hide the text input and button control, try setting Visible property of text input and button control to:
!IsBlank(Gallery1.Selected)
OR
!IsBlankOrError(Gallery1.Selected)
Where Gallery1 is name ...
- 42.9k
1
vote
Accepted
Why isn't navigate function passing data to new screen?
Here's working solution I just tried at my end:
I have 2 screens (Screen1 and Screen 2)
"Navigate" button & "BarcodeScanner1" on Screen1:
"Label1" on Screen2:
I am ...
- 42.9k
1
vote
Power Apps/Power automate: invalid number of arguments recieved
I can't see what you are passing to the variable initialization, but my best guess is that you are passing a wrong parameter.
Most likely, var_Finename received the first parameter(HTML) instead of ...
- 9,572
1
vote
Accepted
Power Apps, Save as a PDF
Microsoft released printing feature in Power Apps couple of months ago.
Announcement: Print() screens in your canvas app
You can use Print() function to send any Power apps screen to a printer for ...
- 42.9k
1
vote
Accepted
Sharepoint/Power Apps, user can only see and edit own records within app
Try filtering items property of gallery control on "BrowseScreen" to something like:
Filter(DataSource, 'Created By'.Email = User().Email)
Where DataSource is your SharePoint list data ...
- 42.9k
1
vote
Accepted
Display a related record on a single PowerApps screen
It could be a couple of things:
RequestID is type number so you need to have RequestID=Value(DataCardValue12.Text) instead of RequestID=DataCardValue12.Text
Filter and Search both return a table/...
- 788
1
vote
Accepted
How to get SharePoint Online news in PowerApps
Create a flow based on SitePages library, when Promoted state equals 1 or 2, which means news post page, create new item with title and url to list:
Result:
- 4,197
1
vote
Created and Modified Time of ITEM in SharePoint List required in Milliseconds
You can use below formula on label control to show the Created field in specific format:
Text(ThisItem.Created, "mm/dd/yyyy hh:mm:ss AM/PM")
OR
Text(ThisItem.Created, "[$-en-US]mm/dd/...
- 42.9k
1
vote
Accepted
Created and Modified Time of ITEM in SharePoint List required in Milliseconds
Milliseconds cannot be retrieved, but we can retrieve created and modified time in seconds. Create two calculated columns and use the following formulas respectively:
=TEXT(Created,"MM/DD/YYYY hh:...
- 1,006
1
vote
Accepted
Clear People picker field in Powerapps
The right way to reset a form is to use the ResetForm() function:
Select your Form
Open OnSuccess property
Paste this code to reset the form:
ResetForm(YOUR_EDIT_NAME);
Back();
You can also reset a ...
- 9,572
1
vote
Accepted
Search with Sharepoint id in gallery
Try this using Value() function:
Sort(Filter(Master,StartsWith("ID",Value(Search.Text)),Created.Email=User().Email),ID,Descending)
In this case, user has to enter the valid number in search ...
- 42.9k
1
vote
Self contained powerapp forms/database?
There is no way using Power Apps you can save the data locally within the Power Apps.
Here's what you can do:
Create a SharePoint list where temporary data will be saved, when first time user saves ...
- 42.9k
1
vote
How i can build a Column Chart inside Power App for my sharepoint list
Not sure why you're selecting {Name} for your Labels of the Graph. I think, {Name} is empty in your SPO list and that's why not seeing values in the graph. You need to select the internal name of the [...
- 2,142
1
vote
Accepted
Power app IF statement
Try using this:
If(And(Dropdown2.Selected.Value = "YES", Dropdown2_1.Selected.Value = "YES", Dropdown2_2.Selected.Value = "YES", Dropdown2_3.Selected.Value = "YES&...
- 42.9k
1
vote
Show/Hide a button after searching in a textbox
Here is an example:
Button.Visible = !IsBlank(SearchBox.Text)
! means Not in the formula.
Reference: IsBlank.
- 4,502
1
vote
Accepted
Testing data clear in power apps
If you want to leave the controls empty after submitting, unlock the controls and then delete the values under Default properties, or it will return the default values even after being reset.
The form ...
- 4,502
Only top scored, non community-wiki answers of a minimum length are eligible