We are using different Microsoft Forms which are interlinked and have many of repetitive data. This is used in sales process.
There are 2-3 departments and 4-5 forms data involved in it.
Groups Involved
1- Sales
2- Back Office
3- Data Entry team
4- Customer
Want to create a workflow using Power Automate or Power App for creating Sales process flow. Where multiple groups and multiple quotes are involved for same SKU and with high traffic. Backend teams are generating multiple quotes for same SKU for different companies and Sales Team is coordinating with Customer. Both team need better tracking - what they have prepared, what is shared with customer, Revision required if any for customer and Sales approved by client.
We are storing Microsoft form data into SharePoint list.
The issue we are facing is
1- How to Allow user on Field level edit rights (Not row level, so they cannot accidently delete the records)
2- how to auto populate the data from Multiple SharePoint list into single, based on Primary Key (Unique Field)
3- Problem facing in fetching the Attachments to SharePoint list - Need the easiest way to fetch multiple attachments to SharePoint list and power APP.
4- In power app - How to show data from multiple list based on the input values. For example - Based Customer Name/ Mobile number - Pull the Data from list 1, List2 and List3 basis of Mobile numbers and update records as well.
Problem in View from multiple List and Update both.
If there is any alternate way to create organizational level workflow for such process, please advise