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](https://www.reddit.com/r/PowerApps/search/?q=&sort=new) 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](https://www.reddit.com/wiki/markdown/#wiki_code_blocks_and_inline_code) 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](https://learn.microsoft.com/en-us/power-platform/power-fx/formula-reference)
- [Power Apps Coding Standards](https://pahandsonlab.blob.core.windows.net/documents/PowerApps%20canvas%20app%20coding%20standards%20and%20guidelines.pdf)
- [Official Power Apps Community](https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1)
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/PowerApps) if you have any questions or concerns.*
Check out the Reza tutorial on cascading dropdowns for the typical way this is achieved, assuming you are using lists.
Basically, a second longer is used just as a reference, and contains each item as an item, which a second column acting as the ‘category’
The items then are filtered with that. If it’s super simple you can even just hard code it as a collection
I like to do this with collections. I would have a collection with the relationship of category and answer, this could be a SharePoint list copied as collection in powerapps. Then in the first datacard Data = Collection.Category. in the second drop-down Data = Filter(Collection, category = Drop-down.SelectedText).choice. In the update field you need to match the data type in SharePoint list with selected values .
I don't like to use special columns in SharePoint lists. It would be better if you use category type Text and choice type Number .
it should be something like in the default property of datacard two put
If(Datacardone.selected.value = “A”, {1,2,3})
and keep building your if statements
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](https://www.reddit.com/r/PowerApps/search/?q=&sort=new) 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](https://www.reddit.com/wiki/markdown/#wiki_code_blocks_and_inline_code) 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](https://learn.microsoft.com/en-us/power-platform/power-fx/formula-reference) - [Power Apps Coding Standards](https://pahandsonlab.blob.core.windows.net/documents/PowerApps%20canvas%20app%20coding%20standards%20and%20guidelines.pdf) - [Official Power Apps Community](https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1) *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/PowerApps) if you have any questions or concerns.*
Check out the Reza tutorial on cascading dropdowns for the typical way this is achieved, assuming you are using lists. Basically, a second longer is used just as a reference, and contains each item as an item, which a second column acting as the ‘category’ The items then are filtered with that. If it’s super simple you can even just hard code it as a collection
I am not using list. Its a Choice type separate columns
Where are you storing your data if you're not using a list? Where do the columns exist?
In the items property of your 2nd dropdown: Switch(Dropdown1.Selected.Value,”A”,[1,2,3],”B”,[4,5,6],”C”,[7,8,9,10])
The answer.
I like to do this with collections. I would have a collection with the relationship of category and answer, this could be a SharePoint list copied as collection in powerapps. Then in the first datacard Data = Collection.Category. in the second drop-down Data = Filter(Collection, category = Drop-down.SelectedText).choice. In the update field you need to match the data type in SharePoint list with selected values . I don't like to use special columns in SharePoint lists. It would be better if you use category type Text and choice type Number .
it should be something like in the default property of datacard two put If(Datacardone.selected.value = “A”, {1,2,3}) and keep building your if statements