cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Visable if status is true for this item in another datasource

ColorIf.pngI've got two datasources and one of them shows a gallery with basedata. In the other one, "Location" I've got one column "UI" that shows status for every item of the gallery; "true" of "false".

 

How do I get the blue circle visible if the status is true in the other datasource?

 

 

Please, if oyu like to help me, don't go to fast since I'm quite new to functions and Powerapps. I like to learn and understand about this just as much as get it done. 

 

Wish you all a pleasant weekend.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi!

Once again I've been helped by @hpkeong and this time he first showed me how to use Lookup and then, the mistery of "True" and "TRUE".

 

My app is about attendance at a after school center and I wanted the circle to be visible depending on:

1. if it was today (DateColumn)

2. the name of selected kid (Name)

3. and the class/department at the after school center. (Dep)

4. and the UI value was "true". 

 

Circle1.Visible =

If(LookUp(Location; DateColumn = TodayDate.Text && Dep= StartGallery.Selected.Result && Name = StudentTB.Text).UI="True"; true; false)

 

If(LookUp(datasource; condition1 && condition2 && condition3).ColumnOfInterest="True"; true; false)

 

Don't miss the capital "T" in "True"!

@hpkeong found out that in Excel it says "TRUE" but in the formula it's got to be "True". Otherwise it would work.

 

 

I hope this could be as help for someone else as it was to me. I love to learn!

 

Ola

View solution in original post

6 REPLIES 6
Community Champion
Community Champion

Hi Ola

 

Nice UI Design. Very professional look.

You had added circle to indicate when it is "true".

 

So, just "think from the circle's visibility" iteself, and you will get to what you want.

- Circle1.Visible = If(Toggle1.Value = true, true, false)

[Ignore the datasources, because you are only Showng on the screen (UI) and has no connection with the DS]

 

Hope I am correct.

 

Have a nice day even though weather in Europe is very cold.

hpkeong

Hi PK Hong

Thank you once again for all your support.

 

 

I'm afraid this doesn't work because I misslead you in my short description. This is the attendance app and the circle tell if a kid plays indoor or outdoor (true of false). The toogle in the picture turns green when the kid is present. 

 

As far as I understand I could either write a function that reads from the other datasource or develop your method and in some way add "thisitem". In that case I also need to now that the toggle always is updated.

When I tried  to change "Toogle1" to "Toogle2" every circle got blue.

 

 

Thanks for the kind word about the design. Well, I believe you appreciate a shadow in more ways than we do here up north. It's -10 C here today so we all want to see and feel the sun. Smiley Wink

 

Have a nice day

 

Ola

Hi @OlaH,

 

What is your current situation?

Do you need any further assistance on this?

And if you have any workaround, please feel free to share it here.

Besides, could you please share some more information regarding the data used, and the purpose of the controls/Icons (the circle icon and the toogle)?

What data are stored under the two tables used? 

If the circle here is only used to show the status of the item listed in the gallery, then we may take a try with the following method:

Change the Visible property of the circle icon with the formula below:

If(Isempty(filter(Anotherdatasource, Datasource.column=thisitem.StudentName)),false,true)

Adding the function reference:

Filter, search and lookup functions in PowerApps

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi!

Once again I've been helped by @hpkeong and this time he first showed me how to use Lookup and then, the mistery of "True" and "TRUE".

 

My app is about attendance at a after school center and I wanted the circle to be visible depending on:

1. if it was today (DateColumn)

2. the name of selected kid (Name)

3. and the class/department at the after school center. (Dep)

4. and the UI value was "true". 

 

Circle1.Visible =

If(LookUp(Location; DateColumn = TodayDate.Text && Dep= StartGallery.Selected.Result && Name = StudentTB.Text).UI="True"; true; false)

 

If(LookUp(datasource; condition1 && condition2 && condition3).ColumnOfInterest="True"; true; false)

 

Don't miss the capital "T" in "True"!

@hpkeong found out that in Excel it says "TRUE" but in the formula it's got to be "True". Otherwise it would work.

 

 

I hope this could be as help for someone else as it was to me. I love to learn!

 

Ola

View solution in original post

New Member

If you have multiselect dropdown values and you want to have conditional visibility you can use the following condition in visible property of that Card or whatever,

 

If(CountIf(DataCardValue.SelectedItems,Value="Selection Required")>0,true,false)

Frequent Visitor

Hi there, 

 

I had the same issue and the workaround that worked for me was adding a field such as title to a collection for the toggle OnSelect, then for the blue dot change the visible if in the collection.  Screenshots below, hope that helps!

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (95,396)