Get List ID

(0) Share

Report

Posted on by iwonder

1,146

Thank you for taking the time to read my question.

I have a few lists in my SharePoint site. I also have a PowerApps app that adds records to one of the lists. I want to secure my data so I've added 2 groups to my SharePoint site. DataReader and DataWriter. Users are in DataReader so that they cannot go to the SharePoint site and edit the data.

What I want to do is use a Flow to add the data to my SharePoint list. To do this I want to send the users name to the Flow from my app, then I want to Grant them permissions to the list, add the record, then remove their permissions.

In Flow I see:

1. Grant Access to and Item or Folder

2. Stop Sharing and Item or File

In both cases I'm asked for an ID. I'm guessing this is the ID of the list in my SharePoint site. This value must be an integer not something from the URL of the SharePoint site.

I have no idea how to get this ID. Any help would be greatly appreciated.

Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@iwonder The ID required here is the ID of the list item for which you want to grant access or stop access.
I see you the flow is getting triggered from power apps, so you can pass the ID as a parameter to the flow and then dynamically refer the ID in the actions.

Check this link https://www.c-sharpcorner.com/article/how-to-trigger-flows-email-on-button-click-in-powerapps/

which sends parameters from powerapps to flow.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

@iwonder The ID required is the Unique Id which is not an integer, it's a GUID. Also, I am wondering why granting permission before adding an item and then removing the permission. I am not sure whether this is the right way to do it. Maybe instead of doing this, you can hide the list from the browser. Use SharePoint designer and choose the settings for the list to hide it from the browser view. So when the user browse the site contents, they won't see the list.

Was this reply helpful? Yes No
iwonder 1,146 on at

Like (0)

Report
Copy link

Link copied!

Hi @jinivthakkar

Thank you for your reply. So these actions refer to the row level not the list itself?

Thanks

Was this reply helpful? Yes No
iwonder 1,146 on at

Like (0)

Report
Copy link

Link copied!

Hi @sudharsan1985

When I type in values into the ID field I get an error if I do not type in a whole number. If I type 1.2 I get an error, if I type D I get an error. If I type 5, no error.

The reason I want to do this is for data security. I don't want users going to the SharePoint site and editing the data in SharePoint directly. I need to control it through PowerApps. I also don't want them to be able to make their own app using the shared connection that they have access to and edit data that way. I need to ensure data security as these records will be used for audit purposes. So if I make this flow it will be that much more difficult for users to create a new app using the same connection to edit data. They can read it but not change it.

Thanks!

Was this reply helpful? Yes No