Forum Discussion
Using Calculated/Look ups with conditions
Excuse my lack of knowledge but my past life I was developer but on relational dbs. So I get lists are very Excel oriented, but I'm trying to put some relations between my lists as like Db Tables...
Thanks
I think I understand you but, for me with my background you are effectively updating the item twice ... once to create it, being selective with the look up, and then secondly to overwrite without?
I think I understand you but, for me with my background you are effectively updating the item twice ... once to create it, being selective with the look up, and then secondly to overwrite without?
Yeah, you could look at it that way. You are creating the entry, and using a flow to immediately 'update/modify' a targeted cell (or cells) on said entry. Explaining/setting up seem not so pretty, but in action it pretty straight forward/hands off.
- (to clarify, on the 'update' you aren't overwriting anything/any cells you don't want to update/overwrite... You would leave those cell refs in the flow blank and flow would ignore them and the original info from initial creation would remain in tact ).
