Announcements
Hi there,
I have a simple app built on an Excel worksheet as the data repository. I have a radio control that has an error message stating that "The property on this control expects text values. The rule produces Table values which are incompatible". It suggests I "change the rule to produce a {0} value" I don't see the "rule" button on my display and I wouldn't know how to change it if I did!
Could someone help me understand how I can change the radio control so the user choice is written back to the Excel sheet?
Many thanks,
Alan
@AlanR Can you please share a screenshot of your app and any code you used?
I heard you mention a 'rule'. Are you using the Rules feature of Power Apps? If yes, that feature has been deprecated and I would suggest not using it.
can you show more about when/how you are getting this error?
Are you using "Radio.Selected.Value" to get the selected value to write to excel?
@DylanSimons
I think you just asked the OP for the same information as I did. The original poster will respond once they are available so please be patient. There is no need to ask them twice.
Hi, thank you both very much for offering to help. I have attached a screen shot of the error I am getting and the Powerapps suggested solution, I hope this helps your ability to help me 🙂
@AlanR Try this code in the Update property. Replace Radio1. With the name of the radio buttons control you want to reference. This will produce a text value and that's what you need here.
Radio1.Selected.Value
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Hi @mdevaney many thanks for the help - that code worked - or at least it has cleared the error. I can't confirm it has worked completely as I have another problem preventing from doing so. I have never seen this before, when I preview the app it doesn't display any items/fields/labels. I have attached a screen shot of the edit screen in Powerapps and below it what I get when I preview the app. I thought it might be something to do with the data connection but I think those are okay, other apps I have put together used the same network/structure and I did not have this issue - can you help?
@AlanR Yes, of course I can help. Please set the DefaultMode property of the Edit Form to this code.
FormMode.New
The form will show No item to display when the form mode is 'Edit' and a blank record is supplied to it.
@mdevaney Many thanks again - it worked of course. I will be trying to finish off the app this week, will reach out again if / when I need your help again, hope that is okay!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional
