Forum Discussion
Buckets84
Mar 11, 2024Copper Contributor
Help Needed - Grabbing text in between delimeters
Hi all, I have a power app that is pushing data to a SharePoint list. The data is being scanned in using a barcode scanner. I am trying to write a calculation for a column to automatically grab th...
sarahmkurth
Mar 11, 2024Copper Contributor
Buckets84 I've had to do something like this before, pulling multiple different strings between delimiters in the filename and putting those strings into specific fields in a SharePoint List. My own solution was to run a Power Automate flow on new list entries, using the function "split" to extract specific strings, and then create an output that mapped to specific file properties (in the SharePoint List). I believe you can create a Flow right in PowerApps now. Check out the https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-split and see if this might work for your scenario. (https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-split)