Power Platform Community Forum Thread Details

Modify Sharepoint Folder's permission when list is modified

Hello everyone,

I'm trying to create a flow but could not figure out how to do it. Could you please share your insight?

I have a sharepoint list looks like below. This list contains information who should have access permission to which sharepoint folders. When 'Recipient' column is updated, the permission of the associated folder should be automatically updated. And once the permission was modified, 'Recipient' column will be copied over to 'Before' column.

The SharePoint Path will he https:xxxx.sharepoint.com/sutes/Test271/Shared Document/Watermill/[Title]/[CompanyShortName]/[ReportType].

For example, steve@example.cm and alex@example.com should have access permission to the https:xxxx.sharepoint.com/sutes/Test271/Shared Document/Watermill/01. Steel/ST/Periodic Report.

The flow will be triggered when this list is modified. The below is the flow I created so far (still missing some actions). Each Compose value under 'Apply to each' returns the value I wanted, but I do not know how I can use 'Current item' to proceed.

Here is how output of Apply to each. In this example, column 'Recipient' and 'Before' does not match on 2 rows, therefore, this loop returns two results.