I need to split info from a text into numbers and text, and find the max value of numbers. For example in TextInput1 I have “5-6 working days”, and I need to extract the number 6 who is the max number of the string. I get the following error :

I need to split info from a text into numbers and text, and find the max value of numbers. For example in TextInput1 I have “5-6 working days”, and I need to extract the number 6 who is the max number of the string. I get the following error :

New to powerapps, I am trying to load user settings from a sharepoint list on app load. If there is no record, then it should create the row in the list.

I have a canvas app that I’m using to add shift inspection records to a SharePoint list. It adds the data to the list correctly; however, if the user selects an item as "Not OK", I want a warning screen to be displayed after the form data has been submitted to the SP list.

I have a power apps canvas that I’m trying to filter the view of a sharepoint list and only show the items where the “Assigned_To” (data type: Person/Group [No Multi-Select]) is blank. I’ve tried the following which appear to work but still return rows where the assigned_to field has been filled in.

I am trying to create code that will update and be re used to update the record in power apps. But now the problem I have it updates the last record created on the list instead of creating a new record. Below is my code: