Works for everyone except for one guy

(0) Share

Report

Posted on by Mindea

174

We track projects in a PowerApp with a SharePoint list as the data source.

When a user creates a new project, PowerApps assigns a ProjectNumber by looking at the existing projects in the SP list, finding the one with the highest number and adding one.

This works great for everyone except for a user in Italy.

For example, adding a project today would assign "21-0042" as the next ProjectNumber, but the user in Italy gets "21-0001" -- he always gets 0001.

Here's the line that formulates the new ProjectNumber.

Right(Text(Year(Today())),2) & "-" & Right(Concatenate("0000", Text(Max(Projects,ProjNumInc)+1)) ,4)

Here it is separated into sections with explanations.

Right(Text(Year(Today())),2) //Get the right two digits of this year

& "-" & //add a hyphen

Right(Concatenate("0000", //Pad the result with zeros

Text(Max(Projects,ProjNumInc)+1)) //Get the Max entry in the ProjNumInc column (a number column) of the SP list and add 1

,4) //Trim the result so it's 4 characters.

How could it be this works for 15 users in various parts of the world except for one guy? Any help would be greatly appreciated.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

GarethPrisk 2,828 on at

Like
a
(0)

Report
Copy link

Link copied!

It would appear as though the Max(Projects,ProjNumInc) portion is resolving as a blank or error for that user. Hence it's simply appending a literal 1 each time, and giving you the resulting string.

I am not intimately familiar with how/when the functions are run differently for a different language user, but I would assume that it might be due to his PowerApps setting being in Italian, vs. English.

And to check - that user definitely has access to the SharePoint list? He didn't accidentally decline the connection or something silly?
Mindea 174 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @GarethPrisk Thanks for the response.
Yes, other than when creating a new project -- which for him yields a project number already in use -- the use can edit/save all other data in the PowerApps form/screen.
I'll try moving the Max function to its own line earlier in the process and store the result in a context variable.
It may take a day or two to hear back from the user, but I'll post here when I do.
Until then,
Verified answer

Mindea 174 on at

Like
a
(0)

Report
Copy link

Link copied!

I finally got an answer from the user. Based in Italy, he was using Edge with default language set to Italian. Once he changed the default language to English the new Project Number calculated correctly.

I find this hard to believe, but he's happy, and since the boss is not paying me to pursue this issue further, I'm letting it drop.