I'm attempting to make a power app that the user inputs an IP address and then other fields will define where the sequential IP addresses go. I've done this successfully in Excel by doing =TEXTSPLIT(B2,,{"."}) where B2 is the user defined IP address. Then another field would concatenate them and add x number to the last octet. =CONCATENATE(G25,".",G26,".",G27,".",G28+4)
I've been trying to use the SPLIT function with zero success. Ideally I'd like to both split and concatenate the user input IP in the same text input that would display my results.
First(Split("PRI_WAN_NET","_" ")).Result
Broad overview. I want the user to input "192.168.1.0" network IP into a field and then about 10 other fields would auto populate with 192.168.1.1, 192.168.1.2, 192.168.1.3, etc in their appropriate fields.