Unanswered

"This formula uses score, which is not presently supported for evaluation"

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a collection:

Collect(AssetTable,{ProjectLocation:"Here",ProjectNumber:1, PlantType: "Large", FacilityName:"Grit", FacilityNumber:1, Inspector:"JDS", InspectionDate:4/17/2020,InspectionType:"Process", AssetName:"Motor", AssetMake:"Honda", AssetModel:"Fit", AssetCapacity:"500gpm", AssetDimensions:"36in", InstallDate:1/1/1970, RefurbDate:1/1/1990, DesignLife:50, RemainingLife:1, Condition:1, Capacity:1, Reliability:1, Availability:1, Maintainability:1, AssetCompositScore:1, EffectiveLifeConsumed:1, ImminentFailureMode:1, AtRiskComponents:1, LikelihoodofFailure:1, Social:1, Sconomic:1, Environmental:1, COFScore:1, Criticality:1})

I wish to display in a gallery. I have the gallery's DataSource and Items property set to AssetTable and the labels within the gallery referencing specific columns in Asset Table. So the Text property of a label would be something like Text=ThisItem.ProjectLocation

This results in a blank display and the above error message. This problem has been posted before and I have not seen a solution other than switching to Boolean values in the data source, which isn't going to help me.

This is also the third time I've typed this due to this interface being cleared if you select certain buttons. 🙃

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

jKell 82 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous I just texted the collection and it seemed to work for me.

I put your code in the OnStart function of the APP. I clicked the '..." and ran OnStart function

Then set the Items property of gallery to your collection name "AssetTable". and am able to populate the text fields like you described.

Let me know what your question is, there doesn't seem to be an issue with your collection code.

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

Like (0)

Report
Copy link

Link copied!

Huh, thanks for taking a look! Here's what I'm getting. I may need to try deleting the gallery and starting over idk.

Was this reply helpful? Yes No
jKell 82 on at

Like (0)

Report
Copy link

Link copied!

I dont know if this could be causing problems. I notice you have image in your gallery, but your dataset doesn't.

Try changing your gallery to Title/Subtitle instead of Image, Title Subtitle.

When I type ProjectLocation I get "Here"

What happens if you look in you Collections from file menu? do you see data? I am suspecting that your collection isn't being populated.

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

Like (0)

Report
Copy link

Link copied!

My collection wasn't being populated. That issue was fixed. Thanks a lot! I'll try to mark as solution asap. It currently isn't working because javascript isn't enabled or something on my pc... sigh. Thanks again.

Was this reply helpful? Yes No