I know similar questions have been posted before. However, their setups were different, or the solutions didn't work for me. Plus I'm still learning.
I have 2 SharePoint (SP) Lists:
What I am trying to do:
The formula I entered for the Measures Gallery - Items property, does not work. Would appreciate any help with this.
Thanks for your prompt response. It doesn't seem to like the ".Years".
I've tried the following as well:
None of these work unfortunately.
It is the name of your column from 'fiscal years' list, so it should be years (without first capital letter).
I will correct my post if it works, otherwise we'll keep looking for the answer.
However, looking at the annotated error in the picture above made me realize that, and I apologize I didn't mention these details earlier:
Do these details help?
Let me make it easy for you:
1). 'FY Affected' column is a Choice type from the 'calendar' SP list
2). 'fy' column is a Number type from the 'fiscal_years' SP list
3). You want to filter calendar list based on the 'FY Affected' column that has similar year like the 'fy' column in 'fiscal_years' SP list
If the above is correct, please modify your formula as below:
I didn't get a chance to test your formula as I created a work around for my issue. But I learned something new with your solution (converting to Text)!
Thanks to you, and @gabibalaban for your responses.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.