web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Alter answer before su...

Power Automate

Answered

Alter answer before submission to excel

(0) Share

Report

Report

Posted on by JB-13110838-0

2

I have created a Microsoft Forms, Form which once submitted, populates a spreadsheet.

one of the questions on the Form is Worksite Number which then populates a column of the same name.

the problem i have is that people format this like; A111/11111 but i only want the numbers after the "/" to apear on the spreadsheet.

is there a work around for this?

any help would be appreciated.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Chriddle 8,713 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Split the value at '/' and take the last item:

last(split('A111/11111', '/'))

Was this reply helpful? Yes No

Join the conversation