Hi,
I want to filter Choice column in Dataverse in Power automate. Is there any possibilties??
Solved! Go to Solution.
Hello @ELango
Consider if you have choice field like below
Field Name --> Choice Field(new_choicefield)
Value --> Choice Value 1 -- 100000
Choice Value 2 -- 100001
Filtering for List Rows you can use filter query as
new_choicefile eq 100000
If you want to use in Condition you can use
Choice Field Value equals 10000
Please find the below steps to how to take choice field value
1. Navigate to https://make.powerapps.com
2. Select Respective environment
3. Expand DataVerse --> Click Tables --> Select the table where choice field Avaialble
4. Click Fields --> Open Field
5. Open the Field Values and click on Three Dots and see Value over there.
That's it 🙂
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Hello @ELango
Consider if you have choice field like below
Field Name --> Choice Field(new_choicefield)
Value --> Choice Value 1 -- 100000
Choice Value 2 -- 100001
Filtering for List Rows you can use filter query as
new_choicefile eq 100000
If you want to use in Condition you can use
Choice Field Value equals 10000
Please find the below steps to how to take choice field value
1. Navigate to https://make.powerapps.com
2. Select Respective environment
3. Expand DataVerse --> Click Tables --> Select the table where choice field Avaialble
4. Click Fields --> Open Field
5. Open the Field Values and click on Three Dots and see Value over there.
That's it 🙂
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
User | Count |
---|---|
29 | |
5 | |
5 | |
4 | |
2 |
User | Count |
---|---|
33 | |
13 | |
10 | |
10 | |
9 |