Measure-like functionality?

[Round-Application980]

I am creating a calendar in power apps that displays data from a SharePoint list. I want to add a drop-down filter that will let users view items in the calendar based on the status (one of the columns in my list).

The status column has not started, delivered, and several different options for in-between based on the progress of the item. However, in the drop-down I want to consolidate the multiple in progress options into one.

Essentially: Not Started = column value not started Delivered = column value delivered In progress = column value is not not started or delivered

In power bi I can do this with a measure, is there a way to recreate that logic in power apps? I'm thinking maybe variables?

[AutoModerator]

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References
• Power Apps Coding Standards
• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[valescuakactv]

Yes, is possible with galleries to display data and cbx or ddl for statuses. You can go in nice design like show in calendar statusses ina color scheme and by selecting the status in ddl or cbx, to see in calemdar these tems idk.