How to Preembed loan account details in Microsoft forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1579939%22%20slang%3D%22en-US%22%3EHow%20to%20Preembed%20loan%20account%20details%20in%20Microsoft%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1579939%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20loan%20details%20file%20(Sample%20File%20attached).%20I%20want%20to%20get%20calling%20and%20visit%20feedback%20from%20each%20of%20my%20team%20members%20against%20each%20loan%20details.%20For%20these%2C%20I%20am%20using%20calling%20and%20visit%20Feedback%20survey%20forms%20-%26nbsp%3B%26nbsp%3B%26nbsp%3B%3CA%20title%3D%22Link%3A%20https%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3DDQSIkWdsW0yxEjajBLZtrQAAAAAAAAAAAAMAANImaP9UMUdMWlQxMUYyV0QwTjNDTzY4QkRORDdZVC4u%22%20href%3D%22https%3A%2F%2Fforms.office.com%2FPages%2FResponsePage.aspx%3Fid%3DDQSIkWdsW0yxEjajBLZtrQAAAAAAAAAAAAMAANImaP9UMUdMWlQxMUYyV0QwTjNDTzY4QkRORDdZVC4u%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EFeedback%20Link%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20want%20to%20design%20a%20process%20where%20I%20can%20pre%20embed%20loan%20account%20details%20in%20the%20Microsoft%20forms.%20I%20don't%20want%20my%20team%20member%20to%20manually%20enter%20the%20loan%20details%20provided%20in%20the%20excel%20file.%20For%20Eg.%20If%20there%20are%203000%20loan%20accounts%2C%20my%20team%20member%20has%20to%20entre%20each%20time%20loan%20numbers%20in%20each%20form%20which%20is%20time-consuming%20and%20will%20be%20error-prone.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20that%20this%20might%20be%20possible%20through%20power%20apps.%20Power%20Flow%20or%20Power%20Automate.%20But%20don't%20know%20how%20to%20do%20the%20same.%20Please%20assist.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1579939%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have a loan details file (Sample File attached). I want to get calling and visit feedback from each of my team members against each loan details. For these, I am using calling and visit Feedback survey forms -   Feedback Link

I want to design a process where I can pre embed loan account details in the Microsoft forms. I don't want my team member to manually enter the loan details provided in the excel file. For Eg. If there are 3000 loan accounts, my team member has to entre each time loan numbers in each form which is time-consuming and will be error-prone. 

I believe that this might be possible through power apps. Power Flow or Power Automate. But don't know how to do the same. Please assist. 

0 Replies