Excel Values to update based on radio button

[yashgoyal]

Hi All,

Any suggestion how to achieve following in power Apps.. I tried.. however not able to convert Item - Working , control type to Radio button.. Form works well with control type "Edit Text". I want Radio buttons as inputs so ease for user to provide inputs against each employee working - Not Working (0), Working from home(1), Working from Office(2)
Edit Form
Datasource : OneDrive - Excel file
Form:

EMP1  (Selected Row)		oNot Working    oHome     oOffice     (based on value , 0, 1, 2)
EMP2
EMP3
EMP4

  Button - Update

Excel File sample::

EmpID	Working
emp1	0
emp2	1
emp3	0
emp4	2
emp5	2
emp6	1
emp7	1
emp8	0
emp9	0
emp10	1

[QuentinDURIEZ · Accepted solution]

Hi,

This is how you can do it : 

• First, collect all possible value for the column "Working"

ClearCollect(_colWorking; [{Text:"Not working"; Value: 0}; {Text:"Home"; Value: 1}; {Text:"Office"; Value: 2}])

• Second, add the radio group inside the datacard with these properties : 

RADIO.Items = _colWorking
RADIO.Default = LookUp(_colWorking ; Value =  Value(ThisItem.Working)).Text

• Finally, change the Update property of the parent datacard

DATACARD.Update = Radio1.Selected.Value

Regards,

[AndrewR1 · Accepted solution]

Hi @yashgoyalm here is how I manged to do this:

So firstly I have a table with my list of employees that is stored in excel online (OneDrive):

Then I have added a table to my power app with this as its item’s property

I have also added a form next to my table that displays the selected item.

In this form I have the Location and the name field being displayed.

In the location data card I have added a radio group with the following for its items property:

[{Text:"Not working", Value: 0}, {Text:"Home", Value: 1}, {Text:"Office", Value: 2}]

And then in the on-change property of the radio group I have the following:

Patch(Table1,ThisItem,{Location: RadioGroupCanvas1.Selected.Value});Refresh(Table1)

I have also set the default selected items property to the following:

Switch(Value(ThisItem.Location),0,{Text:"Not working", Value: 0},1,{Text:"Home", Value: 1},2, {Text:"Office", Value: 2})

Hope this helps!
Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[yashgoyal]

Hi Andrew, Thanks for detail solution......

I followed your steps .. However still Radio button is not display value as current saved value 

[AndrewR1]

Hi @yashgoyal can you show me what you have in the Default Selected Items property of the radio buttons?

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

[yashgoyal]

Thanks Andrew...

Default of Radio Item---> 

"Switch(Value(ThisItem.WorkingValue),0,{Text:""Not working"", Value: 0},1,{Text:""Home"", Value: 1},2, {Text:""Office"", Value: 2})"

[yashgoyal]

@AndrewR1  Greetings.. Any advice ? what wrong i am doing .. Radio button is not display value of current value 

[AndrewR1]

Hi @yashgoyalthis will be because you have put the Switch statement in "" you do not need to have these it should just be (Without the ""):

Switch(Value(ThisItem.WorkingValue),0,{Text:""Not working"", Value: 0},1,{Text:""Home"", Value: 1},2, {Text:""Office"", Value: 2})

My example has no "": 

Hope this helps

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew