Workflow (Forms, Sharepoint, Power BI, flow)

%3CLINGO-SUB%20id%3D%22lingo-sub-2535283%22%20slang%3D%22en-US%22%3EWorkflow%20(Forms%2C%20Sharepoint%2C%20Power%20BI%2C%20flow)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535283%22%20slang%3D%22en-US%22%3E1%20user%20fills%20forms%2C%202nd%20user%20able%20to%20see%20all%20the%20resonses%20from%20the%20forms%20and%20respond%20to%20individual%20responses%20(%202nd%20user%20should%20be%20able%20to%20see%20all%20pending%20tasks%20for%20which%20actions%20are%20required).%20Actions%20can%20be%20in%20Microsoft%20forms.%3CBR%20%2F%3EAnd%20in%20the%20End%2C%20the%20xompiled%20items%20to%20be%20reported%20in%20Power%20BI%20as%20dashboard%20with%20refresh%20on%20every%20forms%20submission.%3CBR%20%2F%3EI%20would%20like%20to%20know%20if%20this%20would%20be%20possible.%20If%20yes%2C%20let%20me%20know%20the%20flow%20between%20apps.%3C%2FLINGO-BODY%3E
Occasional Visitor
1 user fills forms, 2nd user able to see all the resonses from the forms and respond to individual responses ( 2nd user should be able to see all pending tasks for which actions are required). Actions can be in Microsoft forms.
And in the End, the xompiled items to be reported in Power BI as dashboard with refresh on every forms submission.
I would like to know if this would be possible. If yes, let me know the flow between apps.
2 Replies

@VaishnavM if I was doing this it would all revolve aound a SharePoint list. The form response and user info would be saved into the list via a flow in Power Automate. The permissions on the list should be set so that User 2 can see all the responses. You could then have an additional column in that list for User2's response and a JSON-formatted button to strigger a flow that sends the response back to the original submitter. The list would be the data source for the dashboard in Power BI.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Can you please send me detailed steps on how to do the above please, as I am new to this field
Kind regards
Brian