Unanswered

Conditional Sharepoint Update

(0) Share

Report

Posted on by hstep

Hi all,

i think this is an easy one , and im sure ive done it before but cant work it out today ( it is friday ) , i have a sharepoint list with some rates on e.g. electrician > £2.00

on a monthly basis i need it to update another list with the new rates , so the other list has jobs on e.g. install socket > Electrician > £2.00

(i cant use a sharepoint look up column before you say that) so i started a flow :

on schedule ( 1 monthly

Get items ( ratecard )

Get items ( job list)

Apply to all

Update sharepoint

Rate: ( heres where im stuck i cant seem to work out the formula ) IF( getitems(ratecard).trade = getitems(job list).trade, getitems(ratecard).Rate) or soemthing ?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@hstep

Was this reply helpful? Yes No
hstep on at

Like
a
(0)

Report
Copy link

Link copied!

Didnt work , the filter query is causing an issue , field_13 eq Field_1 - its not pulling through the value of field 13 ( copied from sharepoint ) , it is a choice field does that matter?

Was this reply helpful? Yes No
hstep on at

Like
a
(0)

Report
Copy link

Link copied!

im getting this on the fitler :
{
"status": 400,
"message": "Column 'Glazier' does not exist. It may have been deleted by another user.\r\nclientRequestId: b1a41329-2fbd-4940-915e-ff2b01010328\r\nserviceRequestId: b1a41329-2fbd-4940-915e-ff2b01010328"
}
parameters:
{ "dataset": "https://cbre.sharepoint.com/teams/BTCMMS_GWS_EMEA", "table": "ce197bd3-e1fc-46c8-a15f-c933023f9783", "$filter": "field_13 eq Glazier" }

i set the filter query to - field_13 eq Trade ( from dynamic content )

there is no choice field now just single text

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Is field_13 the Internal name of the 'Glazier' column?

Was this reply helpful? Yes No
hstep on at

Like
a
(0)

Report
Copy link

Link copied!

No - Field 13 is where glazier should be found , Glazier is Field_1 from the other list where the new rate is
Field_13 = old rate where update needed

Was this reply helpful? Yes No