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 ...
Dylan Cristy's user avatar
  • 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
Ganesh Sanap - MVP's user avatar
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: ...
Ganesh Sanap - MVP's user avatar
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 (&parametername=...
Ganesh Sanap - MVP's user avatar
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&...
user79408's user avatar
  • 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:...
Ganesh Sanap - MVP's user avatar
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(&...
Dhruvil Prajapati's user avatar
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)
Robert Lindgren's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Disable mode Power Apps

Try using: If(IsBlank(ComboBox1.Selected.Mail) && Not(IsBlank(TextInput1.Text)), Disabled, Edit)
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

PowerApps Lookup function producing error

Try using this: LookUp(Desks, DeskID = ThisItem.ReservedDeskID, Building.Value)
Ganesh Sanap - MVP's user avatar
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)
Ganesh Sanap - MVP's user avatar
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)....
Jeffin Jacob's user avatar
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'....
Ganesh Sanap - MVP's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
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 ...
Denis Molodtsov's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
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/...
Murilo Santana's user avatar
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:
Julie_MSFT's user avatar
  • 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/...
Ganesh Sanap - MVP's user avatar
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:...
Allen_MSFT's user avatar
  • 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 ...
Denis Molodtsov's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
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 ...
Ganesh Sanap - MVP's user avatar
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 [...
Matiur Rahman's user avatar
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&...
Ganesh Sanap - MVP's user avatar
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.
Chelsea_MSFT's user avatar
  • 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 ...
Chelsea_MSFT's user avatar
  • 4,502

Only top scored, non community-wiki answers of a minimum length are eligible