Unanswered

Update sharepoint list value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone

Trying to build an automate thats update a vaule every week based on some parameters, but I cant get it to work so I´m asking for help.

I have done similar things for some years ago but I´m keep geting stuck on this time.

So the basic we have a Sharepoint List with a lot of columns that we would like to check every week and if some values are the right ones the list object should be updated.

So the automate in text is:

Every monday check all list objects in this list

If the vaule on this three columns are the right ones:

Agent (Person or group type): is not empty

Attached file: is true

Status (Multiple choice type): Resovled

If yes:

Change the value in status to: Archive

Can some one tell me how to build this in power autome?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,853 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

I would use a Get Items with a filter query and check for those field values.

Unfortunately the Has attachments field its internal name has {} characters around that. The filter query doesn't like that. So, I have added an additional Filter Array action to filter out the items which have an attachment.

After that you can loop through the items which meet these condition and update them with an update item action.

Below is an example of that approach.

1. The Get items uses the following filter query:

(Agent ne '@{null}') and (Status eq 'Resolved')

2. The Filter array uses the values from the Get Items and checks if {HasAttachments} field is equal to true.

3. The apply to each uses the body of the Filter Array action.

4. In the Update Item action I have used the following expression for the ID & Title field (which are mandatory).

items('Apply_to_each')?['ID']
items('Apply_to_each')?['Title']

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Expiscornovus

You can add the filter query for attachments. The internal name is called Attachments. So add this as a custom value under the filter query.

Thanks

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

Like (1)

Report
Copy link

Link copied!

Hi @abm,

Great stuff! I tried looking for that internal name, I couldn't find it. Thanks for sharing that, very useful 😁

Makes the Filter Array obsolete for this setup.

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

Like (0)

Report
Copy link

Link copied!

Hi

So I tried your solution a bit but keep getting stucked on the get-items
When I wrote the first things here i translated it to english but in the picture we have Swedish hope that work

So the flow look like this but as I said it get stuck on Get- Object with error message
Translated:
{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"sv-SE","value":"The expression (Handläggare ne @{null} and (Status eq '3 - Avslutat') is not valid."}}}

What do i do wrong

Was this reply helpful? Yes No