cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenDonahue
Skilled Sharer
Skilled Sharer

Accessing data in an Excel table

I am trying to access data in an Excel table to use in several ways to complete an audit made by several people regarding several other people; one form per audit, several audits to be made by each auditor. If function, this is much like a survey.

 

In a pre-populated table in Excel, there will be:

1. Email addresses

2. Unique data to be populated into the audit form, specifying who is being audited

3. Columns to hold the responses to the audit questions

 

The workflow: (I am not married to this)

1. Auditors receive an email with a link to the form.

2. The form contains:

   a. The ID of the person being audited

   b. The email address of the auditor

   c. The questions being asked

   d. the allowable answers for each question (all are required)

3. The the form is submitted, the answers are in the same row with the ID of the person being audited.

 

I had not thought this would be Forum-worthy, but I'm having trouble finding a course or doc or video to help me. 

I REALLY appreciate your help.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi again!

No, you are reading right, it was me that misunderstood your requirements.

So you are looking for a way to distribute a form, and some of the responses should be already filled in (and not editable by end user)...

I would discard Microsoft Forms and explore an alternate form interface based on a either PowerApps or Adaptive Cards

Nice challenge you got in mind... Happy Flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

4 REPLIES 4
efialttes
Super User
Super User

Hi!

Did you consider this approach?

https://flow.microsoft.com/en-us/galleries/public/templates/a8fe18d6de56498686db35d5cbde5a8a/track-m...

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@efialttes ,

That solution does not seem to meet any of my requirements, most notably:

The solution you recommend does not send a form with pre-populated and read-only information. I need the form to have read-only fields that are derived from an Excel sheet to give context to the audit. This will be a name or id number that will then be looked up elsewhere.

As the Excel sheet is already created, with a row for each response, there would be no Add a Row, but instead would only use Update a Row.

 

Unless I am reading it wrong. Can you please elaborate?

Hi again!

No, you are reading right, it was me that misunderstood your requirements.

So you are looking for a way to distribute a form, and some of the responses should be already filled in (and not editable by end user)...

I would discard Microsoft Forms and explore an alternate form interface based on a either PowerApps or Adaptive Cards

Nice challenge you got in mind... Happy Flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

This does not seem, to me, to be a very complicated process, and I am disappointed in Microsoft in this MVP version of what, I hope, will be a far more robust Forms in soon-to-be-released updates.

I can access data in a form and dynamically apply that data elsewhere in the Flow, and quite easily. Similarly, in "Get a row," I can direct Flow to a table in an Excel sheet. However, astonishingly, after doing so, there is no way to access the data in the referenced table.

It boggles the mind.

I am very appreciative of your help. I have been banging my head against this for more days than I care to admit, refusing to believe the truth of this lack of functionality. Now, at least, I can give up on Forms and move on to a usefully robust application. 

Thank you for your help.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,979)