web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trigger condition for ...
Power Automate
Answered

Trigger condition for Sharepoint list having one to many relationship

(0) ShareShare
ReportReport
Posted on by 301

I have SP list A and SP list B which has one to many relationship (parent - child relation) , I looking to create approval flows by giving permissions using http request .
Now the scenario here is I might be using Standalone Canvas App or SP customize form, user create a request then it goes for approval to Department Head(DH) , now the DH gets contribute permission and user gets read permission.

If the DH approvals the request then it goes to COCM group for approval and now here DH & User gets Read permission.

But if the DH or COCM group rejects , then the user can edit the record for which the user gets contribute access.

Now the permission we have to set to both the SP List.

How shall I create the flow or steps to achieve this ?

MHRW.png
Categories:
I have the same question (0)
  • Verified answer
    cchannon Profile Picture
    4,702 Moderator on at

    You can get very detailed permissions controls in SharePoint using the OOB Connector. It includes:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard