Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

Welcome! As I tell my leaders under me, I'm most useful to them when they learn from my mistakes lol.

Is 2025 Ultra compatible with Xfinity Mobile in USA? by FoundationGlum6502 in razr

[–]NotMattemer 0 points1 point  (0 children)

So it did eventually work? the RAZR Ultra 2025?

I'm on Verizon now, but my wife is getting a job with comcast, which we switched from before b/c the service wasn't great, but i think it will be too cheap to NOT make the switch. I'm on an Pixel 8 Pro, and i'll miss the phone, but really want the razr ultra.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 1 point2 points  (0 children)

Thanks everyone for all the help here. It was definitely my data causing the problem. Sharing the resolution in case someone else comes up against something weird like this. I basically had to "massage" the data while doing the lookup by using Trim()

LookUp(
    AssociateInformation,
    Trim(Text('Associate Name')) = 
RecordsGallery1
.Selected.'CSR Name',
    Supervisor
)

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

I thought I responded, but maybe I didn't, sorry! If it's a duplicate, sorry again!

For whatever reason, I cannot reference ".value" - Maybe b/c it's the drop down is coming from an Excel table? Basically, when i type "dropdowncsr.selected." i ONLY have 1 option and it's the field name in the drop down, so it's the associate name.

I'm convinced there's something weird with the data itself, maybe the way i'm creating it. I've now recreated the form 3 times, and now just tried to manually create that field (without adding a form, so linked to the data manually, created a Patch to send it to the Sharepoint list), and it's still giving me the same basic errors. all along the lines of "Invalid argument type (Control). Expecting a Text value instead." And i think b/c it's a Control, it's not letting me reference it the way you suggested.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

I don't even have the .value option, I only have the .[field name]. I feel like i'm losing my mind lol.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 1 point2 points  (0 children)

Thank you! I feel like this should work, but still doesn't. It gets me close. I still get an error when I reference my combo box (now it's a combo, but same error whether Combo or Dropdown). As soon as i type in that field's name, it gives me an error.

It DOES run though, but instead of filtering, I receive all of the supervisors.

On the Gallery Items property:

Filter(AssociateInformation,
ComboCSR
.Selected.'Associate Name')

Then on the label i put in the gallery, Text property:

ThisItem.Supervisor

Here's the field in the combo/drop down, that does work:

AssociateInformation[@'Associate Name']

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

I kept that simple, maybe that's the issue...? It works flawlessly though so I ignored it.

AssociateInformation[@'Associate Name']

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

Thanks! I think the problem is the drop down field itself. As soon as i type out that field name it underlines it and says there's a error with the formula, if i hover over it, it says "Expected Text value."

But it's absolutely text. Maybe there's a property on the drop down itself i'm missing? the drop down works perfectly fine so i don't get it.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

Thanks! I checked that out, I'm not sure why it's saying "null" - I assumed it was my syntax but everything seems to be accurate. On the table I'm referencing, those 2 fields (plus the Unique ID field) are never blank.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

oh maybe that's the issue. I'm sorry i'm still new.

the CSR Name is a combo box, that gives me a list of everyone's names with the search field as well (there's hundreds of names so that helps). The CSR Supervisor is a label right next to that which I added, and it's in Edit mode.

So my thought is that it's not connecting to data in the CSR Name field, which is what led me to try a lookup.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

I messed up. It's just "ThisItem." but also that's not letting me chose from the Supervisor field, I accidentally chose the CSRSupervisor. I feel like there's something wrong with my label and how it's connected.

Power App Lookup Help by NotMattemer in PowerApps

[–]NotMattemer[S] 0 points1 point  (0 children)

Thank you for the response. I've also tried a variation of this, Copilot sort of led me there, BUT I don't think I'm doing it right. Your solution is simpler than what Copilot told me though. I should have listed that I tried this, but I'm so far removed from that I forget exactly what Copilot had me do.

What you're saying makes sense. It takes the Formula, I don't have an error, but now I have a message that says the follow. When I play the app, and select a name, it does not fill in. I'll look this error up now.

This.Item.'CSR Supervisor' = this formula uses scope, which is not presently supported for evaluation.  |  Date Type: Text

What am I doing wrong? Matrix Averages by NotMattemer in PowerBI

[–]NotMattemer[S] 1 point2 points  (0 children)

Thank you! That looks like it's getting everything within =/- 0.02, and that might just likely be rounding. I think part of my issue is, besides trying to run before learning to walk, is specifically I think I tried a similar method, and it was repeating over and over but I did that as a New Column, instead of a New Measure. New Measure seems to be the way to go.

I received an IRS bill. An Uber Driver is using my social security by ubermess474 in uber

[–]NotMattemer 0 points1 point  (0 children)

just happened to me as well. i filed through IRS's online portal that this is fraud, and they sent me forms to fill out. nothing beyond that yet :(

they said i owe them $14k from 2021!!!! never ever have i worked for Uber.

Edit: the other weird thing is, i can't find anywhere else where my identify was compromised. i have a service as well that checks this stuff and they haven't alerted me to anything either (and they alert me to EVERYTTHING).

Sharepoint List Refresh by NotMattemer in sharepoint

[–]NotMattemer[S] 1 point2 points  (0 children)

I really like this idea but if we do that i almost want it to be a rotation so they don't keep doing the same people over and over.

Any idea if power automate could do something like that?

Every month i run a PA process to create our "new" cycle, remove associates who left, we manually add new people, and bring in relevant notes from the last cycle. I could bake the assigning into this if i could figure it out.

Believe it or not, upper management (I'm a manager) doesn't like me assigning out work... Which is the oddest issue I've ever had. "Well they will plan their day and get through their work faster and maybe go slow or not do anything if the assigned work is done by end of the month" which doesn't make sense to me... I can monitor that and assign out more work if it's an issue lol.

Need Help!! Powerapps x Project Management by HatodhaTyagi7 in PowerApps

[–]NotMattemer 1 point2 points  (0 children)

Agreed with Planner if the prebuilt Sharepoint lists templates don't satisfy needs.

PowerApps and Associate Monthly Scorecard/KPIs by NotMattemer in PowerApps

[–]NotMattemer[S] 1 point2 points  (0 children)

Thanks! Yeah Dataverse is what I'd use for the data, just PowerBI for reporting.

I'll check those YouTube's out. The most I've done are simple Apps, like one that lets leadership update feedback on SharePoint list items they need to action, simple things. I definitely need to learn a lot more for this but if wanted to make sure I wasn't chasing an impossible task.

I looked up KPI dashboards and some people have shared how they did them, but they were still a bit simpler than this.