Claim Expense Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-3215852%22%20slang%3D%22en-US%22%3EClaim%20Expense%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3215852%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20build%20a%20FORM%20similar%20to%20what%20I%20can%20do%20in%20Excel%20with%20our%20Claim%20Forms%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Excel%3CBR%20%2F%3EId%20%7C%20Claim%20Date%20%7C%20Description%20of%20Expenditure%20%7C%20Amount%3CBR%20%2F%3EYou%20can%20enter%20as%20many%20items%20as%20you%20want%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Forms%3CBR%20%2F%3EI%20want%2C%20after%20entering%20the%20first%20row%2C%20to%20allow%20the%20user%20to%20enter%20another%20row%20when%20it%20is%20required%20and%20to%20submit%20the%20form%20otherwise%2C%20e.g.%3B%3CBR%20%2F%3EId%20%7C%20Claim%20Date%20%7C%20Description%20of%20Expenditure%20%7C%20Amount%3CBR%20%2F%3E1%20%7C%2001%2F01%2F2022%20%7C%20Hotel%20%7C%20%24500%3CBR%20%2F%3E2%20%7C%2001%2F01%2F2022%20%7C%20Meal%20%7C%20%24100%3CBR%20%2F%3E....%3CBR%20%2F%3Euntil%20no%20more%20expenditure%20to%20claim.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20Forms%20can%20handle%20loops%20like%3A%3CBR%20%2F%3EWhile%20%22no%20more%20expense%22%20enter%3CBR%20%2F%3EId%20%7C%20Claim%20Date%20%7C%20Description%20of%20Expenditure%20%7C%20Amount%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3ERepeat%3C%2FP%3E%3CP%3EId%20%7C%20Claim%20Date%20%7C%20Description%20of%20Expenditure%20%7C%20Amount%3C%2FP%3E%3CP%3Euntil%20%22no%20more%20expense.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3215852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eclaims%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3216122%22%20slang%3D%22en-US%22%3ERe%3A%20Claim%20Expense%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318358%22%20target%3D%22_blank%22%3E%40David_SG%3C%2FA%3E%26nbsp%3Bno%2C%20forms%20cannot%20handle%20loops%2C%20it%20is%20a%20simple%20one-pass%20form.%20So%20you%20would%20either%20need%201%20form%20to%20be%20submitted%20for%20each%20row%20or%20you%20could%20create%20sections%20in%20the%20form%2C%20with%201%20section%20for%20each%20row%20and%20use%20branching.%20The%20way%20that%20would%20work%20is%20that%20on%20the%20first%20screen%20you%20would%20have%20questions%20for%26nbsp%3B%3CSPAN%3EClaim%20Date%20%2C%20Description%20of%20Expenditure%26nbsp%3B%20and%20Amount.%20Then%20a%20choice%20question%20%22Do%20you%20have%20another%20claim%20to%20submit%3F%22%20If%20the%20answer%20is%20yes%20the%20branching%20would%20take%20the%20user%20to%20the%20next%20section%20with%20the%20same%20set%20of%20questions.%20If%20the%20answer%20is%20no%2C%20in%20the%20branching%20you%20would%20select%20End%20of%20Form%20so%20the%20user%20would%20see%20the%20submit%20button%20instead%20of%20going%20on%20to%20any%20other%20sections.%20Again%2C%20if%20the%20answer%20to%20the%20%22do%20you%20have%20another%20claim%20to%20submit%3F%22%20is%20yes%20the%20user%20would%20be%20taken%20to%20the%20next%20section%2C%20or%20if%20no%20to%20End%20of%20Form.%20To%20reduce%20the%20work%20you%20need%20to%20do%20you'd%20probably%20want%20to%20limit%20it%20to%20a%20maximum%20of%2010%20sections.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to build a FORM similar to what I can do in Excel with our Claim Forms:

 

In Excel
Id | Claim Date | Description of Expenditure | Amount
You can enter as many items as you want

 

In Forms
I want, after entering the first row, to allow the user to enter another row when it is required and to submit the form otherwise, e.g.;
Id | Claim Date | Description of Expenditure | Amount
1 | 01/01/2022 | Hotel | $500
2 | 01/01/2022 | Meal | $100
....
until no more expenditure to claim.

 

I don't know if Forms can handle loops like:
While "no more expense" enter
Id | Claim Date | Description of Expenditure | Amount

or

Repeat

Id | Claim Date | Description of Expenditure | Amount

until "no more expense."

 

Thanks

 

2 Replies

@David_SG no, forms cannot handle loops, it is a simple one-pass form. So you would either need 1 form to be submitted for each row or you could create sections in the form, with 1 section for each row and use branching. The way that would work is that on the first screen you would have questions for Claim Date , Description of Expenditure  and Amount. Then a choice question "Do you have another claim to submit?" If the answer is yes the branching would take the user to the next section with the same set of questions. If the answer is no, in the branching you would select End of Form so the user would see the submit button instead of going on to any other sections. Again, if the answer to the "do you have another claim to submit?" is yes the user would be taken to the next section, or if no to End of Form. To reduce the work you need to do you'd probably want to limit it to a maximum of 10 sections.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thanks Rob for this detailed explainantion