Sets a variable with spilt text from a link - YouTube in this case

PHOTO

Sun Jul 24 2022 10:00:15 GMT+0000 (Coordinated Universal Time)

Saved by @gofunk1 #powerapps #split #text #trim

Set(varSplitText, (Concat(LastN(Split(TextBoxNew.Text, "=").Result, CountRows(Split("https://www.youtube.com/watch?v=", "=").Result) -1),Result
)));

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Power Apps

@gofunk1

Initiate MS Team Group Chat via PowerApps Save the current users email as a variable Creates variable with a theme colour palette Send an email from the current user Filters a data source based on the current logged in user Patch data fields, including a choice column to a data source Changes the colour of a selected item in a Gallery Filter and search a data source via a search box and dropdown Changes visibility based on the selection of another Gallery - used for "Tabs" Display current users first name Fix: Combobox/Search is empty check not working - Power Platform Community Retrive a user photo from SharePoint Get user photo from office365 connector from gallery Set a variable with the current users first name, from the currentUser variable Extract values from a collection Extract value from combo box Extract vale from combo box and convert to string/text Convert collection to JSON Combo box values to collection Show newly created items first / sort by most recent entry, will only show items created today Validate/Validation text box length and/or combo boxes contain data Text input validation - turns border red Lookup value against a text input and disable or enable displaymode Lookup items from a textbox Sets items to choices drop down or combo box Change text value based on lookup results returns tops 10 results and sorts by most recent created date Sets a variable with spilt text from a link - YouTube in this case Pass a null or empty value from Power Apps to a flow

#css #webdev #text

How to "truncate" long strings with an ellipsis (...) for text that overflows its container

.truncate {
  width: 250px;
  white-space: nowrap;
  overflow: hidden;
  text-overflow: ellipsis;
}

#servicenow #content #type #plain #text

Accepting Scripted REST Connections for Weird Content-Types

/* This will come in the body at XML but the header will be text/plain, which is why  
all this is happening manually to get this read from the stream.  
*/  
var reqHeaders = request.headers;
gs.info("CPSNS: reqHeaders content-type" + reqHeaders['content-type']);
if (reqHeaders['content-type'] == "text/plain; charset=UTF-8") {
    var stream = request.body.dataStream;
    var reader = new GlideTextReader(stream);
    var input = "";
    var ln = "";
    while ((ln = reader.readLine()) != null) {
        input += ln;
    }
    gs.info("CPSNS: SUB" + input);
} else {
    var body = {};
    var data = request.body.data;

    gs.info("CPSNS: req.body data" + data);

}

Retrive a user photo from SharePoint

"https://[tenantName].sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=" & ThisItem.Employee.Email

Fix: Combobox/Search is empty check not working - Power Platform Community

If(
    (IsEmpty(ComboBox42.SelectedItems) || IsBlank(ComboBox42.Selected.Value)) && IsBlank(ComboBox42.SearchText),
    SubmitForm(EditForm1),
    Notify(
        "Please fill in the Combo Box!",
        Error
    )
)

Get user photo from office365 connector from gallery

Office365Users.UserPhotoV2(ThisItem.PeopleColumn.Email)

#sharepoint #filter #powerapps

Set a variable with the current users first name, from the currentUser variable

Set(currentUser, User()); //require for the on start property

Set(varFirstName, Trim(Last(FirstN(Split(currentUser.FullName," "), 1)).Result))

Extract values from a collection

Concat(selectedDesks, " " & Title & Char(44))

Prevent decimal input

If(Value(DataCardValue14_1.Text)/Value(RoundDown(Value(DataCardValue14_1.Text),0))<>1, Notify("No decimal,please try again!",NotificationType.Error);Reset(DataCardValue14_1))

Add image to variable Power Automate

<img src="data:image/jpeg;base64,@{outputs('Get_file_content_using_path')?['body'].$content}" alt="My Image" />
  
  <"data:image/jpeg;base64," alt="My Image" />
    
   outputs('Get_file_content_using_path')?['body'].$content

Extract value from combo box

Concat(AddToWatchList.SelectedItems.Value,Value)

Combo box values to collection

ForAll(Tags.SelectedItems, Collect(colTags, {Value: ThisRecord.Value}))

#powerapps #json

Convert collection to JSON

JSON(colTags.Value,",")

#powerapps #html

Launch URL by clicking on an image

Launch("https://www.bing.com")

#powerapps #filter #sortby

Show newly created items first / sort by most recent entry, will only show items created today

Sort(Filter('YouTube Resources', Text(Created,"mm/dd/yyyy") = Text(Today(),"mm/dd/yyyy")), Created,Descending)

#powerapps #validation #combobox

Validate/Validation text box length and/or combo boxes contain data

DisplayMode= If(
    IsBlank(varName) Or IsBlank(varName) Or Len(TextInputBox.Text) < 11,
    DisplayMode.Disabled,
    DisplayMode.Edit
)


OnChange= Set(varName, Combobox.Selected) //Sets the variable to the combo box values or record

Browse more snippets >>