Hi All
I have a SP List with a column for each month (Month1, Month2 etc.) and in the end of each month i need to update the current month column (end of Jan - update column 'Month1' and so on). But when I do Sharepoint Update Item, I get list of columns to be updated. So is there any way to select column to be updated dynamically by creating column name as a string value?
Thanks
Solved! Go to Solution.
Another option is you need to add an IF expression under each column to check which month it is and under the true condition do your updates. Yes you need 12 If expression conditions against each field.
Your next option is HTTP update (REST API). Here you need to dynamically construct the month1,2,3...etc. depending on the current month. Then under the body specify the column name and do the update.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog
Could you please explain bit more about what you particular column you want to update with what name?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogI want the column, that needs to be updated, to be selected dynamically
Are you looking to update month1, month2 depending on the current month?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogI am looking to update column 'Month1' if its January at the moment, column 'Month2' if its February at the moment and so on.
Flow would be triggered at the end of the month and, depending of which month it is, flow would update 1 particular column.
Thanks for your reply.
You could use utcnow('MM') to find which month is and use a Switch action step to update the relevant column.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogWould not really want to write 12 Update Item actions, far not the nice solution.
What if I had 50 columns or more?
Another option is you need to add an IF expression under each column to check which month it is and under the true condition do your updates. Yes you need 12 If expression conditions against each field.
Your next option is HTTP update (REST API). Here you need to dynamically construct the month1,2,3...etc. depending on the current month. Then under the body specify the column name and do the update.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogREST API is the way to go 😃
User | Count |
---|---|
85 | |
38 | |
23 | |
20 | |
16 |
User | Count |
---|---|
127 | |
48 | |
46 | |
27 | |
25 |