PowerApps: Applying multiple conditions (if statement) to onvisible property of a text box

%3CLINGO-SUB%20id%3D%22lingo-sub-1538587%22%20slang%3D%22en-US%22%3EPowerApps%3A%20Applying%20multiple%20conditions%20(if%20statement)%20to%20onvisible%20property%20of%20a%20text%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538587%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20powerapps%20app%20connected%20to%20a%20sharepoint%20list%20and%20I'm%20trying%20to%20compare%204%20inputted%20values%20to%204%20different%20columns%20in%20the%20list.%20I%20have%20it%20in%20the%20Onvisible%20property%20so%20if%20it%20matches%20any%2C%20a%20text%20box%20should%20become%20visible%20-%20like%20a%20popup.%3C%2FP%3E%3CP%3EThe%20conditions%20are%201)%20the%20drop%20down%20is%20the%20same%20as%20the%20sharepoint%20list%20title%20column%2C%3C%2FP%3E%3CP%3E2)%20The%20selected%20start%20time%20(Starttime)%20is%20inbetween%20the%20Start%20time%26nbsp%3B%203)%20and%20End%20time%20in%20the%20SharePoint.%3C%2FP%3E%3CP%3E4)%20The%20selected%20date%20is%20the%20same%20as%20the%20date%20in%20the%20sharepoint%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20code%20I%20have%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf(CountRows(Filter('Sharepoint%20site'%2C%20Text(Dropdown.Selected.Value)%20%3D%20Title))%20%26gt%3B%3D%201%3CBR%20%2F%3E%26nbsp%3B%20%26amp%3B%26amp%3B%20CountRows(Filter('Sharepoint%20site'%2C%20TimeValue(StartTime_Sharepoint)%20%26lt%3B%3D%20TimeValue(Starttime)%20%26amp%3B%26amp%3B%20TimeValue(EndTime_Sharepoint)%20%26gt%3B%3D%20TimeValue(Starttime)))%20%26gt%3B%3D%201%26nbsp%3B%3CBR%20%2F%3E%26nbsp%3B%20%26amp%3B%26amp%3B%20CountRows(Filter('Sharepoint%20site'%2C%20Date_Sharepoint%20%3D%20DatePicker.SelectedDate))%20%26gt%3B%3D%201%2C%3CBR%20%2F%3Etrue%2C%20false)%3C%2FP%3E%3CP%3EThe%20problem%20I%20have%20is%20it's%20not%20applying%20them%20all%2C%20as%20you%20can%20see%20in%20the%20below%20the%20pop%20up%20is%20showing%20when%20it%20doesn't%20pass%20all%20the%20conditions.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667286%22%20target%3D%22_blank%22%3E%40MSI_Powerapps%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1538587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1552183%22%20slang%3D%22en-US%22%3ERe%3A%20PowerApps%3A%20Applying%20multiple%20conditions%20(if%20statement)%20to%20onvisible%20property%20of%20a%20text%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1552183%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F729294%22%20target%3D%22_blank%22%3E%40emmamadigan1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20are%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20possible%2C%20some%20screen%20shots%20of%20your%20set%20up%20in%20PowerApps%20will%20help%20us%20to%20visualise%20your%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20you%20refer%20to%20a%20pop%20up%20but%20none%20was%20provided%20in%20your%20post%2C%20is%20there%20a%20screen%20shot%20of%20this%20pop%20up%20of%20which%20you%20speak%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi there,

 

I have a powerapps app connected to a sharepoint list and I'm trying to compare 4 inputted values to 4 different columns in the list. I have it in the Onvisible property so if it matches any, a text box should become visible - like a popup.

The conditions are 1) the drop down is the same as the sharepoint list title column,

2) The selected start time (Starttime) is inbetween the Start time  3) and End time in the SharePoint.

4) The selected date is the same as the date in the sharepoint list. 

The code I have is: 

 

If(CountRows(Filter('Sharepoint site', Text(Dropdown.Selected.Value) = Title)) >= 1
  && CountRows(Filter('Sharepoint site', TimeValue(StartTime_Sharepoint) <= TimeValue(Starttime) && TimeValue(EndTime_Sharepoint) >= TimeValue(Starttime))) >= 1 
  && CountRows(Filter('Sharepoint site', Date_Sharepoint = DatePicker.SelectedDate)) >= 1,
true, false)

The problem I have is it's not applying them all, as you can see in the below the pop up is showing when it doesn't pass all the conditions. 

@MSI_Powerapps 

 

1 Reply
Highlighted

Hi @emmamadigan1 

 

Hope you are well.

 

If possible, some screen shots of your set up in PowerApps will help us to visualise your problem.

 

Also you refer to a pop up but none was provided in your post, is there a screen shot of this pop up of which you speak?

 

Cheers

Damien