cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VegetA3113
Frequent Visitor

Formula to Retrieve Toggle data from Sharepoint list

I have managed to write a patch formula that creates a record i sharepoint on each toggle button values (Yes/No).

 

However i'm struggling finding the formula to apply these toggle values on the apps opening.

Should i create a "Load" button or set the default values of the toggle switches individually?

 

This is my patch code below and i have attached a screen shot of my sharepoint list.

 

I also have an additional problem, i cannot seem to successfully patch radio button data to the list, any ideas?

 

Much appreciated.

 

Patch(WeatherAlert,LookUp(WeatherAlert,Title="RiskAlert"),{R_NOTM:NOTM1.Value, R_DOE:DOE1.Value, R_DOME:DOME1.Value,
R_Call13:Call13_1.Value,
R_Call15:Call15_1.Value,
R_Call16:Call16_1.Value,
R_Call22:Call22_1.Value,
R_CW:CWI.Value,
R_TransI:Trans_Int1.Value,
R_TransC:Trans_Com1.Value,
R_REI:RE_Int1.Value,
R_REC:RE_Com1.Value,
R_MPDI:MPD_Int1.Value,
R_MPDC:MPD_Com1.Value,
R_FleetI:Fleet_Int1.Value,
R_FleetC:Fleet_Com1.Value,
R_SignalsI:Signals_Int1.Value,
R_SignalsC:Signals_Com1.Value,
R_TrackI:Track_Int1.Value,
R_TrackC:Track_Com1.Value,
R_StationsI:Stations_Int1.Value,
R_StationsC:Stations_Com1.Value,
R_TracksI:TrackSer_Int1.Value,
R_TracksC:TrackSer_Com1.Value,
R_PEI:PE_Int1.Value,
R_PEC:PE_Com1.Value,
R_ERUI:ERU_Int1.Value,
R_ERUC:ERU_Com1.Value,
R_LineI:Line_Int1.Value,
R_LineC:Line_Com1.Value,
R_CusI:Cus_Int1.Value,
R_CusC:Cus_Com1.Value})

Capture.PNG

0 REPLIES 0

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,731)