I have a power app uses two premium connectors Runs a sql server stored procedure Saves a file to azure storage Both of these actions are carried out by flows when the user clicks a button I am writing a power automate to copy emails from an outlook mailbox to sharepoint I am using get emails (v3) and want to retrieve emails received on a particular date.
0 creating a flow in power automate New step choose the onedrive get file content action file = /documents/folder/file.json infer content type = yes new step choose the data operation parse json action generate from sample paste the file contents done when i test the flow, the parse json step fails with badrequest. In power automate, within the power bi connector, you'll find the run a query against a dataset action This can only return one table at a time with max of 1,000 rows. Is this just part of the building process Or if i have one query a that loads across the network and 5 follow up queries that refer to query a will power query / excel be reading the across the network 1 time or five times
Using “power query” this has similar issues to 2, that it won't allow power automate variables I want to add working days only to a date column and skip weekend days (saturday & sunday) in excel power query i have a date column & a column with transit days, my
OPEN
