Forum Discussion
A space appears in some of the records added via a for Powerapps
- Jul 28, 2022
Chris_Clark1968 Did you try using Trim functions while patching data in SharePoint from power apps?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap
Once the group (2 or more) are selected from the search screen they appear in the 'Groupform'
The Submit button becomes active once the required fields have been completed.
The submit button, 'On Select' is
With(
{
'Staff Name': Split(
StaffName.Text,
","
),
JobTitle: Split(
JobTitle.Text,
","
),
Email: Split(
Email.Text,
","
),
'Ward Name': Split(
WardName.Text,
","
),
Divison: Split(
Division.Text,
","
)
},
ForAll(
Sequence(CountRows('Staff Name')),
Patch(
'Clinical Supervision',
Defaults('Clinical Supervision'),
{
'Staff Name': Last(
FirstN(
'Staff Name',
Value
)
).Result,
'Job Title': Last(
FirstN(
JobTitle,
Value
)
).Result,
Email: Last(
FirstN(
Email,
Value
)
).Result,
'Ward Name': Last(
FirstN(
'Ward Name',
Value
)
).Result,
Supervisor: Supervisor.Text,
'Supervision Subtype': SupervisionSubtype.Selected,
'Other Reason': OtherReason.Text,
'Supervision Type': SupervisionType.Text,
'Supervisor Email': SupervisorEmail.Text,
'Reflections Actions': ReflectionsActions.Text,
'Date Supervision': SupervisionDate.SelectedDate
}
)
)
);
Notify(
"Clinical Supervision Group Form",
NotificationType.Success,
5000
);
Navigate('Home Screen')
It only seems to happen periodically??
Update 28/07
Looking at the SP site recently, the 'weird' characters seemed to have changed to just <br> which seems to suggest this is an HTML issue but not sure how as no HTML is used in the formula????
Chris_Clark1968 Did you try using Trim functions while patching data in SharePoint from power apps?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Chris_Clark1968Jul 28, 2022Brass Contributor
ganeshsanap ,
Would the trim() function be used against the whole patch formula or just the datacards where the character(s) are displaying?
Staff Name & Email