A&A Inomatic LLC

A&A Inomatic LLC We build custom SharePoint & Excel advance solutions to innovate and automate business process.

03/02/2025

🚀 Exciting news! We’re launching our new podcast series, "Government Efficiency at the Agency Level," brought to you by A&A Inomatic. Join me, Nathan Nguyen, as we explore innovative strategies and actionable insights to enhance efficiency within public sector agencies.

In each episode, we’ll dive into essential topics like digital transformation, process automation, and data-driven decision-making. Whether you’re a public sector leader, innovator, or stakeholder, this series is designed to equip you with the tools needed to drive meaningful change.

🎧 Subscribe now and join us on this journey to improve government operations for better public service delivery!

06/24/2022

PowerApps for Beginners - Searching/Filtering of Gallery with Textbox

In this video, you will learn how to implement a Textbox search control to quickly filter the dataset. Along the way, you will find little helpful tips that you can utilize immediately.

YT: https://youtu.be/pnxP4K8y8d8

06/24/2022

PowerApps for Beginners - Calling Function Across Screens in PowerApps
If you haven't watched part 1 (Functions in PowerApps: https://youtu.be/Y2LoHZBAm94) then please do so before proceeding with this video.

In this video, you will learn how to call a 'function' across screens. With PowerApps, activating a control in another screen is not possible with just changing default value to create an 'On Change' run.

This video shows you that very issue and providing you a good solution for it.

Functions or reusable set of codes/instructions help make your app more efficient.

06/23/2022

PowerApps for Beginners - Combo Box Type in Choice

In this video, you will learn how to obtain new choice for the Combo Box and write the new choice back to SharePoint list.

06/05/2022

Oh so satisfying. 100 lines cleared with 25 consecutive Tetris.

06/05/2022

(20220604) Pure Tetris Happiness - Amazing Level 23 Line 220 Score 440,262 (Video speed x2)
Beautiful Tetris. 25 consecutive Tetris made.
Cleared 220 lines. Level reached: 23. Overall score: 440,262.

05/24/2022

In this video, I will go over the steps to create nice looking dialog box and pop up screen with data cards inside a scrollable control.

Here is the URL to YT, in case you need: https://www.youtube.com/watch?v=vgujBHRvHPY

My goal is to give you the information you want quick so you can get back to your work; therefore, it is fast :) My intention isn't to keep you on the video for too long. If you appreciate that and would like to buy a coffee for my effort :) here is the link https://www.paypal.com/donate/?hosted_button_id=KXUX8KWVE6WXJ

05/22/2022

In this video, I will go over some of the common & useful functions.
Here is the link to YT in case you need: https://www.youtube.com/watch?v=FwyV1eMKs2w

IsBlank(), Trim() & Len(),
Left(), Mid(), Right() & Find()
Upper(), Lower(), Proper()
Text(DateValue(Date_txt), "mm/dd/yyyy")
Text(Value, "[$-en-US]$ #, #0.00"): Format Dollar
Text(Value(varNumber1), " #, #"): Format Whole Number
Text(Value(varNumber2), " #, #.00"): Format Number w/ Decimals
Notify(), Reset()
Char(10): Line break,
Char(160): A space

Here is the link to PowerApps for Beginners - Textbox Control
https://youtu.be/Kc6jae1IQ2w

Here is the link Text format
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-text

My goal is to give you the information you want quick so you can get back to your work. Never my intention to keep you on the video for too long. If you appreciate that and would like to buy a coffee for my effort :) here is the link https://www.paypal.com/donate/?hosted_button_id=KXUX8KWVE6WXJ

05/18/2022

This video shows various ways to format Textbox control with date, money & numbers.

Here is the URL to YT, in case you need: https://www.youtube.com/watch?v=Kc6jae1IQ2w

It has many extra tips and tricks, so please enjoy.

Here is the OnChange for to ensure user entered date format

If(!IsBlank(Self.Text) && IsMatch(Self.Text,"(0[1-9]|1[012])[- \/.](0[1-9]|[12][0-9]|3[01])[- \/.](19|20)\d\d"),
Set(varDate, DateValue(Self.Text))
,
Reset(Date_txt);
Notify("Please enter valid date", NotificationType.Error, 2000)
)

Default to format Dollar
Text(Value(varDollar), "[$-en-US]$ #, #0.00")

Default to Format whole number
If(Value(varNumber1) = 0,
"0"
,
Text(Value(varNumber1), " #, #")
)
Default to Format decimal number
If(Value(varNumber2) = 0,
"0.00"
,
Text(Value(varNumber2), " #, #.00")
)

My goal is to give you the information you want quick so you can get back to your work. Never my intention to keep you on the video for too long. If you appreciate that and would like to buy a coffee for my effort :) here is the link https://www.paypal.com/donate/?hosted_button_id=KXUX8KWVE6WXJ

05/17/2022

PowerApps for Beginners - Control: People Picker 1of2
Here is the URL to YT, in case you need: https://www.youtube.com/watch?v=979nu6VqUwY

This video walks through the process of creating a People Picker that allows users to search and select people within the O365 environment.

It has many extra tips and tricks, so please enjoy.

Here is the link to the extended version where I show you a better practice in using & storing selected person
https://youtu.be/DG4w1B-Joro

My goal is to give you the information you want quick so you can get back to your work. Never my intention to keep you on the video for too long. If you appreciate that and would like to buy a coffee for my effort :) here is the link https://www.paypal.com/donate/?hosted_button_id=KXUX8KWVE6WXJ

05/17/2022

PowerApps for Beginners - Control: People Picker 2of2
Here is the URL to YT, in case you need: https://www.youtube.com/watch?v=DG4w1B-Joro

This is the an extended version of the People Picker video. This approach uses the Textbox control to show previously saved/selected person. That way, the data can still be pulled/showed on the form even when the selected person is no longer an active user on the O365 environment.

My goal is to give you the information you want quick so you can get back to your work. Never my intention to keep you on the video for too long. If you appreciate that and would like to buy a coffee for my effort :) here is the link https://www.paypal.com/donate/?hosted_button_id=KXUX8KWVE6WXJ

05/10/2022

[A&A Inomatic LLC] PowerApps Tips & Tricks 003 Using Nested Galleries (Gallery inside a Gallery) to display 3 records per row. This approach will allow you to display your data both horizontally & vertically.

https://www.youtube.com/watch?v=_Jvh98T9Jek

Address

Clifton, VA
20124

Website

Alerts

Be the first to know and let us send you an email when A&A Inomatic LLC posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Establishment

Send a message to A&A Inomatic LLC:

Shortcuts

Share