Power Automate - Using Flows

When approval status on any file on Sharepoint site is approved runs a trigger

(0) Share

Report

Posted on by Charlie Martharper

281

Hi guys,

Let me explain the SharePoint site i am working on.

It's a site with multiple subsites and libraries so what i want to do is whenever a file is created on any of those subsites and libraries I want to get the information modified in the master list in the main site.

So, the main thing I want is when the column "Approval status" which is one of the columns with 3 options SharePoint gives is Approved, send an email to me.

I am using sharepoint on premise so I cant use manual button flows so I thought this would be the best option. So the thing is how I create the trigger so it runs correctly with all the "Approved" files in all the subsites libraries. The trigger is the same on every library but it just changes the URL.

Is it possible to get it in just one flow or should I have to create one flow for each library or subsite.

Thanks

Categories:

Business Process Flows

I have the same question (0)

All responses (22)

Answers (0)

Suggested answer

Expiscornovus 33,052 Most Valuable Professional on at

Like (1)

Report
When approval status on any file on Sharepoint site is approved runs a trigger

Hi @CM-10101153-0,

Can you try the below trigger condition expression? And it would be a flow per library btw.

@equals(triggerOutputs()?['body/{ModerationStatus}'], 'Approved')

Was this reply helpful? Yes No
Charlie Martharper 281 on at

Like (0)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

@Expiscornovus

Hi, so I am trying that but the thing is the idiom of my SharePoint is different and that condition expression (I think) doesn't apply to mine.

@equals(triggerOutputs()?['body/{Estat_x0020_d'aprovació}'], 'Aprovat')

Where could I see the name of the column to add it correctly? It seems the one I added doesn't run the flow.

The column doesn't appear in the library settings:

This is how my flow looks but I don't know what the compose does in here.

Thanks for your time! @Expiscornovus

Was this reply helpful? Yes No
Expiscornovus 33,052 Most Valuable Professional on at

Like (1)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Hi @Charlie Martharper,

Normally you can find the internal name in several places. You can for example place the column in a Compose action and inspect the name via the Peek code option.

Ellis Karim also has a nice article about the other approaches as well:

https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Charlie Martharper 281 on at

Like (0)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Expiscornovus

Hi the thing is a predefined column (version settings) in SharePoint and is not on any of those places they show:

As you can see in the image below I can't click in the "Estat" column to see the internal name.

Let me know if there is any way to solve this. When turning it to "Aprovat" the flow doesn't run.

Thanks for your time!

Was this reply helpful? Yes No
Expiscornovus 33,052 Most Valuable Professional on at

Like (1)

Report
When approval status on any file on Sharepoint site is approved runs a trigger

Hi @Charlie Martharper,

If it is the Approval Status system column the internal name will be the same as in my example I shared earlier. This is because Microsoft has created it and they will always use the same internal names.

https://sharepointmalarkey.wordpress.com/2008/08/21/sharepoint-internal-field-names/

Only the values in your case will be translated (Approved vs Aprovat).

Can you try the below?

@equals(triggerOutputs()?['body/{ModerationStatus}'], 'Aprovat')

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Charlie Martharper 281 on at

Like (0)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Hi!

It still doesn't run... I don't really know what I am missing: I tried 4 times aproving 4 files, and it's not running.

Was this reply helpful? Yes No
Charlie Martharper 281 on at

Like (0)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Hi Expiscornovus!

So I found that the Moderation status is the next one look:

So I changed the flow to "When create file" --> Create item and get the information from the column Approval Status (_ModerationStatus) in the library to a column in a list.

List:

Library:

So I add the expression: triggerOutputs()?['body/{_ModerationStatus}'] in the create item action but doesn't run.

Do you know what its wrong doing it this way?

Was this reply helpful? Yes No
Charlie Martharper 281 on at

Like (0)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Hi @Expiscornovus !

So what I think it was missed was the "_" in the {_ModerationStatus}. But when doing tries none of them are running so I think that is not the internal name of the column or we get one wrong but it's supposed to be that one.

Are you getting it right when doing the same? I am getting no data returned because the trigger don't run :(

Was this reply helpful? Yes No
Expiscornovus 33,052 Most Valuable Professional on at

Like (1)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Hi @Charlie Martharper,

Not sure if this is because you are using a different language? I have double checked it in my setup and in my instance the field was without the underscore. I have seen it before with an underscore as well though 😅.

You can double check by just adding the field in a Compose, this is the easiest way to see what the actual name is.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Charlie Martharper 281 on at

Like (0)

Report

When approval status on any file on Sharepoint site is approved runs a trigger

Hi

The thing is it doesn't appear it automatically and I have to introduce it manually:

Look, when creating item, I want to add that column when creating the file, create an item with the column status. But when the trigger runs and its the turn to add the value, it ignores it and goes to the next one (Estat GD Value) look:

What is going wrong?

Was this reply helpful? Yes No