Hi All,
I have had several very simple actions fail or have totally unexpected behavior. For example, I have a flow that takes a Product Inventory record, pulls several field values from there, and uses them to create a transfer product when that product inventory gets low.
I have two flows that do the exact same thing, the only difference is that one flow runs on Sundays on half of our warehouses' product inventories, and the other runs on Tuesday on the other half.
I built the Sunday flow, tested it, and saw that it worked well. So, I duplicated it and just changed the day of the week that the flow runs. However, when the new flow runs, it pulls a Null field value from every single record it retrieves, even though the "List Rows" step that it is pulling this data from has a fetchXML that only includes records where this field has data. See screenshots for context (Null value returned, but value present in CRM). All other fields are retrieved correctly except a very crucial whole number field that comes through as null/blank.
I initially thought this may be caused by unwritten rules of solution objects but through my research I cannot find anything to support that theory. But this has made me feel like I am going crazy, because even when I rebuild the flow from scratch, it continues to pull a Null value even though I already have a flow that is pulling data from this same field with no problem. Has anyone experienced something like this or know how to fix it? Thanks so much for any insight on this!