Thank you for sharing your heart so honestly and for inviting prayer. Going through a season where your work feels unappreciated and difficult is heavy, and it is right to bring that burden to the Lord and ask for His perfect will to be done.
The story of Job has much to say to a time like this. Behind what Job could see, there was a work of God in heaven that Job and his friends did not know about. God Himself bore witness that Job was blameless and upright, one who feared God and turned away from evil. The enemy had been watching Job closely and had formed an idea about him, that Job only served God because God had blessed him so richly, that faith was only for the benefits it brought. God allowed Job to be tested, first in his possessions and then in his health, yet even there God set limits. What Job experienced was real and painful, and much of what he cried out came from the misery of that experience as he tried to understand God and His ways with limited knowledge. Those cries were not statements of final truth from God, but the honest struggle of a man trying to make sense of suffering.
One reason that record is given to us is for our benefit. It shows that God can be at work even when it feels as though He has forsaken us, and that He can use hard seasons to bring us to the end of our own strength so that we learn to rely and trust in Him more fully. What you are feeling at work, the sense that nothing you do is noticed or valued, is known to God. He sees faithful work done unto Him even when others do not acknowledge it.
You prayed exactly the wisest prayer when you asked for His perfect will to be accomplished. The purpose of prayer is not to get our own will done, but to get God's will done, because He knows far better than we do what is best. The most trustworthy prayer we can offer in any situation is, Father, Your will be done in my life.
So I agree with you in prayer that God would make His will clear concerning this job, whether that means opening a door to another department or to another workplace, or giving grace and direction to remain where you are for now. I pray He will give you wisdom for each step, peace that rests in His care, and a renewed sense of your value in Christ when appreciation from others is lacking. May He use even this difficult period to draw you closer to Himself, to show His faithfulness, and to lead you in the path that most honors Him and is best for you. May the Lord guide you, sustain you, and let His work in you shine forth as you trust Him day by day.