Feeding a Forms spreadsheet into OneDrive by Power Automate.

%3CLINGO-SUB%20id%3D%22lingo-sub-3017757%22%20slang%3D%22en-US%22%3EFeeding%20a%20Forms%20spreadsheet%20into%20OneDrive%20by%20Power%20Automate.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017757%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20we%20create%20a%20form%20in%20Microsoft%20Forms%20it%20automatically%20generates%20a%20column%20%22Name%22%20and%20another%20%22Email%22%2C%20which%20refer%20to%20the%20%22name%22%20and%20%22email%22%20of%20the%20logged%20in%20user%20or%20who%20is%20responding%20to%20the%20form.%20In%20my%20case%2C%20I%20created%20a%20file%20in%20Excel%2C%20added%20it%20to%20Onedrive%20and%20via%20Power%20Automate%20created%20the%20form's%20data%20feed%20in%20that%20file.%20It%20turns%20out%20that%20this%20column%20%22Name%22%20which%20is%20automatically%20generated%20by%20forms%2C%20does%20not%20appear%20for%20us%20to%20use%20in%20Power%20Automate%20and%20we%20feed%20this%20file%20that%20is%20on%20OneDrive%2C%20can%20anyone%20tell%20me%20how%20to%20solve%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3017757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEducation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3018625%22%20slang%3D%22en-US%22%3ERe%3A%20Feeding%20a%20Forms%20spreadsheet%20into%20OneDrive%20by%20Power%20Automate.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3018625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1233438%22%20target%3D%22_blank%22%3E%40FLAVIO_O_C_S%3C%2FA%3E%26nbsp%3Byou%20can%20add%20an%20%3CSTRONG%3EOffice%20365%20Users%3C%2FSTRONG%3E%20action%20into%20your%20flow%20with%20the%20input%20being%20%3CEM%3EResponder's%20Email%3C%2FEM%3E.%20And%20from%20that%2C%20in%20the%20dynamic%20content%20box%20you%20can%20get%20the%20Given%20Name%20and%20Surname%20of%20the%20responder%20to%20use%20in%20subsequent%20actions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When we create a form in Microsoft Forms it automatically generates a column "Name" and another "Email", which refer to the "name" and "email" of the logged in user or who is responding to the form. In my case, I created a file in Excel, added it to Onedrive and via Power Automate created the form's data feed in that file. It turns out that this column "Name" which is automatically generated by forms, does not appear for us to use in Power Automate and we feed this file that is on OneDrive, can anyone tell me how to solve it?

1 Reply

@FLAVIO_O_C_S you can add an Office 365 Users action into your flow with the input being Responder's Email. And from that, in the dynamic content box you can get the Given Name and Surname of the responder to use in subsequent actions.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User