Unanswered

How is the better aproach to limit a user to add and see just one row?

(0) Share

Report

Posted on by mtmbiz

Hi everyone

I have a Power App with a supplier table where each supplier is responsible to mantain its self data. Then I want that each of then can add, edit and mantain just its table row.

In other words, users that are suppliers, could just add only one row in suppliers table, and could see just its row.

What is the better aproach to acomplish this behaviour?

Thank you so much,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

cmitchener on at

Like (0)

Report

Do the suppliers log in with company-specific emails (ex. user@mycompany.org), or with personal emails?

Was this reply helpful? Yes No
mtmbiz 12 on at

Like (0)

Report

Hey, your question takes me think that I can make the email field a unique key, isnt?

Was this reply helpful? Yes No
cmitchener on at

Like (1)

Report

Yes, that's exactly what I was going for! You can sort by every person's email individually, but this will become difficult if you have many suppliers. You can also use code to find company emails. For example, in my organization we sort the exact way you are, but we go based off of user's names. For us, one table might be:

Filter('My List', LookUp('My List', Title = User().FullName))

If you were going based off of email, you could do something like:

Filter('My List', LookUp('My List', columnName = User().Email))

This code will show a filtered version of the supplier table, if there's a field where you store a supplier's email that's what you'd want to sort by (I called it "columnName" here). You may have to do a little bit of work to the code depending on how you store the data, but let me know.

Was this reply helpful? Yes No