exactin

How to Use the Power Fx exactin  Function in Power Apps

What is the Power Fx Exactin Function?

The Power Fx Exactin function is a text function that is used to extract a specific sequence of characters from a larger string of data. It is similar to the Excel function, “Exact”, but with added flexibility and power. The function takes two arguments: the text that you want to search within, and the exact sequence of characters that you want to extract.

Syntax of the Power Fx Exactin Function

The syntax of the Power Fx Exactin function is as follows:


Exactin( text, search_string )


Where:

– `text` is the string of text that you want to search within

– `search_string` is the exact sequence of characters that you want to extract

How to Use the Power Fx Exactin Function in Power Apps

Here are the steps to follow when using the Power Fx Exactin function in Power Apps:

1. Open Power Apps and create a new canvas app.

2. Create a new screen and add a text input control.

3. Add a button control to the screen and add the following formula to the “OnSelect” property of the button:


UpdateContext({ Result: Exactin(TextInput1.Text, "Power") })


This formula will extract the word “Power” from the text that you enter into the text input control.

4. Save and publish the app.

5. Test the app by entering some text into the text input control and clicking the button. The app should return only the word “Power” from the text.

Additional Tips for Using the Power Fx Exactin Function

Here are some additional tips for using the Power Fx Exactin function in Power Apps:

– You can use the function to extract any sequence of characters from a larger string of data, not just words. For example, you could extract a specific code from a longer string of alphanumeric characters.

– You can use the function in conjunction with other text functions to create more complex formulas. For example, you could use the Power Fx Left and Power Fx Right functions to extract text from the beginning or end of a string, and then use the Exactin function to extract a specific sequence from that result.

– When using the function, make sure that the sequence of characters you are searching for is unique within the larger string of data. If there are multiple occurrences of the sequence, the function will only return the first one.

– You can use the Power Fx Exactin function to extract data from external sources as well, such as Excel spreadsheets or SharePoint lists. Simply reference the data source in your formula and use the function to extract the desired data.

The Power Fx Exactin function is a powerful tool that can help you create more efficient and effective apps in Power Apps. By following the steps outlined in this article, you can start using the function to extract specific sequences of characters from larger strings of data. With a little practice, you can become a Power Fx Exactin expert and take your Power Apps to the next level.

Power Apps Training Courses by G Com Solutions (0800 998 9248)