Unanswered

Getting the modified columns data from sharepoint and notifying in email.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

MyFlow MyFlow

Basically I have a trigger i.e. when an item in Sharepoint is modified ,i get an array of object with all the data,wherein the value of not modified items is set to false and modified items are set to true.I want to get access to all the keys that have values true.And then i want to mail these modified keys.Please provide me with the solution.

Thanks,

Bhoomika N

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!
HI @Anonymous

When the file is changed, you get an object that contains a set of other key/pairs that are mapped in the "Value" that you see there. Since you need to indicate what object you want to get the data by using its name, you only have 2 choices:

Have an array of keys that you want to check if they are true or false.

Create Conditions for each of the elements you want to access and check.

I don't think you can dynamically parse it, but I hope someone else here can provide a workaround.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

hi @manuelstgomes ,thank you for answering,but how do i create an array of keys with true as the value ?

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

You can do it like this. Create a compose or array variable and use the following formula:

createArray('key1','key2',....)

Then you can access it by using the value inside the "For Each" like this:

body['GetItem']?[item()]

This is saying that you want the value inside the body of the get item with the current key in the application.

Can you please check if and let me know if you have any questions?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

hi @manuelstgomes ,i do not need the actual values.I just need the keys whose boolean value within the array is true as shown above.

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
HI @Anonymous

The values are the "true" and "false" results that you're looking for. If you have:

body['GetItem']?['Profit']

you'll get true for example.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No