Send email update with changes to Sharepoint list in the last 24 hours.

(0) Share

Report

Posted on by isavedalex

Hello everyone,

I have a sharepoint list with 3 columns for now.

1) Sales District (single line of text)

2) Sales Rep 1 (Person or group object)

3) Temporary Cover (Person or group object)

Mapping Columns.png

I'm trying to use Power Automate to send an email notifying of any changes to this list over the last 24 hour period. I've managed to set this up in Flow so that it correctly pulls items from the sharepoint list modified in the last 24 hours, however it pulls everything from the Person/Group object, I'm trying to edit this down to just the display name.

Current flow:

Mapping Flow.png

Current Output

Any help or advice would be greatly apprecaited!

One last note: the Sales Rep 1 column may have multiple persons assigned in some cases, so ideally I would be able to pull each of the display names at the same time.

Many Thanks,

Alex

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Hello @isavedalex ,

as the multiple people picker column gives you an array of objects with all the information about the users, you'll need a complex expression to get just a specific value for each user from there:

e.g. to get comma delimited display names from 'Person_MultiplePicker' column: join(xpath(xml(json(concat('{"body":{"value":', item()?['Person_MultiplePicker'], '}}'))), '/body/value/DisplayName/text()'), ', ')

I posted an article on the formatting of SharePoint items in an HTML table just a few days ago.

Was this reply helpful? Yes No
v-duann-msft on at

Like (0)

Report

Hi @isavedalex

Thank you for your post.

I agree with @tom_riha to get multiple value, we need to use expression.

In addition to your error while pull out people display name from output. We'd better use 'people/displayname' instead of 'people' only.

Hope it helps

Best regards,
Anna

Was this reply helpful? Yes No
isavedalex 10 on at

Like (0)

Report
Hey @tom_riha ,

Thank you so much for your response! this looks like exactly the right solution for me, but I'm having a little bit of trouble implementing it.

To simply things, I renamed the sharepoint column Sales Rep 1 to 'ISSR' and tried the expression you provided but I replaced ['Person_MultiplePicker'] with ['ISSR']

join(xpath(xml(json(concat('{"body":{"value":', item()?['ISSR'], '}}'))), '/body/value/DisplayName/text()'), ', ')

When testing the flow like this, I get the following error.
The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "District": "@item()?['Title']", "ISSR": "@join(xpath(xml(json(concat('{\"body\":{\"value\":', item()?['ISSR'], '}}'))), '/body/value/DisplayName/text()'), ', ')\r\n", "Temporary Cover": "" }' failed: 'The template language function 'json' parameter is not valid. The provided value '{"body":{"value":}}' cannot be parsed: 'Unexpected character encountered while parsing value: }. Path 'body.value', line 1, position 17.'. Please see https://aka.ms/logicexpressions#json for usage details.'.

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @isavedalex ,

you must use the column internal name in the expression, expression don't care about the display name. You can take the internal column name from the url if you go to the 'Edit column' page.

Was this reply helpful? Yes No
isavedalex 10 on at

Like (0)

Report

Thank you so much for your help @tom_riha , you've saved me countless hours here!

Can I donate a Coffee/Beer or something else to you to say thank you?

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @isavedalex ,

you can buy me a coffee on my blog if you'd like, but a 'thank you' is more than enough. 🙂

Was this reply helpful? Yes No
snehabirajdar17 2 on at

Like (0)

Report

Will you please put query for this

Was this reply helpful? Yes No