Share
Report
51Hello Everyone,
I have the functionality to create,
Current Scenario -
i have a canvas app, which has form control in Screen 1 & Editable like grid view in Screen 2.
In Screen 1, That form control has 10-15 columns in it, that to filled by the user,
And
In Screen 2, that Grid view has 8-10 columns or we call it, "Line Items", & these line items would be up to 50
-> My users do receive these data values on 2 different Excel file, 1 sheet contains content related "Screen 1" Column & Another file contain All line items data for "screen 2" from their vendor, in a nice format, every weak.
-> & my User do fill that Particular Data & save it in Power App, & then Approval Routing begins.
-> Now, my user are feeling lazy or something, what they have requested is,
HELP
# can we do something to this Powerapp, so that we simply select that Excel file from our local System or through the Onedrive location, & then some magic will happen, & all data should filled automatically to that form Control,
Same to be done for line items, like user select the excel file, & then some magic should happen, & screen 2 data should filled automatically.
# and after that user will manually click on save button after verifying from his eyes, that all the data is filled automatically is correct or not.
PS: in this All columns might not be of the same data type, some column might be single line of text, some as choice, some as date column, some as multiline,
Please advise can we do this kind of functionality made available in the canvas app.
This will surely save my user time, a lot.
All responses (
Answers (
