Answered

Change Icon on gallery item depending on previous form submissions.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to change an icon on a gallery item representing information in one table depending on form entries for another table and running into 'This formula uses scope, which is not presently supported for evaluation.'

The gallery displays a list of projects from a project table, and the form links to a list of updates for those projects in a project update table. When the projects are updated by the current user for this week in the gallery, I want the checkmark to be visible.

I used a complex if statement, and while it doesn't throw a syntax error, I do get the scope error of death. I put the formula on the Visible option for the icon itself and is as follows:

If(ThisItem.Name in 'Project Updates'.Project, true, false)
And If(currentUser.FullName in 'Project Updates'.'Created By'.'Full Name', true, false)
And If(DateAdd(Today(),6-Weekday(Today(),1),Days) in 'Project Updates'.'Week Ending', true, false)

The weird thing is that the last if statement evaluates correctly, the middle one does not evaluate correctly, and the first throws the scope error of death.

Any help would be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Too complicated. A visible property will either be true or false. Your conditions reduce to

!IsBlank(ThisItem.Name in 'Project Updates'.Project)&& !IsBlank(currentUser.FullName in 'Project Updates'.'Created By'.'Full Name')&& !IsBlank(DateAdd(Today(),6-Weekday(Today(),1),Days) in 'Project Updates'.'Week Ending')

Each condition will reduce to true or false implicitly. Combining them requires all of them to be true for the icon to unhide. There is no need for an If() or the "true, false"'s assuming each element is true by itself.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for the response, but that is exactly what I'm hoping for. I want all of the tests to evaluate to true for the icon to show up. The problem is, the first one throws the scope error.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I don't know about the datasource used in your gallery and how it is filtered but if your are testing whether there is a row that contains a value for "Name" in the filtered dataset, then !IsBlank(ThisItem.Name) should be sufficient to test whether there is a "Name" in the row. If you are seeing whether "Name" exists in a dataset outside of the row, you will need !IsBlank(Lookup(anotherdataset, Name = ThisItem.Name))

Second, "Name" is a reserved word in PowerApps and may be causing some ambiguity. You should avoid using reserved terms to name your columns. See https://powerusers.microsoft.com/t5/News-Announcements/The-Ten-Commandments-of-SharePoint-in-PowerApps/ba-p/848842 #5

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That throws an error also, unfortunately. I really do appreciate your help on this. I know it is a complicated problem.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I think we are misunderstanding each other. I'm using data verse for my data tables. I'm trying to match the column/row value in one table to a column/row value in another table in my database. If it is true, display the icon on the item in the gallery.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You would use lookup() like !IsBlank(Lookup(anothertable , Name = ThisItem.Name))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It did not work until I refreshed everything. Thank you so much for your help!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Glad to help. You had me going there!

Was this reply helpful? Yes No