New Row Input

%3CLINGO-SUB%20id%3D%22lingo-sub-679852%22%20slang%3D%22en-US%22%3ENew%20Row%20Input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679852%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20building%20a%20form%20to%20automate%20our%20return%20for%20credit%20process.%20I%20would%20like%20to%20add%20a%20question%2C%20'Item%2Fs%20Returned'%20but%20I%20would%20like%202%20text%20inputs%2C%20one%20for%20the%20part%20number%20and%20a%20second%20for%20the%20quantity.%20I%20would%20like%20to%20also%20have%20a%20button%20for%20the%20respondent%20to%20add%20a%20new%20row%20to%20add%20additional%20items.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThe%20long%20term%20goal%20is%20to%20use%20MS%20Flow%20to%20create%20an%20iDOC%20which%20I%20can%20use%20as%20a%20EDI%20connection%20to%20SAP.%20I%20could%20use%20a%20long%20answer%20text%20field%20and%20just%20ask%20the%20respondent%20to%20enter%20the%20part%20number%20and%20quantity%20but%20I%20will%20get%20data%20entered%26nbsp%3Bin%20different%20formats.%20This%20will%20make%20it%20hard%20to%20get%20data%20straight%26nbsp%3Binto%20SAP.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20this%20possible%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686356%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Row%20Input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686356%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357288%22%20target%3D%22_blank%22%3E%40Gavin_Grech%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EForms%20can't%20do%20it%20to%20that%20extent%20although%20you%20could%20specify%20fields%20as%20Number%20(which%20might%20help%20if%20there's%20no%20Alphanumeric)%2C%20but%20PowerApps%20could%20be%20the%20way%20to%20go%20as%20you%20can%20specify%20the%20inputs%20and%20control%20the%20integrity%20with%20some%20tweaks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYouTube%20and%20search%20engines%20will%20have%20lots%20of%20content%20around%20how%20to%20do%20it%20step%20by%20step.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20makes%20sense%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am building a form to automate our return for credit process. I would like to add a question, 'Item/s Returned' but I would like 2 text inputs, one for the part number and a second for the quantity. I would like to also have a button for the respondent to add a new row to add additional items.

 

The long term goal is to use MS Flow to create an iDOC which I can use as a EDI connection to SAP. I could use a long answer text field and just ask the respondent to enter the part number and quantity but I will get data entered in different formats. This will make it hard to get data straight into SAP.

 

Is this possible?

1 Reply
Highlighted

Hi @Gavin_Grech 

 

Forms can't do it to that extent although you could specify fields as Number (which might help if there's no Alphanumeric), but PowerApps could be the way to go as you can specify the inputs and control the integrity with some tweaks.

 

YouTube and search engines will have lots of content around how to do it step by step.

 

Hope that makes sense?

 

Cheers

Damien