# Need help completing workflow **URL:** \ **Category:** Revit\ **Tags:** dynamo\ **Created:** [November 1, 2024, 12:36am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542 "2024-11-01T00:36:43Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![MLynch](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MLynch](https://forum.dynamobim.com/u/MLynch)\ **Post date:** [November 1, 2024, 12:36am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/1 "2024-11-01T00:36:43Z")
I need help completing a workflow. I want to override the color of elements in a Revit model based on the value of a column in a CSV file. Specifically what I am trying to do is I have a CSV file with a column that lists the construction stage of every element, i.e. in progress, not started or complete. I want the script to read this status for each element, and then override the color of the element, i.e. green for complete etc. I can get two list, one for element Id, and then a code block with all of the status’s listed, but its the next step in filtering the element before the colour override that has me stumped. Any help would be very much appreciated. Edit: screenshot below. There also appears to be a problem with my List.GetItemAtIndex node, though I do not know what!? Edit 2: I can now upload!! Edit 3: I’ve uploaded the CSV file as an Excel file, if anyone wants a look! ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/6/46dbe31bfc9ef1ca8ff54810251d941dc680595c.png) [Ass2\_D23126871\_Construction\_Progress\_Part\_2.dyn](https://forum.dynamobim.com/uploads/short-url/wddDEqp2GlyhaubbSIiflmPhLH3.dyn) (24.1 KB) [Input\_Model\_Construction\_Progress.rvt](https://forum.dynamobim.com/uploads/short-url/1H2mk8NUtEp2PTfedPjzioxTVTf.rvt) (7.4 MB) [Ass2\_D23126871\_Construction\_Progress\_Stage\_1.xlsx](https://forum.dynamobim.com/uploads/short-url/z4MzxAaLHOqgxPoq4pXPcvWYUN3.xlsx) (10.2 KB) ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [November 1, 2024, 6:39am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/2 "2024-11-01T06:39:14Z")
Hi @MLynch best if you share the csv as well, if people should try help… ---
**Author:** ![MLynch](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MLynch](https://forum.dynamobim.com/u/MLynch)\ **Post date:** [November 1, 2024, 8:52am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/3 "2024-11-01T08:52:25Z")
I tried to share the csv but it would not let me. Perhaps I can set up a link? Edit: I’ve uploaded it as an excel file instead, as that part of the workflow is not a problem. ---
**Author:** ![timhevel](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/timhevel/32/109364_2.png) [@timhevel](https://forum.dynamobim.com/u/timhevel)\ **Post date:** [November 1, 2024, 8:55am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/4 "2024-11-01T08:55:50Z")
> [@MLynch](#): > > or each element, and then override the color of the element, i.e. green for complete etc. > > I can get two list, one for element Id, and then a code block with all of the status’s listed, but its the next step in filtering the element before the colour override that has me stumped. use a dictionary to link colors with the status text in the csv ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/7/17ee763c4634fa53d4e258647f675983323a81c5.png) ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [November 1, 2024, 8:56am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/5 "2024-11-01T08:56:13Z")
yeah you could share with webtransfer, file transfer or try give you file .txt extension ---
**Author:** ![MLynch](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MLynch](https://forum.dynamobim.com/u/MLynch)\ **Post date:** [November 1, 2024, 9:02am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/6 "2024-11-01T09:02:00Z")
Thanks sovitek. I’ve uploaded the file as a excel file instead, as I can manage that part. Its getting the lists to filter according to the construction status, and then applying the colours that I am struggling with. ---
**Author:** ![MLynch](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MLynch](https://forum.dynamobim.com/u/MLynch)\ **Post date:** [November 1, 2024, 9:03am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/7 "2024-11-01T09:03:09Z")
timhevel, thank you very much! Could you share that dynamo file please? How do I get the colours to apply to the instances of the elements? Do I need some sort of filter? Edit: timhevel, just to clarify, how do I do the linking of the colours to the status in the CSV file part? ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [November 1, 2024, 9:44am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/8 "2024-11-01T09:44:47Z")
Hi @MLynch yeah a dictionary is the way…but you have some element there give null becaurse it doesnt have any value in your excel/csv…so try filter them out first… ![Skærmbillede 2024-11-01 104128](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/3/83d2bad1c8fd0dd82dbfdec6b5fa5f069d35c44e.jpeg) [Ass2\_D23126871\_Construction\_Progress\_Part\_2.dyn](https://forum.dynamobim.com/uploads/short-url/i3WJuaJS6gtsJfPo04Ea2ALyHP6.dyn) (33.8 KB) ---
**Author:** ![MLynch](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MLynch](https://forum.dynamobim.com/u/MLynch)\ **Post date:** [November 1, 2024, 10:16am UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/9 "2024-11-01T10:16:06Z")
Sovitek and Timhevel, that you both so much! Sovitek I’ve marked yours as the solution, although you both gave the answer I needed! Thank you both again! ---
**Author:** ![Mike.Buttery](https://avatars.discourse-cdn.com/v4/letter/m/b19c9b/32.png) [@Mike.Buttery](https://forum.dynamobim.com/u/Mike.Buttery)\ **Post date:** [November 2, 2024, 11:34pm UTC](https://forum.dynamobim.com/t/need-help-completing-workflow/105542/10 "2024-11-02T23:34:38Z")
Friendly reminder here… use [UniqueId](https://apidocs.co/apps/revit/2024/f9a9cb77-6913-6d41-ecf5-4398a24e8ff8.htm) [![Screen Shot 2024-11-03 at 7.30.09 am](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/1/91afde308e16b5d3886b9ece05c35460072732ee.png)](https://apidocs.co/apps/revit/2024/44f3f7b1-3229-3404-93c9-dc5e70337dd6.htm)