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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.