Is it possible in powerapps wherein Combobox will have a default value based on the lookup value and if not found in sharepoint list it will show the items?
If(LookUp(ItemList,UserName= Label2_8.Text && WeekEnding = Label2_7.Text && Item = "Admin",true),Role,false)
Solved! Go to Solution.
Hi @nagestiada ,
That formula will not work because the If function expects a boolean result to evaluate the expression. When you are using the Lookup function, it will never return a boolean value, but a Record instead.
Regards,
Ricardo
Hi @nagestiada ,
That formula will not work because the If function expects a boolean result to evaluate the expression. When you are using the Lookup function, it will never return a boolean value, but a Record instead.
Regards,
Ricardo
Yup, I solved it already after realizing what you said. Thanks!
User | Count |
---|---|
159 | |
86 | |
68 | |
63 | |
62 |
User | Count |
---|---|
209 | |
150 | |
93 | |
81 | |
68 |