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

Two users one table same permissions

I have a power app which uses several dataverse tables. I have set up two users they both have the same permissions yet one gets the following error

 

Run.failed: The method 'Run' has an invalid value parameter 'GetGUID_Value'. 

 

However the other user the app and subsequent flow works as expected. 

 

Any help would be most appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions

I have found out the issue, and it makes me feel really silly. Turns out the user who had the problem was trying to put in the exact same details multiple times, one of which was set as a key field.

 

Thank you all for your help. Apologies.

View solution in original post

11 REPLIES 11
Sid_Jafri
Responsive Resident
Responsive Resident

Hi @Ben_C ,

 

Could you please share more details? It seems you are having issue in your flow where you get error message of Invalid parameter. You should check what value is passing to flow as parameter, it could be an issue of data type of parameter value. 

EricRegnier
Super User II
Super User II

Hi @Ben_C,

This doesn't look like a Dataverse table privilege issue. By flow do you mean Power Automate cloud flow or logic within you canvas app expression? As what point is the user getting the error? Screenshots would help 🙂 Cheers

Hello, 

 

Thanks for the responses, I've done a bit more investigation and it turns out when the user who is getting the error uses the app a record isn't being created in the table on dataverse which is the reason for the error as it's failing when trying to pass a value that doesn't exist.

And can you double check that these two users all have the same security roles assigned (there can be more than one). Are there some other logic for this record creation that can prevent from getting created? 

Hi EricReginer,

 

I created a custom security role for this app as it will be used by just one department and people outside of the department are not allowed to read or write to the tables. I've just checked and both users shared the same security roles apart from one project user, the user with no issues had project user the user with issues didn't, I've updated their permissions and currently waiting for them to be able to test.  

That’s probably the issue. Keep us posted 🙂

I've just tested it with the user who already had issues writing records to the dataverse table, sadly they are still getting the same error, I tested it also with another two members of their team, one in the same office and one in my office (different location both in the UK) they all had the same permissions, the other user in the same office got the same error, but the user in my office worked fine. This is getting even more confusing. 

Did you get to the bottom of it? Can you share more details? Screenshot of the app on the expression and the logic of creating that record will help. Hard to advise without knowing more context... Cheers

Ben_C
Helper III
Helper III

Hi Eric, 

 

Unfortunatly we haven't been able to get to the bottom of the error. 

 

So the background dataverse is set up into a main table (cases) and two related tables (fee and issues). The first screen in the canvas application creates the main record in the cases table and the code is as follows:

 

If(
    varNewCaseVisiable = false,
    SubmitForm(searchCase),
    SubmitForm(newCaseInput)
);
If(
    varNewCaseVisiable = false,
    Set(
        varCaseItem,
        searchCase.LastSubmit.CaseNum
    ),
    Set(
        varCaseItem,
        newCaseInput.LastSubmit.CaseNum
    )
Patch(
    Cases,
    First(
        Filter(
            Cases,
            CaseNum = varCaseItem
        )
    ),
    {
        CaseAdmin_Name: CaseAdminSearch.Selected.DisplayName,
        CaseAdmin_Email: CaseAdminSearch.Selected.Mail,
        ProdMan_Name: ProdManSearch.Selected.DisplayName,
        ProdMan_Email: ProdManSearch.Selected.Mail,
        LIP1_Name: LIP1Search.Selected.DisplayName,
        LIP1_Email: LIP1Search.Selected.Mail,
        LIP2_Name: LIP2Search.Selected.DisplayName,
        LIP2_Email: LIP2Search.Selected.Mail
    }
);

 Subsequent screens copy this code to an extent but points to fees and issues tables. The strangest thing about this is the user who has been getting the Run method error for the longest time has been able to write exactly one record in each table, two extra in the cases table but for these two extra records they couldn't write to the fees and issues tables, and now they can't write to any table. 

 

All users have exactly the same permissions to all tables. 

 

Thanks again for you help.  

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,700)